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"
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?
This is a long shot, but, could I forward you the workbook?
If it can be shared with the public, you could post it to OneDrive or GoogleDrive and paste a link here. If you're needing to keep it private, you can try clicking on my hyperlinked user name and attach it to a personal message. Or send me your email (also in a private message) and I'll reply with mine.