Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compact or Shrink down excel file
Is there a way to compact an excel file (similar to compacting a database in
MS Access). I currently have an excel file that continues to get bigger even though I have removed data from it. I have had this happen before and my solution was to copy all of the contents to a new excel workbook and the size was reduced dramatically. This time however, I have too many sheets to do this. Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compact or Shrink down excel file
On Jun 18, 10:31 am, James C.
wrote: Is there a way to compact an excel file (similar to compacting a database in MS Access). I currently have an excel file that continues to get bigger even though I have removed data from it. I have had this happen before and my solution was to copy all of the contents to a new excel workbook and the size was reduced dramatically. This time however, I have too many sheets to do this. Any thoughts? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compact or Shrink down excel file
James C. wrote...
.... solution was to copy all of the contents to a new excel workbook and the size was reduced dramatically. This time however, I have too many sheets to do this. I'd guess you mean you have too many sheets to make it practical or desirable to do it manually. So use a macro to do it. Record what you'd normally do, then generalize it. If you need help generalizing it, post a copy of the recorded macro in a follow-up. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compact or Shrink down excel file
James
What Excel thinks is the used range on a worksheet can increase over time with cells being added to then cleared, not deleted. To reset the used range on a sheet you can delete all unused columns and rows then save the workbook. To do many sheets at once would require a macro. Debra Dalgleish has such code at her site. http://www.contextures.on.ca/xlfaqApp.html#Unused Note the caveat about "merged cells" and how to deal with them. Gord Dibben MS Excel MVP On Mon, 18 Jun 2007 10:31:02 -0700, James C. wrote: Is there a way to compact an excel file (similar to compacting a database in MS Access). I currently have an excel file that continues to get bigger even though I have removed data from it. I have had this happen before and my solution was to copy all of the contents to a new excel workbook and the size was reduced dramatically. This time however, I have too many sheets to do this. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I save an excel file to a rewritable compact disc? | Excel Discussion (Misc queries) | |||
HOW TO COMPACT AN EXCEL FILE | Excel Discussion (Misc queries) | |||
How to read Pocket Excel file in Compact framework | Excel Discussion (Misc queries) | |||
How to read Pocket Excel file in Compact framework | Excel Discussion (Misc queries) | |||
how do I save an excel file to a rewritable compact disc? | Excel Discussion (Misc queries) |