I have some very strange behaviour in my PERSONAL.XLS book (Excel 2003,
Office XP). It is normally about 1mb in size. These days whenever I do some
work on it (including DELETING lines) it will suddenly jump to over 2mb in
size for no apparent reason.

If I then copy all the modules to another workbook, delete all the PERSONAL
modules and then copy them back it goes back to it's former (or newly
reduced) size. Then after a little more work it will jump to over 2mb again,
and I have to repeat the process.

I'm trying to keep the size as slim as possible because the autosaves take
too long otherwise.

I thought that there may be some problem with the book itself so I tried to
save another file as the PERSONAL.xls. This works (don't know about any size
jumping) but the new book is always displayed as an open workbook, whereas
PERSONAL.XLS does not). Is there a way to stop this displaying or does the
original PERSONAL having some special properties?

Does anyone have any idea why the book will suddenly double in size please?
Regards, Brett