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,
--
Valeria