Tips for Minimizing size of Pivot Table workbooks

  • Thread starter Thread starter shadestreet
  • Start date Start date
S

shadestreet

I have a workbook with 5+ pivot tables running independantly of on
another from a single worksheet. Right now the workbook is 50 MB, an
tips out there to minimize the size (other than having the pivot table
tie together).

thank
 
Hi,

Is the origin of the data in the same workbook? If so, you can move it to
other place and base the pivot tables on external sources.
If not, and this is really a major concern, you may create a blank workbook,
recreating each pivot table one by one using external source, and check the
file size with each addition. This way at least you will identify which of
the 5 tables are the ones that are making your file big, and may take
decisions upon that.

Hope this helps, the limitation of not tieing pivot tables is a hard one :)

Miguel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single Filter to change all Pivot Tables in a Workbook 8
pivot table data 2
Cannot Open Pivot Table Source File 0
Pivot Table Data Source 1
Duplicating Pivot Tables 2
Pivot tables - Editing the data source shared by multiple pivot ta 1
Issue selecting other worksheets 1
Use named table in workbook as source for pivot tbl in other workb 1

Back
Top