Reducing Excel File Size

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I need assistance in reducing a file size as it is now
about 10MB and it is difficult to work with as opening,
working with and save time are very, very slow.

There are arrays, macros, links, you name it to get this
file to work properly. I have tried to reduce the size
by breaking the links and deleting the macros before
distribution to help but somehow it is not making a
difference.

Can someone help provide some insight with what are the
size hogs in Excel? Also, if anyone knows why there is
limited change in size even when remove links and macros?

It is a really helpful spreadsheet but it's usefulness is
diminishing as it grows.

Thanks.
 
Donna,
I have two suggestions, and others will jump in with more.

1.) Get Bob Bovey's code cleaner to clean up the VBA stuff. VBA tends to
leave a lot of unwanted "stuff" behind. This helps to clean it up. Please
see the following link:

http://www.bmsltd.co.uk/MVP/MVPPage.asp

2) Fast Excel from Decision Models (http://www.decisionmodels.com/) has a
clean workbook utility that helps to reduce workbook bloat.

I hope that helps.

Best regards,
Kevin
 
Hi Donna

Check out this also


Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it

Don't save the file in two versions but only as Microsoft excel workbook
Not as 97-2002 & 5.0/95 workbook(this make your workbook big)
 
Back
Top