Thanks, yes, I've learned several tricks about reducing file size since I started working with these reports. The thing that helped the most was upgrading to Excel 2010.
I have a large file (30 MB) with multiple worksheets, pivot tables and some VBA macros to update the pivot tables. I recently added some new worksheets and pivot tables. Went back to the file and found that somehow the number format of some columns and in most of the pivot tables had changed to...