Final answer:
To turn off auto refresh in Excel, follow these steps: Select the 'File' tab, click on 'Options', go to the 'Advanced' section, uncheck the 'Calculate' box under 'When calculating this workbook', and click 'OK'.
Step-by-step explanation:
To turn off auto refresh in Excel, you can follow these steps:
- Select the 'File' tab
- Click on 'Options'
- In the Excel Options dialog box, select 'Advanced'
- Under the 'General' section, find 'When calculating this workbook' and uncheck the 'Calculate' box
- Click 'OK' to save the changes
By disabling the auto refresh, Excel will no longer automatically recalculate formulas and update the values in the workbook.