98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auto calculation
Auto calculation
Resolved · Low Priority · Version 2010
Sat 5 Nov 2011, 17:56Delegate Laura said...
Laura has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Auto calculation
Can i permanently turn off auto calculation?
Mon 7 Nov 2011, 12:41Delegate Barry said...
RE: Auto calculation
Hi Laura
If 2010 is similar to 2007 then this is simple.
Click on the orb on the top left of excel application window that you use to save and open files then go to Excel options on the bottom of the window that opens.
Within the new window select formulas and change workbook calculation to manual. Its then your choice if you want the workbook to recalculate before saving which if you dont just untick the box.
Be aware this will stop all workbooks from calculating only on the machine you are using. Should there be others you would need to repeat this process.
Hope that helps
Barry
Mon 7 Nov 2011, 12:41Delegate Barry said...
RE: Auto calculation
Hi Laura
If 2010 is similar to 2007 then this is simple.
Click on the orb on the top left of excel application window that you use to save and open files then go to Excel options on the bottom of the window that opens.
Within the new window select formulas and change workbook calculation to manual. Its then your choice if you want the workbook to recalculate before saving which if you dont just untick the box.
Be aware this will stop all workbooks from calculating only on the machine you are using. Should there be others you would need to repeat this process.
Hope that helps
Barry
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:Generating Random NumbersTo generate a random number in Excel use the = RAND() function. |
