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...

--

--Andy Smith



"Don Guillett" wrote:

try some from here

http://tinyurl.com/2z3srq


--
Don Guillett
SalesAid Software

"Andy Smith" wrote in message
...
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