Forum Discussion
Solved
Google sheets to Excel
Hello all.
When saving a Google sheets doc to Excel all of the formulas that are referencing other tab values are giving me the #REF. The document converts fine in viewing / read only but as soon as I "enable editing" all of the values in boxes referencing other tabs change to #REF.
I reached out to Microsoft Office for help and they were unable to resolve my issue and referred me here.
Thank you in advance for any 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"
9 Replies
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"
