File size keeps fluctuating wildly!

[Guest]

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?

 

[Don Guillett]

try some from here

http://tinyurl.com/2z3srq

 

[Guest]

I've tried everything there and more. I've even tried stuff no one else
mentions, e.g., default formats, etc. But still, I open the file with Shift
down, so it's in Design mode, I change one cell -- ONE cell! -- I save it,
and it's 300MB bigger, from 4,099K to 4,314K. Come on now...

 

[Guest]

There's one cell which contains the build information for the software. It's
in a hidden sheet, and all its cells have all default formats, no exceptions.
That cell has one of four words, Debug, Alpha, Beta or Release, and that's
validated with a conditional format specifying a 1x4 range with those words.

So to make the different builds, I open the workbook with Shift down to
start in Design mode, run a macro that unprotects all sheets and the
workbook, manually change the cell, run another macro to protect all sheets
and the workbook, turn on Design mode again, and save. But even if I do
everything manually in Design mode all the way (unprotecting just the one
sheet), the size goes nuts.

I've even tried exporting, deleting and re-importing all modules, forms and
class modules -- nothing.