Why Excel SUMIF Formulas Change When Opening a Word Document
Question details
Determine why an Excel SUMIF formula appears different after a related Word document is opened.

- Product
- Microsoft Excel and Microsoft Word
- Device & OS
- not provided
- Scenario
- A user opens a Word document that may contain or reference an Excel workbook and then checks a SUMIF formula.
- Observed behavior
- The SUMIF formula appears to change after the Word document is opened.
Identify the original workbook and the Word document involved. If possible, locate the original SUMIF formula so you can compare its ranges, criteria, and references with the version you see afterward.
Check whether the Word document contains an embedded or linked workbook
Use this check to determine whether Word is displaying a separate embedded copy or a link to an Excel file.
Opening a Word document does not normally change a formula in a separate Excel workbook. An embedded workbook, linked object, or converted document may explain why you are seeing a different version.
Open the Word document and right-click the spreadsheet object. Look for an object or worksheet command that offers to open or edit it; the available options depend on how it was inserted.
In Excel, select File > Open and open the original workbook rather than the object in Word. Select the SUMIF cell and inspect its formula in the formula bar.
Compare the formula in the original workbook with the one in the Word object. Check the SUMIF range, criteria, sum range, and any workbook or sheet references.
In Word, select File > Info and look for Edit Links to Files if it is available. Check whether the object points to the expected workbook; this option may not appear when there are no applicable links.

Check Excel links and file compatibility
Use this solution if the formula references another workbook or the file has been converted to a different format.
Review Spreadsheet Formulas with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Its Microsoft Office format support makes it easier to move existing files into WPS, though it does not repair an Excel or Word linking issue by itself.

Frequently Asked Questions
Can opening a Word document change an Excel formula?
Opening Word does not normally change a formula in a separate workbook. Check whether the document contains an embedded copy or a linked Excel object, and compare it with the original workbook opened through Excel's File > Open menu.
How can I tell whether a Word spreadsheet is linked?
Right-click the spreadsheet object in Word and inspect its object options. You can also look under File > Info for Edit Links to Files; the option may not be available if the document has no applicable links.
Where can I check external links in Excel?
Open the workbook and select Data > Workbook Links or Data > Edit Links, depending on your Excel version. Review the listed source files for missing or unexpected links.
What should I compare in two SUMIF formulas?
Select the formula cell in each workbook and compare the formulas in the formula bar. Check the criteria range, criteria, sum range, and any references to other sheets or workbooks.




