Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet pausing,calculating cells,up2 100%,each input,why?
Hello there,
Everytime I input data into even the smallest of spreadsheets, the application pauses, in the bottom left it states that it is calculating cells, then there is a 3 second pause as a percentage rolls up to 100. This is slowing my work down alot, please help me to understand what is going on and how to stop it. Regards Matthew C. |
#2
|
|||
|
|||
You can turn calculation to manual, do your data entry and then turn it back on
(or just recalculate when you want). You'll see that excel gives you a warning in the statusbar when the workbook need recalculation. Tools|Options|Calculation tab is where you'd toggle this setting. Matticace wrote: Hello there, Everytime I input data into even the smallest of spreadsheets, the application pauses, in the bottom left it states that it is calculating cells, then there is a 3 second pause as a percentage rolls up to 100. This is slowing my work down alot, please help me to understand what is going on and how to stop it. Regards Matthew C. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |