Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to shrink file sizes after eliminating worksheets in file

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default How to shrink file sizes after eliminating worksheets in file

Have you tried to zip the file before sending?






"Sandals" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
One file splitted into worksheets Heine Excel Worksheet Functions 0 March 9th 05 11:23 AM
multiple worksheets in html - one file Mikael Excel Discussion (Misc queries) 0 March 3rd 05 07:55 PM
How to recover worksheets lost when I opened an Excel file in Wor. Steviek1 Excel Worksheet Functions 0 January 23rd 05 10:53 PM
How to protect and unprotect 30 worksheets in a file every month . Protect & Unprotect Several Worksheets Excel Worksheet Functions 4 January 10th 05 01:29 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"