Thank you for your continued feedback and responses. I am excited to let you know that the work for External Links for Excel on the web has started.
Microsoft Excel Team
An error occurred while saving the commentAnonymous commented
This post is a five-year-old one... Seems that it's complicated... importrange exists in gsheet for a least a decade... what a shame...