Reduce file size in Excel

  • Thread starter Thread starter =?iso-8859-1?Q?M=E5rten?=
  • Start date Start date
?

=?iso-8859-1?Q?M=E5rten?=

I have a problem with an Excel file that keeps growing,
almost after every Save. And it does that, even if the
change in the spreadsheets or in the macros is very samll
or zero. I.e. changing a range in a macro or editing a
formula in a cell. I use Excel 2000. Any ideas on how to
reduce the file size?
 
Open it with the shift key down in another version of Excel, then save &
exit. File size could be down by as much as 40%!
 
Bob,

Sorry for all of the questions but your answer was intriguing!

What is occurring behind-the-scenes with your suggestion?

Why does the file size decrease?

What does one do if only one version of XL is available?

What if one saves the file as another version and opens it with the
shift key down?

What does the shift key down do?
 
You must log in or register to reply here.

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

reducing file size 3
reduce excel file size 1
Excel file Size 1
How do I reduce the file size in excel 2003 3
Reducing Excel File Size 1
If .xlsx is a zip archive, why does zipping it reduce file size? 5
Reduce File size 2
Reducing Excel File Size 2

Back
Top