Email a Pivot Table

Question

I just tried this as an experiment and it seems to work, but want to confirm. I am designing a system for my supervisor.

I have a workbook with a table on one sheet, and a sheet with 3 pivot tables with slicers on a second sheet. The end user of this workbook will need to email the sheet with pivot tables to another individual weekly. No servers involved here (but that's another issue.)

I copied the pivot table sheet to a new workbook and emailed it to my personal account and opened it at home. The slicers all appear to be working, even though the data source is no longer connected. Will this hold true?

Obviously any updating to the data source would not transfer after the sheet had been sent, but am surprised the pivots still work. Can someone explain this to me?

Thanks.

Answer 1

Hi,

The reason the pivot still works is that the pivot table has not been created from the data in the other sheet of the original workbook but from a mirror image (called pivot cache) of the data in the other sheet.

Answer 2

You are welcome.

Answer 3

Ah, thank you for the explanation. This will help with my future designs.