Making a file smaller
Well, that's a big reduction!
Thanks for feeding back.
Pete
Dave wrote:
Pete, this helped a lot. It went from 35mb to 784kb! Thanks.
"Pete_UK" wrote:
Excel is not very good at resetting itself if columns or rows are no
longer used. Click in any sheet and do CTRL-End - this will take you to
the cell which Excel thinks is the last-used cell, although you may
find there are several unused columns and/or rows beyond your data. If
this is the case, then highlight the offending rows/columns and Edit |
Delete to remove them. Save the file immediately and repeat with other
sheets.
Named ranges which are no longer needed can also take up a lot of
memory - Insert | Name | Define to see a list of what you have and
delete each one (in turn) that you no longer need, especially those
that refer to another workbook and the ones with #REF (sheets, rows or
columns may have been deleted).
Hope this helps.
Pete
Dave wrote:
I have a spreadsheet that is 35mb in size and given the number of sheets and
calculations it should not be this big. It used to have a large number of
links in it that someone had put in, which I think contributed to the large
size. I broke those links but the size still will not come down.
Any suggestions or ideas of how I can easily compact or reduce the size of
this file?
Thanks in advance.
Dave
|