Fix an Excel IF Formula Link Between Workbooks That Does Not Update
Question details
Determine why an Excel IF formula linked to a cell in another workbook does not change when the source cell appears to be zero.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula in one workbook checks cell I44 on the Invoices sheet in another workbook and should return a result when that cell equals zero.
- Observed behavior
- The linked IF formula does not change as expected, and the user wants to know whether Excel checks the source formula's result or its text.
Open both the destination workbook and the source workbook, and confirm that the source file contains the Invoices sheet and cell I44. Check that the source workbook name and location match the external reference.
Check the Source Value and IF Formula
Use this method to confirm what I44 returns and whether the destination formula compares it with numeric zero.
Excel evaluates the result of the formula in I44, not the formula text. A displayed zero may be text or a rounded display of a nonzero value.
In the source workbook, open the Invoices sheet, select I44, and review its formula in the formula bar.
In an empty cell on the Invoices sheet, enter =I44=0. A TRUE result means the source cell compares equal to numeric zero; FALSE means it does not.
In another empty cell, enter =ISNUMBER(I44). If it returns FALSE and I44 displays 0, review the source formula for a text result such as "0" and change it to return numeric 0 if appropriate.
Select I44 and use Home > Increase Decimal to see whether the displayed zero conceals a nonzero value. If the comparison should use a rounded value, apply the appropriate rounding in the source or destination formula.
In the destination workbook, select the formula cell and check its reference in the formula bar. For example, use =IF('[ALAM-0001.xlsx]Invoices'!$I$44=0,"X","") to return X when the linked value equals numeric zero.

Refresh the External Link and Recalculate the Workbooks
Use this method if the source value is correct but the destination workbook still shows an old result.
Work With Linked Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and compatibility with Excel files, making it easy to move existing workbooks into a different office suite.

Frequently Asked Questions
Does an Excel workbook link read the formula or its result?
A normal cell reference uses the source cell's calculated result, not its formula text. Check the formula bar in the source cell to see how that result is produced.
Why does a cell that displays zero fail an IF comparison?
It may contain text such as "0" or a small nonzero number displayed as zero. Test =ISNUMBER(I44) and =I44=0, and use Home > Increase Decimal to inspect the displayed precision.
How do I update an Excel link to another workbook?
In the destination workbook, open Data > Workbook Links or Data > Edit Links, select the source, and choose Refresh or Update Values. If the source has moved, use Change Source to locate it.
How do I make Excel recalculate formulas automatically?
Open Formulas > Calculation Options and select Automatic. Then recalculate and check the linked formula again.




