Entering data slow program down

  • Thread starter Thread starter JMM
  • Start date Start date
J

JMM

Am working on a spreadsheet that is not complicated. Entering data was
occuring normally, then it started to slow way down. I am putting in new
numbers over the pre-existing ones, and now I get the spinning circle symbol
for about four minutes after each entry before I can make another entry. If I
click in another cell, the screen gets a white overlay. What am I doing wrong?
Thanks
John
 
It is hard to know where to start without an understanding of the content of
your workbook.

To work around your problem (short term), click Tools, Options, Calculation
and change to manual. After you update data press [F9] to update workbook
calculations. It will still be slow to calculate but you will be able to
update or add data without going totally insane:-) After you figure it all
out, change calculations back to automatic.

If it is your workbook and not some other problem, the following may help.

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

If you are running VBA code:
http://blogs.msdn.com/excel/archive/2009/03/12/excel-vba-performance-coding-best-practices.aspx

Excel 2007?
http://msdn.microsoft.com/en-us/library/aa730921.aspx

You MAY find something here:
http://social.msdn.microsoft.com/Search/en-US/?query=excel performance&ac=3
 
Thank you Steve,
I have tried entering data when on "manual" and nothing improves. Will go
through those sites you recommended.
Thanks again,
John

AltaEgo said:
It is hard to know where to start without an understanding of the content of
your workbook.

To work around your problem (short term), click Tools, Options, Calculation
and change to manual. After you update data press [F9] to update workbook
calculations. It will still be slow to calculate but you will be able to
update or add data without going totally insane:-) After you figure it all
out, change calculations back to automatic.

If it is your workbook and not some other problem, the following may help.

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

If you are running VBA code:
http://blogs.msdn.com/excel/archive/2009/03/12/excel-vba-performance-coding-best-practices.aspx

Excel 2007?
http://msdn.microsoft.com/en-us/library/aa730921.aspx

You MAY find something here:
http://social.msdn.microsoft.com/Search/en-US/?query=excel performance&ac=3

--
Steve

JMM said:
Am working on a spreadsheet that is not complicated. Entering data was
occuring normally, then it started to slow way down. I am putting in new
numbers over the pre-existing ones, and now I get the spinning circle
symbol
for about four minutes after each entry before I can make another entry.
If I
click in another cell, the screen gets a white overlay. What am I doing
wrong?
Thanks
John
Click to expand...
Click to expand...
 
Back
Top