Thanks for reaching out to us on PI Square!
I just tested using Defined Names quickly using Datalink 2017 and Excel 2013 on my own system and this appears to work just fine. I don't see any documentation that defines this behavior a being version dependent. I would test it out and confirm for yourself, but I suspect you should be good to go on this.
Thanks for the reply, what did you syntax look like. It didn't seem to matter how I typed it in the equation wouldn't work.
So I made a Defined Name in a new Blank Sheet:
I then referenced the Defined Name in my DataLink Formula:
After hitting OK, Excel then resolve the cell's sheet and location from the defined name and references it directly rather than continuing to use the defined name:
I hadn't realized before that it ends up just referencing the Sheets and Cell number, so it might make more sense to do that in the first place.