We are in the process of updating the site, so some pages still have the older design.
Excel Formulas Won't Update
How to get your Excel formulas to update when you edit a worksheet.
By default, each time you edit the contents of a cell, everything on the worksheet should update to make sure it has the latest data, but this can be turned-off. This issue arises when someone has set formula calculation to manual and forgotten to set it back to automatic.
Turn On Formula Calculation
Go to the Formulas tab and on the right side click Calculation Options and then Automatic.
If you just want to calculate the data once but not set it to Automatic, click the Calculate Now button (located to the right of Calculation Options) or hit F9 on the keyboard.
Notes
In the spreadsheet attached to this tutorial, there are 4 cells with RAND() functions. Each time the spreadsheet is updated, these should change; you can use this to test turning calculation on and off to see how it affects the worksheet when you enter data.
Download the sample workbook for this tutorial to test this feature with the RAND() function in Excel.
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.
View our Privacy Policy | Terms of Use
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: How to export an Excel file to a CSV file (comma separated values file). This allows yo...
Tutorial: Learn how to build an interactive Excel dashboard using checkboxes, the GROUPBY function,...
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Tutorial: How to create a named range that expands automatically when a new value is added to the r...
Tutorial: This guide will show you 4 different ways to make your macros run faster and more efficien...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)