Excel 07 Professional and Windows Vista - Excel Workbook taking longer to open and save each time.

[VPB]

I'm not sure where I need help out with, I know enough about excel to make people wonder why I even bother. I have one workbook with several sheets, some VBA I've picked up, lots of macros. I am not sure how to explain it and can't seem to find a good place to upload it so others can see and or review it. Can anyone tell me how to attach it to my post here, I don't mind uploading the entire workbook, I've generalized the saved data so there is no personal information in it.

 

[Paradigm_Shift]

Something similar happened to me once. It was because I had formatting (fill, border, text color, etc) in every cell in multiple sheets...that's millions and millions of cells...the file size can increase fast. Another time I had this problem was due to some bug with the ActiveX controls in excel.

If you aren't using ActiveX controls, your file size, for some reason, might be increasing each time you save the file. Below is a link that might help you resolve your problem in any case:

http://www.ozgrid.com/Excel/ExcelProblems.htm

Hope that helps.