I get 100 spreadsheets to check for resetting the usedrange.
Do you have any suggestions on how to create one spreadsheet to reset the
usedrange for a number of spreadsheets without manually inserting
DeleteUnused code on each sheet?
Thank you for any suggestions
Eric

"Dave Peterson" wrote:

This may help.

Debra Dalgleish does share some techniques for resetting the usedrange:
http://contextures.com/xlfaqApp.html#Unused



Eric wrote:

I get a spreadsheet about 4.6 MB, and try to delete any useless formula for a
table A2:K1000, but I get no idea why the file size for this spreadsheet
increases from 4.6MB to 5.6 MB, which does not make any logical sense.
Will I create some garbage information when I delete those table's formula?
Does anyone have any suggestions?
Thanks for any suggestions
Eric

--

Dave Peterson