Formula Errors

How to Fix #REF! Errors When Converting Google Sheets to Excel

John WilsonJohn Wilson Nov 11, 2026 871 views

Question details

The user needs to resolve #REF! errors that occur in cross-sheet formulas after converting a Google Sheets file into Microsoft Excel format.

How to Fix #REF! Errors When Converting Google Sheets to Excel
Product
Microsoft Excel, Google Sheets
Device & OS
not provided
Scenario
Opening an exported Excel workbook (.xlsx) originally created in Google Sheets that contains formulas referencing data on other sheets.
Observed behavior
Formulas that worked perfectly in Google Sheets display a #REF! error in Excel due to syntax changes or the unintended addition of operators during the export process.
Before you start

Before modifying your formulas, identify which specific cells are displaying the #REF! error and note the sheet names being referenced to ensure they do not contain unsupported special characters.

Solution 1Recommended

Remove Implicit-Intersection Operators (@) from Formulas

The most common cause of this error during conversion is the automatic insertion of the '@' symbol in functions like INDIRECT. Removing it restores the correct cross-sheet reference.

When exporting from Google Sheets to Excel, Excel's dynamic array calculation engine may insert an implicit-intersection operator (@) into formulas like INDIRECT. This operator forces the formula to return a single value, preventing it from correctly referencing entire ranges across different sheets and resulting in a #REF! error.

1
Inspect the formula

Click on one of the cells displaying the #REF! error and look at the formula bar at the top of the screen to check if an '@' symbol has been added before a function (e.g., =(@INDIRECT($A7&"!D1"))).

2
Manually remove the operator

Click inside the formula bar, delete the '@' symbol so the formula reads correctly (e.g., =INDIRECT($A7&"!D1")), and press Enter to see if the error is resolved.

3
Use Find and Replace

If the manual fix works, press Ctrl + H to open the Find and Replace dialog. Enter @INDIRECT in the 'Find what' field and INDIRECT in the 'Replace with' field, then click 'Replace All' to apply the fix throughout the entire workbook.

Remove Implicit-Intersection Operators (@) from Formulas
Batch Processing: Using the Find and Replace method saves time if you have hundreds of affected formulas across multiple sheets.
Free Microsoft Office alternative

Open and Edit Converted Spreadsheets Seamlessly with WPS Office

Avoid formula compatibility issues when working with different spreadsheet formats. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring your data and formulas remain intact.

  1. 1. Download the software: Visit the official WPS website and download the free WPS Office suite for your device.
  2. 2. Install and launch: Run the installer, open WPS Spreadsheet, and use it as your default application for spreadsheet editing.
  3. 3. Open your converted file: Click 'File' > 'Open' and select your exported Google Sheets file to view and edit formulas without compatibility issues.
Fully compatible with Microsoft Excel (.xlsx) formatsAccurate rendering of complex formulas and cross-sheet referencesLightweight application with a familiar, easy-to-use interfaceSeamless migration of Google Sheets exports without syntax breakages
microsoft office alternative - wps office

Frequently Asked Questions

Why does the #REF! error only appear after converting from Google Sheets to Excel?

This occurs because Google Sheets and Microsoft Excel handle array formulas differently. Excel sometimes inserts an implicit intersection operator (@) to force an imported formula to return a single value, which inadvertently breaks references designed to pull data across sheets.

Can I prevent the @ symbol from being added during conversion?

You cannot completely prevent Excel from adding the @ symbol when opening the exported file, as it is a built-in behavior of Excel's dynamic array engine handling legacy arrays. The most efficient approach is to use the Find and Replace tool to remove the @ symbol immediately after opening the file.

What if removing the @ symbol does not fix the #REF! error?

If the error persists, check if the referenced sheet was deleted or failed to export properly. Additionally, look for invalid characters in the sheet names, or ensure that the referenced cell ranges actually exist in the newly converted workbook.