Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Bloating
Hello,
I have/had a workbook which was 14MB. I did a very little amount of progamming (20 lines or less) and added a simple toolbar with 1 button and now it is 25MB? I then manually copy everything to a new workbook and saved it and it is only 255KB. What make a workbook bloat? Is there a way to tell Excel to wipe everything out of memory and saved the file again from scratch (I don't know if this make sense)? Thank you, QB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Bloating
Your issue is most likely that you have cells that Excel believes it needs to
save but in fact they are empty. The way to check this is to look at the scroll bars on each sheet. If the scroll bar allows you to scroll past the end of the data then you have empty cells that you need to Delete (not clear). On these sheets select all of the rows from the end of the data to the bottom of the sheet and Delete the cells (not clear contents). Do the same thing to remove empty columns. When you are done save the workbook and the size of the file should shrink... For more infor check out this link... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Question Boy" wrote: Hello, I have/had a workbook which was 14MB. I did a very little amount of progamming (20 lines or less) and added a simple toolbar with 1 button and now it is 25MB? I then manually copy everything to a new workbook and saved it and it is only 255KB. What make a workbook bloat? Is there a way to tell Excel to wipe everything out of memory and saved the file again from scratch (I don't know if this make sense)? Thank you, QB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bloating files in Excel 2007 | Excel Discussion (Misc queries) | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
File sizes unexplained bloating | Excel Discussion (Misc queries) |