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

D

dcoats

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.
 
D

dcoats

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.
 
D

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.
 
D

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

dcoats said:
Upon further review that seemed to be the culprit. ("Page Break *Preview*")
Click to expand...

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

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.)

David said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

dcoats said:
Upon further review that seemed to be the culprit. ("Page Break *Preview*")
Click to expand...

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