in excel 2007 is it possible to refresh just one pivot table within a large file if you have multiple sheets and multiple pivot tables that are all pulling from one data source?
in excel 2007 is it possible to refresh just one pivot table within a large file if you have multiple sheets and multiple pivot tables that are all pulling from one data source?
AFAIK you would need to use separate caches.
Last edited by DonkeyOte; 10-25-2010 at 11:42 AM. Reason: repetition
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
at my old job we had a large selling report, and used xl 2007 and we set it up that we could update each sheet individualy - just in case we didn't receive new data for all of the clients/sheets - the info pulled wouldn't zero out. I just can't remember how we set it up...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks