Reducing the size of an xls file with pivot charts

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

Guest

Dear experts,
I have an xls file which contains 4 different pivot charts, which all point
to the same database.
The first time I created the spreadsheet I could tell Excel to use the same
database for all tables, so the size of the document was OK; when I added
lines of data, I had to change the range of every table, and I found no
option to tell Excel that it is the same database for all of them. The
spreadsheet went from 3 to 6 Mb!

As I need to add lines of data every month, I am afraid that the file might
become huge...
Do you have a solution?
Many thanks,
Best regards,
 
The one feature that justifies upgrading to Excel 2003 (at least for me,
because I don't do all that new XML stuff), is the new Data List
feature. If you define a region of data as a list, anything that points
to that list will adjust automatically as the list is expanded or
contracted. Pivot tables, charts, other formulas, it's really great.

If you don't have 2003, then Ed's technique is just as effective, and
only takes a minute longer.
/ sig
 
Back
Top