Is it possible to automatically delete a sheet after the report is created?
A report that we are building is building quite a lot of rows - like a million+ rows. NL("ROWS").
We are using a Pivot table to flexible analyze the data afterwards.
Since the Pivot table is based on its own Excel created database-like data created from our large row-set, it is perfectly fine to manually delete the datasheet, since the Pivot continues to work fine with its analyzing/drilling down capabilities.
Deleting the datasheet extensively reduces the size of the workbook and allows for easy distribution without loosing reporting flexibility in the Pivot.
Is there a way to achieve that auto-distribution of the workbook-report could delete the datasheet after building the report and the Pivot is updated?
Thanks in advance,
Optimizing report output by deleting data