file has grown

  • Thread starter Thread starter dave graham
  • Start date Start date
D

dave graham

i have an excel 97 file which has suddenly grown from
about 800K to nearly 4MB, i don't know why.
it is a faily simple file, no formulas, just a big
sortable, filterable list really.
this is making it cumbersome to use across our WAN.
i wonder if it has something to do with recently including
a lot of comments?
any help to reduce it's size would be appreciated.
 
You may need to look at your files "Used Range."

This is the area of each sheet that you have been into,
and therefore Excel has to remember the whole sheet,
rather than the section you use.

I had a file that was 5.12mb, by fixing the used range it
shrunk to 3mb.

To make sure this is fixed on all sheets simply go to your
last row of data, select all the rows underneath (right
down to the bottom then delete all these blank rows. Then
save the workbook straight away.

Do this with all sheets, and for columns aswell and your
file size should decrease again.

There are, of course, other things that can cause file
sizes to increase, such as lots of formulas, large named
ranges etc.

At www.excelaid.com you can download a couple of add-ins
which can help with this. An analyser which looks at named
ranges, links, querytables etc... and a Workbook Mapper,
which converts each sheet in your workbook into a
colour "Map", identifying which cells are formulas,
errors, blank cells etc. This can identify where space is
wasted in your workbook.

Feel free to visit the site, or you can contact me
directly at (e-mail address removed).

Hope I have helped.

Steve
 
Is your workbook shared? If it does, the "change history" will also add up
to your file size. Try to unshared your workbook to delete change history.
If you and other user don't edit the file at the same time I won't recommend
sharing it again.

Hope this help.

Jon-jon
 
Back
Top