Selected value not updating
I have found that for the past week that Excel workbooks that contain value links to other workbooks stored on my One Drive for Business are not updating automatically or even when I click on the 'Data Edit Links and hit 'Update Values.' I have been able to reproduce this on other systems and other O365 accounts so it appears to be a change in service.
And how do I get my Excel to calculate and update formulas automatically again?Don't worry, most likely your Excel is all right, and you will get all the answers in a moment.: Excel formula not working correctly, it returns an error or a wrong result.This section provides a summary of the most common mistakes people make when creating formulas in Excel and solutions to fix them.
As you know, the arguments of Excel functions are entered within the parentheses.
In complex formulas, you may need to enter more than one set of parentheses, one within another, to indicate the order in which the calculations should take place.