Hi,
I have a number of separate worksheets in the same workbook, each containing a few pivots tables that refer to data in one large worksheet. I have two questions please:
(1) Each month I will need to refresh each of the dozens of pivot tables to take account of new data in the large worksheet referred to above. How do I refresh all of the pivot tables at once rather than doing it on a sheet-by-sheet or table-by-table basis?
(2) Using pivot tables seems to swell the size of the original data file a great deal. What is the best way to minimise the size effect of using pivot tables?
(other than, of course, using fewer!)
Many thanks!
Bookmarks