You're not saving the file as one of those combo xl95/xl97&xl2k files are you?
(I bet not.)
I think that the one thing that's easy to fix that makes the filesize smaller is
resetting the lastused cell on each worksheet.
Debra Dalgleish has some notes and pictures at:
http://www.contextures.com/xlfaqApp.html#Unused
If hitting ctrl-End takes you way past what you think should be the last cell,
you'll want to check it out.
If you delete the pivottables/charts and save as a new name (don't destroy your
real copy), how big is that file.
If you rebuild the pivottables/charts and save, how big is that?
If the size after rebuilding is lots smaller, maybe keeping that will suffice.
Any chance you could convert the pivottable to values and rebuild the pivottable
and charts (via a macro) each day?
