Laura has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Auto calculation
Can i permanently turn off auto calculation?
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
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
