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"
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.
Evan
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"
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.
Here's a link to a good resource for all things Excel. And here's the specific reference to INDIRECT.
I'd suggest reconstructing that formula (and all its #REF counterparts) to see what starts letting it work.
I did notice that you have an unnecessary set of parentheses around the whole of it.
=INDIRECT($A7&"!D1")
should be sufficient. However, that shouldn't be the cause of the problem.
As I noted earlier, I don't know what's in cells A7 and D1. Because you're using INDIRECT to construct a reference, it may be--probably is--that what is being reconstructed from those references is what's leading to the #REF error.
@mathetes
Thank you for your help. I have tried all suggestions and nothing has worked for me. I didn't create the google sheet I am trying to convert and I have limited Excel knowledge.
This is a long shot, but, could I forward you the workbook?