Any suggestions for large file size reduction?

Hi,

I have a document for work which has text and 9 macros, usually around 1mb.

The document keeps spiking to 7mb or 23mb sometimes, i have tried removing the formatting from the cells to the right and below of the workable area, although it is still no good.

The computers seem to struggle with these file sizes & the document seems to crash a lot.

Any help is kindly accepted, if possible i'd like to send the file to someone to have a look at?

Cheers,

Jack

1) Use the SELECT OBJECTS option and draw large selection areas, see if there are some hidden objects on the workbook that are being duplicated invisibly.

2) Instead of deleting formulas, do a CLEAR ALL on the cells outside the data range.

3) Conditional formatting rules can spin out of control


Here's an old macro I used a few times to reduce the filesize on some troublesome workbooks:

Please Login or Register  to view this content.