Support Internet Query Connection (.iqy files)
It would be helpful for Excel to Mac to support internet query connections.
When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.
Shaun Green commented
This is a very disappointing shortcoming for paying Microsoft clients who happen to use MacOS.
How hard can it be to simply create an .xlsx export?
Google Drive has had this simple feature for years already. It almost seems as if Microsoft are intentionally treating their Mac clients as second-rate citizens.
It's very difficult working on my Mac when you can't download the excel file in Sharepoint. MAC excel won't open .iqy file
Gregg Gillman commented
I am surprised that his functionality does not yet exist. This is a must have. Please consider it for the very next update.