Forum Discussion
Google sheets to Excel
This is an example of the formula that gives the #REF =(@INDIRECT($A7&"!D1"))
It still is hard to be certain, without seeing and working with the actual. But ... but, my eye immediately went to the "@" in that formula. In Excel, I've not ever seen that as part of the syntax for using INDIRECT. I don't know what the other parts of that formula work out to, but see if simply removing the "@" enables it to work. If it does, you could do a global Find and Replace to convert every instance of "@INDIRECT" to "INDIRECT"
How about beginning with a more complete description of the situation?
- Are you converting a Google workbook, consisting of multiple tabs/sheets, with those references going from one tab/sheet to another within the same workbook?
- What are the names of some of the tabs/sheets?
- What's the formula that contains those references?
- Are there some unusual characters in those tab/sheet names?
- Do the formulas that do NOT make reference to other tabs/sheets work as expected, or are all formulas giving a #REF error?
And so on.
It's hard to diagnose with only an error message. As if you've gone to a doctor for help but only giving the info, "I have a pain."
- Hi mathetes,
I apologize as I am new here and not well versed in Google sheets or Microsoft Excel.
*Yes I am converting a Google workbook with multiple tabs. And, those references are going from one tab to another. They work fine in Google but get lost in conversion.
*Some of the names of tabs are Budget Summary, Budget Detail, 010 Professional Fees, 020 General Provisions, 030 Septic System and Well, and so on...
*This is an example of the formula that gives the #REF =(@INDIRECT($A7&"!D1"))
* I dont believe there are any unusual characters in the formulas as they work in Google, just not in Excel.
*All other formulas not referencing other tabs/sheets work.
Thank you for your help.
EvanThis is an example of the formula that gives the #REF =(@INDIRECT($A7&"!D1"))
It still is hard to be certain, without seeing and working with the actual. But ... but, my eye immediately went to the "@" in that formula. In Excel, I've not ever seen that as part of the syntax for using INDIRECT. I don't know what the other parts of that formula work out to, but see if simply removing the "@" enables it to work. If it does, you could do a global Find and Replace to convert every instance of "@INDIRECT" to "INDIRECT"
The @ was something that was added to the INDIRECT when converting to Excel. Its not in the Google sheets. I removed it in the Excel sheet to see if it would work, unfortunately it did not.
