Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 is very slow with every entry. why the delay?
small worksheet. each time i enter a number in a cell i get the active
circle showing. i move to another cell but quite a delay time before freed up for next entry. why? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 is very slow with every entry. why the delay?
You have automatic Calculation on. By turning this off you will be able to
update you spreadsheet much faster. To do this go to the Windows icon in the top left of the screen and click on Excel Options. Then choose the Formulas button and under Calculation Options choose the Manual radio button. Click OK. Then your spreadsheet will only calculate when you hit F9 or close/save the spreadsheet. "dcw13" wrote: small worksheet. each time i enter a number in a cell i get the active circle showing. i move to another cell but quite a delay time before freed up for next entry. why? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 is very slow with every entry. why the delay?
RD will this work as you say for existing spreadsheets? or are there other
options i also need to have off?? thx "RD" wrote: You have automatic Calculation on. By turning this off you will be able to update you spreadsheet much faster. To do this go to the Windows icon in the top left of the screen and click on Excel Options. Then choose the Formulas button and under Calculation Options choose the Manual radio button. Click OK. Then your spreadsheet will only calculate when you hit F9 or close/save the spreadsheet. "dcw13" wrote: small worksheet. each time i enter a number in a cell i get the active circle showing. i move to another cell but quite a delay time before freed up for next entry. why? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 is very slow with every entry. why the delay?
I wouldn't use manual calculations as it's a false reading waiting to
happen. Besides, if you need manual calculations you have a design flaw. http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm -- Regards Dave Hawley www.ozgrid.com "RD" wrote in message ... You have automatic Calculation on. By turning this off you will be able to update you spreadsheet much faster. To do this go to the Windows icon in the top left of the screen and click on Excel Options. Then choose the Formulas button and under Calculation Options choose the Manual radio button. Click OK. Then your spreadsheet will only calculate when you hit F9 or close/save the spreadsheet. "dcw13" wrote: small worksheet. each time i enter a number in a cell i get the active circle showing. i move to another cell but quite a delay time before freed up for next entry. why? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 is very slow with every entry. why the delay?
Why is the entry process so slow. I have compacted the hard disk, run diagnostics, and even uninstalled the program and reinstalled. It did no good.
On Friday, May 07, 2010 12:36 AM dcw13 wrote: small worksheet. each time i enter a number in a cell i get the active circle showing. i move to another cell but quite a delay time before freed up for next entry. why? On Friday, May 07, 2010 2:58 AM RD wrote: You have automatic Calculation on. By turning this off you will be able to update you spreadsheet much faster. To do this go to the Windows icon in the top left of the screen and click on Excel Options. Then choose the Formulas button and under Calculation Options choose the Manual radio button. Click OK. Then your spreadsheet will only calculate when you hit F9 or close/save the spreadsheet. "dcw13" wrote: On Friday, May 07, 2010 11:01 AM dcw13 wrote: RD will this work as you say for existing spreadsheets? or are there other options i also need to have off?? thx "RD" wrote: On Friday, May 07, 2010 10:18 PM ozgrid.com wrote: I would not use manual calculations as it is a false reading waiting to happen. Besides, if you need manual calculations you have a design flaw. http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm -- Regards Dave Hawley www.ozgrid.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
outlook 2007 delay delivery problem | New Users to Excel | |||
slow to open Excel 2007 and Word 2007 (MIS stumped) | Excel Discussion (Misc queries) | |||
delay in entry etc.... | Excel Discussion (Misc queries) | |||
data entry in Excel slow | Excel Discussion (Misc queries) | |||
Delay/Slow a Macro In Excel 2003 | Excel Worksheet Functions |