How do you add a second pivot table against the same database in a way that
minimizes the total size of your file?

When you go through the pivot table dialog box, select the option to base
your second pivot table off your first pivot table. This way, the source
data table is used only once for both pivot tables.

My experience, by the way, is that unless you have a huge data table
(thousands of rows) running two pivot tables off separate instances of the
same data table does not really affect the file size/memory demands much.

Dave
--
Brevity is the soul of wit.


"Steve" wrote:

How do you add a second pivot table against the same database in a way that
minimizes the total size of your file?