Hello all, we have a workbook with a large data table that has a pivot based on that table. We delete the sheet containing the data set to reduce the size of the file since the pivot has it in cache. In office 360 (I dont recall it previously happening, but maybe it did), upon opening the file, users get a "cannot open pivot table source file warning/error". Everything works, but id like to eliminate that error. Anything that can be done within the file, beyond changing external links settings in every users instance of Excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Deleted Pivot Cache Warning
- Thread starter cwpyrant
- Start date
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Similar threads
- Question
- Replies
- 10
- Views
- 1K
- Replies
- 5
- Views
- 151
- Question
- Replies
- 4
- Views
- 316
