Hello,

i have been using excel to fill in weekly time sheets, one sheet per week.
All the workbook contains is a few formulas to work out and total my decimal
hours each day, and a short macro to copy and clear a new sheet for a new
week (with a userform to get the week start date).

at random times, the file size automatically increases from about 500kB to
10MB and starts taking about 10 to 15 minutes to load up.  this doesn't occur
when i run the macro, it is just random.  The only thing i can do is start a
new workbook and copy formats then values then import macros, all
individually - if i do a normal copy paste it carries the problem over to the
new workbook.  the longest it's gone without doing this is about 2 1/2 weeks.

I haven't got a clue what's going on, other than excel is getting all
jumbled up when it sees the formulas - why it should do this i don't know.

Has anyone seen this before?  any help would be very much appreciated.

TIA

jonny