I hope someone can explain this to me.....
Why is it that Excel operations such as merge cell, or fill, etc.... takes
so long on one file, and then speeds like a demon on another file?
There's no rhyme/reason that I've been able to identify thus far.
I.e., one file that has lots of worksheets will work through the operations
really fast, and then another with only a couple of worksheets will move
along like a snail, as though it has 50 things it has to do before it gets to
what I've selected.
Then, the next one will be a lot of worksheets, and it moves really slow, to
the point where I can leave for 5 minutes, go walk around the floor I work
on, and get back and it's STILL working.
It doesn't matter if I've saved it between working or not. It doesn't matter
if I'm doing a macro that I've created or not.
My system is a P4, 3Ghz, with 1gb ram, and I'm running XP-Pro, SP3 so that's
not the issue. At least I hope not.
Oh, and yes, I'm using Office 2007, SP2.
This has gotten past ridiculous, so if someone can provide me with a
reasonable explanation it'd be really nice.

Thank you.