Excel File Size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large Excel file with maybe 9 worksheets. It is 4,361KB and there
is no way it should be that large. I have systematically deleted worksheets
and the file remains the same size. Is there some trick to getting Excel to
reduce the file size? Any thoughts appreciated. Thank you.
 
P.S. I have read & tried "manually reset the used range", but it does not help.
Michael
 
I'm having the same problem as the OP and have already tried the method
included in that FAQ.

Digging around some more on the internet, I found that someone suggested to
"always save in the latest and greatest file format". Since I'm using
Excel2007 in an office where most users are still using 2003, I have been
saving in the .xls format. I gave it a shot in the .xlsx format and the file
size was reduced from 28MB to 6MB. For a workbook that really doesn't have
that much data, it's still too big, but its a significant improvement.

I'm wondering though if there are any other workarounds aside from saving in
that file format that isn't compatible with a large part of my office.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Large File Size 3
Excel VBA - Problem with Closing Print Preview 0
How to clear up useless content within worksheet? 1
reducing file size 3
reduce excel file size 1
How do I compress a large file? 3
If .xlsx is a zip archive, why does zipping it reduce file size? 5
Reduce file size in Excel 2

Back
Top