Ron,

I already have what you stated setup as Excel asks this question when you
create subsequent pivot tables from the same data source.

Any other suggestions please?

Regards,

--
----------------------------
Regards,
Richard Sterling
Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815
Avaya ECS Ltd, United Kingdom



"Ron Coderre" wrote:

In your post, you mention that you have 'many pivot tables on this data'.

Keep in mind that when you create a Pivot Table, Excel creates a hidden
cached copy of the source data and bases the Pivot Table on that. So if you
have a table with 10 columns and 40,000 rows....Excel will make a copy of
that table for each Pivot Table based on that table, bloating the size of
your workbook.....

Unless...you opt to base your Pivot Table on 'Another Pivot Table Report' on
Step 1 of the Pivot Table Wizard.

That will base the Pivot Table on the same cached copy of the data as the
original Pivot Table....NOT on the data displayed in the first Pivot Table
(as might easily be inferred by the selection text). Consequently, no
additional data cache will be created and the file size should drop
dramatically.

Does that help?


€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"rmsterling" wrote:

Got a workbook dragging in data from a database on to one worksheet.
Got another worksheet (in the same workbook) doing a pivot table on the data
dragged in on another worksheet.
There are many pivot tables on this data.
Workbook is so big now that I can refresh the pivot table (which has alot of
necessary rows and columns) but the workbook will not save. A memory error
occurs and I am forced to lose all work up until the previous save.

Can you offer any advise?

Thanks,

--
----------------------------
Regards,
Richard Sterling
Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815
Avaya ECS Ltd, United Kingdom