Depending on what you're doing, you may want to toggle
tools|options|view tab|page breaks
those are those dashed/dotted lines that show where the page breaks will be.

Excel has to determine where they go each time you insert/delete/move a row or
column. I'd bet xl wants to do the same in pagebreak view, too. (I don't use
this very often--and it's a happy coincidence.)

I've never noticed a slowdown when doing manual stuff with the dotted lines (I'm
a slower typer than excel is calculator), but I have noticed it in macros.

Thanks for posting back.

Now, google has it for the next victim, er, user.



dcoats wrote:

Upon further review that seemed to be the culprit.

Thanks David

"dcoats" wrote:

Thanks David!

The second link gave me at least a partical answer.

"Page Break Preveiw" was turned on. Turning this off seemed to speed up
things considerably.

Now tasks happen immediatley or only take a couple of seconds.

The question for me is why does it do that on just this one machine. Other
machines handle the file just fine with no delays.

I will keep looking.

"Dave Peterson" wrote:

Here are a couple of sites that discuss slow performance. The first is by
Charles Williams and the second by David McRitchie:

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

dcoats wrote:

With a new install of Excel every task is taking 15 sec. to complete. I
timed it - all the same amount of time from opening a file, unhiding columns,
moving rows....

Reinstall fixed it for one task. Everying else on the computer runs normally.

--

Dave Peterson


--

Dave Peterson