Large, Slow Excel Workbook

[dgavin]

I have a large Excel workbook (about 70,000KB) and it takes ages to load and is slow to operate.

Is there anyway of compressing it or making it run faster and not slow down the computer?

 

[ZVI]

Thanks for posting that Vladimir --

That version appears to have kept all of my formatting, and netted me a 25K improvement -- but still only a 0.6% shrinkage. Guess my file wasn't very bloated...

Thank you for testing and feedback, SusaninHouston.

The main purpose of code is in clearing of extra formatting of the cells which are placed out of the data. Even if such cells are empty its formatting requires an extra memory.

Seems that it's not your case, therefore try to minimize usage at all and especially the alternation of different colors, fonts and styles in/of the cells, avoids applying of long formulas for large ranges (use named formulas or the macros instead) and avoids links to external workbooks.
Saving of Excel 2007 file in Binary format (as Excel Binary Workbook) shrinks its size and improves recalculations as well.

Regards,
Vladimir