Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Controlling Workbook File Size?
I have a workbook that has recently increased from 5meg to 30 meg. There are
no pivot tables -- only a couple small macros that involve a few lines of vba. What could have caused the jumped.. and what can I do to fix it? |
#2
|
|||
|
|||
Just guesses...
The last used cell on each worksheet is way past where you think it should be. See Debra Dalgleish's site to reset this last used cell. http://www.contextures.com/xlfaqApp.html#Unused Any chance you have objects (pictures/buttons/textboxes) in your workbook? Sometimes pictures get duplicated by error. Mark wrote: I have a workbook that has recently increased from 5meg to 30 meg. There are no pivot tables -- only a couple small macros that involve a few lines of vba. What could have caused the jumped.. and what can I do to fix it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
Excel file size increased | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Workbook and sheets have disappeared but file can open | Excel Discussion (Misc queries) |