98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel (Calculations)
Excel (Calculations)
Resolved · Low Priority · Version Standard
Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access VBA course
Excel (Calculations)
When utilising a large number of formula (30 columns, 62000 rows)is there a way to stop the sheet from calculating until all amendments have been made. At the moment the machine/excel are crashing due to the demands of the formula calculations.
RE: Excel (Calculations)
Hi Michael, Thanks for the post, in answer to your question; 62000 rows? 56,536 max, however to stop your computer from calculating every time an entry is made go to Menu command Tool, Options and in the Calculation Tab, Choose the option to Manually calculate, when you have entered all your amendments press the F9 (Function 9) key to calculate.
Hope that helps, best regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move data worksheet to worksheetTo move data from one worksheet to another, highlight the data. |