Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i compack the excel workbook ?
Does the excel sheet likes access can be compact the file size ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i compack the excel workbook ?
No.
Tom wrote: Does the excel sheet likes access can be compact the file size ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) |