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

Making a file smaller
 

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

Making a file smaller
 

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

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