Excel values not updating
Excel sends a notification to other programs when data in a cell range has changed.
Due to a design limitation, described in Microsoft's knowledge base article KB2768406, Excel does not send a notification when data is copied and pasted within a workbook.
If your company has a Microsoft Office Support contract and you want to contact Microsoft to ask for a fix, you may refer to Microsoft case number 112071832712407. Result: The linked embedded worksheet in Word updates in most cases when changing the cell content.
Only when you change a cell by copy pasting another cell, the embedded worksheet in Word does not update.
Step 2: Click the Formulas tab at the top of the window.
Step 3: Click the Calculation Options button in the Calculation section of the ribbon, then click the Automatic option. If your formulas were already set to update automatically, then there may be a different problem.
Note that this setting applies to every formula in your workbook.
This means any cell which contains any type of formula.
If you know from the get-go what format your data should be in, it’s relatively simple to choose a number format for the entire column before entering your data.If you have formulas, pressing F9 should recalculate the sheet and update the number format.