Excel slow down

[Jonny]

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

 

[Bill Ridgeway]

I have a large file which contains a mass of formulae which I've noticed has
a tendency to slow down. I noticed that on a recalculation it darts about
from one cell to another which suggests that this may be controlled by an
internal table. Every so many months I copy all the formula down from the
first row and this increase recalculation speed. Hope this helps/

Regards.

Bill Ridgeway
Computer Solutions

 

[Jonny]

Not really, the workbook is incredibly slow to open up, but fine on
recalculation, saving and closing.

thanks anyway

 

[CLR]

Not a cure, but to help isolate.......next time you have the problem, if you
have more than one sheet in the file, copy them over to a new workbook one at
a time and you will probably find that only one sheet is where the problem is
coming from.....then perhaps you can analyze it to more detail.......if you
only have one sheet, then try copying only portions of it over to a new
workbook and only a few macros at a time, in hopes of narrowing it
down..........

HTH
Vaya con Dios,
Chuck, CABGx3