How to Fix #REF! Errors When Converting Google Sheets to Excel
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.

- 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 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.
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.
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"))).
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.
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.

Verify Sheet Names and Formula Syntax
Ensure that the referenced sheet names transferred correctly and do not contain special characters that disrupt Excel formulas.
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. Download the software: Visit the official WPS website and download the free WPS Office suite for your device.
- 2. Install and launch: Run the installer, open WPS Spreadsheet, and use it as your default application for spreadsheet editing.
- 3. Open your converted file: Click 'File' > 'Open' and select your exported Google Sheets file to view and edit formulas without compatibility issues.

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.




