Thread: Why does File Size increase with reducing spreadsheet information?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Why does File Size increase with reducing spreadsheet information?
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
Reply With QuoteReply With Quote