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