Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size keeps fluctuating wildly!
I'm developing a financial calculator which has lots of VBA code, a few
charts, and some basic UI stuff. It seems every time I open it and save it, the size varies anywhere between 4 and 7 meg even though I open it with the Shift key held down, and I have ThisWorkbook.KeepChangeHistory = False in the Workbook_Open even handler and other places. I've also tried stuff like deleting all unused rows and columns out to IV65536, setting global formats and making very few exceptions, etc., and it makes a difference, but only temporarily. I've even tried repeatedly opening it (with Shift down), making one tiny change, and saving it to minimize the size of the Undo buffer, but the size still fluctuates. Any ideas out there? -- --Andy Smith Senior Systems Analyst Standard & Poor's, New York, NY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Fluctuating Breakeven Point | Charts and Charting in Excel | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
File size keeps fluctuating wildly! | Excel Discussion (Misc queries) | |||
forecasting and linking to a data range that is fluctuating | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |