Problem reducing Excel 2007 file size

[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!

 

[Bob Umlas]

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.

 

[Intuitive Analyst]

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.

 

[Gord Dibben]

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

 

[Intuitive Analyst]

Thanks. I believe I mentioned that I saved and even "saved as" to a new
file, both without success.