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

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.

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

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

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

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

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" wrote...
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.

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 McRitchie wrote:

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" wrote...
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