Dear all
I hope someone can help me.
I have a pivot table and thought I had it all sorted but whenever I add more details on the data sheet it doesn't refresh for some reason.
Can someone tell me why that is please?
Dear all
I hope someone can help me.
I have a pivot table and thought I had it all sorted but whenever I add more details on the data sheet it doesn't refresh for some reason.
Can someone tell me why that is please?
Hi,
Have you defined your database as a dynamic range ...?
Debra has a clear explanation of how to do it ...
http://www.contextures.com/xlNames01.html#Dynamic
HTH
Hi Monique,
Attached is your file with a dynamic range for the Database ...
HTH
Last edited by JeanRage; 04-05-2010 at 04:15 PM. Reason: Updated File
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks