Link to linked spreadsheet not updating
I ran into an issue where some cells weren't calculating.I checked all the normal things, like cell type, auto calculation, etc...In the resulting Paste Special dialog box shown in Figure 2, choose Paste Link and Unformatted Text.Lastly, select and update the "Total" formula in the Word document to complete the process, as shown in Figure 3.
I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. F9 and Shift F9 didn't help and left the values the same.
The fact that there is a different accepted answer means that this problem is different from yours and that solution worked.
Typically, the kind of error you describe (turning a value into the wrong type of argument for a formula), will produce an error message.
In Settings I had to change Automatic Update command to Full Calculate and then back again.
Once the original setting had been restored, the add-in ran as normal.
I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.