Why does Excel take 15sec. to do every taks?

[Guest]

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]

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

 

[Guest]

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.

 

[Guest]

Upon further review that seemed to be the culprit.

Thanks David

 

[Dave Peterson]

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.

 

[David McRitchie]

Hi Dave P. and dcoats, (and thanks to both of you)

The second link was mine (slowresp.htm).

Thank you for replying which specific item helped. It is a page with
many different suggestions and it is nice to know and helpful that you
indicated which specific item helped. I know it takes a long time to go
through and may not have a solution for a problem with response time,
so it is real nice to know that it helped you.

Upon further review that seemed to be the culprit. ("Page Break *Preview*")

If English is not your native language the rule of thumb is
"i" before "e" except after "c" otherwise spell checker helps.

 

[Dave Peterson]

And thanks for having that on your site.

(I hardly ever use "page break preview" for anything other than adjusting
pagebreaks--and when I'm done, I go back to the normal view. I would have never
guessed this as the problem/solution.)