If another user has changed a value in a cell, Microsoft Excel does not look for the new value unless you tell it to.The workbook that contains the links is called the destination workbook, and the workbook that is linked to it is called the source workbook.This is my case: B10= number, data for these formula C10= formula: =IF(IFERROR(B10,0),1,0) D10= formula: =SUM(C8: C12) E10= formula: =SUM(D8: D12) And those cells copied to B1: B20 The result: ONLY the col C that changed by input or edit the cell in col B.Last week, we shared a sheet that wasn't calculating correctly.I have to physically go to each cell, hit F2 and Enter to get the data to update. I think excel simply forgets that automatic calculation was switched back on. Excel uses the calculation setting of the first workbook opened.
Anyway, I have several Excel spreadsheets with simple formulas that have all of a sudden stopped updating when new data is entered. I went back and tried it again and now it's working. Don't know why it happens, but that's how I fix it. Michael This has happened to me on several occasions, specially after using a particular worksheet when I switch calculation to Manual then back to automatic for subsequent worksheets.If the workbook that you have opened (called a destination file) contains links to other workbooks or files (called source files), and the source files have changed, the links in the workbook that you are opening may display information that is out of date. The destination workbook contains the external reference. The external reference (or link) is a reference to a cell range in the source workbook. The source workbook contains the cell and the actual value that is retrieved and placed in the destination workbook.When the source workbook and the destination workbook are open on the same computer, links are updated automatically.The option is located in the options panel, under 'Advanced' options.However, it is much faster to turn on/off this option using the keyboard shortcut You have a formula that you know you have entered correctly, but when you change the formula, or change the values of its dependent cells the formula continues to show the old value.This problem is usually caused by the setting of the Calculation option for your Excel spreadsheet.