Home |
Search |
Today's Posts |
#1
|
|||
|
|||
We have an excel file that is 52 megs in size and do not know why.
My company has been using an excel file from year to year for bank records.
Only 2004 and 2005 is included however, the size is enormous - 57 megs. What could cause the size to be so large? Is ther any type of purge function? |
#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. Kerry wrote: My company has been using an excel file from year to year for bank records. Only 2004 and 2005 is included however, the size is enormous - 57 megs. What could cause the size to be so large? Is ther any type of purge function? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size Inexplicably Inflated - 30 megs | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) | |||
how do i convert an excel file from a mac to a file on excel for . | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |