Software⏱️ 3 min read📅 2026-06-11

How to Fix: What causes Excel to raise an error about "one or more formula references" when saving?

Excel error message fix for one or more formula references in Office 365 ProPlus.

Quick Answer: Check cell references, range names, defined names, and links to other workbooks for errors.

📋 Table of Contents

  1. 🛑 Root Causes of the Error
  2. ✅ Best Solutions to Fix It
  3. 💡 Conclusion

Excel error 'one or more formula references' occurs when you save an Excel sheet and receive an error message indicating that there is a problem with one or more formula references. This issue affects users of Office 365 ProPlus on Windows 7, making it frustrating to work with their spreadsheets.

The error can be caused by incorrect cell references, range names, defined names, or links to other workbooks in formulas. Fortunately, we will guide you through the fastest way to find and fix this problem.

🛑 Root Causes of the Error

  • The primary cause of this error is an incorrect formula reference. This can happen when a user accidentally types an incorrect range name or cell address, or when a formula references a non-existent worksheet or workbook.
  • Another possible cause is that a formula is referencing a named range or cell that has been deleted or changed.

✅ Best Solutions to Fix It

Verify and Correct Formula References

  1. Step 1: Step 1: Go to the 'Formulas' tab in the ribbon and click on 'Error Checking' (under 'Formula editing'). This will scan your entire sheet for any formula errors.
  2. Step 2: Step 2: Review the list of error messages that appear. Look for any references to named ranges, cell addresses, or worksheets that may be incorrect.
  3. Step 3: Step 3: Correct each error individually by updating the formula reference to match the correct range name, cell address, or worksheet.
  4. Step 4: Step 4: Save your workbook again to ensure that the changes are applied.

Use the 'Find and Replace' feature

  1. Step 1: Step 1: Press 'Ctrl + H' on your keyboard to open the 'Find and Replace' dialog box.
  2. Step 2: Step 2: In the 'Find what' field, enter a pattern that matches the incorrect formula reference (e.g. '=A1' or '=Sheet1!A1').
  3. Step 3: Step 3: Click on 'Replace all' to replace all occurrences of the incorrect formula reference with the correct one.
  4. Step 4: Step 4: Press 'Enter' to apply the changes and save your workbook again.

💡 Conclusion

By following these steps, you should be able to identify and fix the issue causing the Excel error 'one or more formula references'. Remember to always double-check your formula references to avoid this problem in the future. If you're still experiencing issues, consider consulting the Excel user manual or seeking assistance from a Microsoft support specialist.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Pc crashes shortly after launching game (rainbow

Fix Pc crashes shortly after launching game (rainbow six siege). Compl

How to Fix: Installing an APK on a locked down phone

Installing an APK on a locked down phone: Try using a rooted device, e

How to Fix: New PC build- no signal and no clue

Fix New PC build- no signal and no clue. Complete troubleshooting guid