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"
@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.
- and I just replied
- I sent a private message. Thank you!