View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to shrink file sizes after eliminating worksheets in file

Check out Debra Dalgleish's site for tips on resetting the used range on a
sheet.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Thu, 27 Jul 2006 07:43:03 -0700, Sandals
wrote:

My file sizes get rather large and not easy to send out via e-mail. I have
tried to delete worksheets that are not needed , including pivot tables and
charts. Is there some utility available that can get rid of the unused space
and make the file sizes manageable? Any tips or suggestions are welcome.
Thank you