Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering data slow program down
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering data slow program down
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/...practices.aspx Excel 2007? http://msdn.microsoft.com/en-us/library/aa730921.aspx You MAY find something he http://social.msdn.microsoft.com/Sea...rformance&ac=3 -- Steve "JMM" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering data slow program down
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" wrote: 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/...practices.aspx Excel 2007? http://msdn.microsoft.com/en-us/library/aa730921.aspx You MAY find something he http://social.msdn.microsoft.com/Sea...rformance&ac=3 -- Steve "JMM" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Entering multiple barcode using Talbar program, having issue plea | Excel Worksheet Functions | |||
Excel slow to close file/program | Excel Discussion (Misc queries) | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) |