Excel Sheet Compacting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Question, is there a way that I can "compact" an excel sheet, just like
access can be compacted. Reason is that I have this workbook with about
35worksheets, all pivot tables, I had to change the datasource to sql and now
the size of the sheet jumped to 500megs (it started off with 100megs). When
trying to save the sheet, it takes about 5 mins. Also there are about 45
pivot tables, none of them have the same datasource. was wondering, if
possible, maybe to save time and space, to change the source to one pivot
table but still show it as many times as I want.
 
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

Summary sheet 2
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Query then pivot table 6
Playing back a Pivot Table macros 2
How to update datasources of a pivot table ? 1
Pivot Table Question 2
How to change old data source reference from copied pivot table 1
Finding datasource in Excel worksheet 1

Back
Top