Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default How do i compack the excel workbook ?

Does the excel sheet likes access can be compact the file size ?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How do i compack the excel workbook ?

No.

Tom wrote:

Does the excel sheet likes access can be compact the file size ?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default How do i compack the excel workbook ?

Excel doesn't have the Compact feature like Access does, but sometimes it
seems to need one.

Your file can grow quite large during use if you add lots of information to
one or more sheets in it and then delete the information without actually
deleting the rows and/or columns that it occupied. You can end up with what
looks like a relatively empty workbook that occupies megabytes of
memory/drive space.

Debra Delgleish has some helpful information on reducing the size of files
in those kinds of situations. See
http://www.contextures.com/xlfaqApp.html#Unused
that has the seemingly unrelated title of
Why do my scrollbars go to row 500 -- my data ends in cell E50?
but it is spot on about this issue.


"Tom" wrote:

Does the excel sheet likes access can be compact the file size ?

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
Excel-how to link source workbook to copy of destination workbook D Lynn Excel Worksheet Functions 1 May 29th 08 05:36 PM
when opening an Excel Workbook, another blank workbook also opens Gord Dibben Excel Discussion (Misc queries) 0 October 12th 07 09:49 PM
when opening an Excel Workbook, another blank workbook also opens spmu Excel Discussion (Misc queries) 0 October 12th 07 01:46 PM
Excel workbook is corrupted, workbook automatically saves on start Paul Gooda Excel Discussion (Misc queries) 3 September 28th 06 04:51 PM
link Access workbook to Excel workbook Toinett Excel Discussion (Misc queries) 1 January 31st 05 03:37 PM


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

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

About Us

"It's about Microsoft Excel"