Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel calculations

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel (Calculations)

Excel (Calculations)

ResolvedVersion 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

RE: Excel (Calculations)

Thank you - it has resolved my query. (65,536 rows available in excel)

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.