Problem reducing Excel 2007 file size

  • Thread starter Thread starter Intuitive Analyst
  • Start date Start date
I

Intuitive Analyst

We have a largish 2007 xlsx from which we deleted large chunks of validation
and formatting which were no longer needed. After a save (even a "save as" to
a new file), the file size did not change! Any idea of what's going on here
or what we could do to reduce the size of the file? Thanks in advance!
 
go to each sheet and check what the last cell is -- perhaps there are some
erroneous last cells --delete rows & columns after the "real" last cell.
 
Thanks for the suggestion. We've already done that. What I'm wondering is
why, after very clearing deleting a lot of extra formatting and validation,
the file size does not change at all. Thanks.
 
You must save the workbook before you will see any changes to the used range
after deleting unused rows and columns.


Gord Dibben MS Excel MVP
 
Thanks. I believe I mentioned that I saved and even "saved as" to a new
file, both without success.
 
Back
Top