Making a file smaller

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

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

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

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