Webservice and FilterXML functions are needed!
The Webservice and FilterXML functions are supported in Excel 2013 for Win, they are useful function and I need the same functions in my work. Please add Webservice and FilterXML functions in Excel 2016 for MAC.
Tom Cotton commented
Require the functions in both Mac and Web version to support online data queries that ultimately feed PowerBI.
this was demanded in 2015 and still not implemented? it is ridiculous!!!! When will Microsoft treat customers better?
This is indeed an unfortunate discovery that it is not supported on Excel for Mac. Some people can't just switch to a PC OS when a feature is not available.
First of, the new Excel for Mac is just what I have been waiting for. Excel is the Spreadsheet to use and so glad to see Excel Mac 2016 finally coming close to the windows version, except for one thing, external dataconnections, even dataqueries seem to be missing.
I am, probably one of many, who needs external data (stock quotes) in my daily work, and it seems impossible to do, at least in an elegant way, but the webservice function could help a lot.
Please, please bring it to a version for Excel mac very soon.
Honestly, I so want to be a fan of Microsoft on Mac, but it's so hard when they release their flagship products with such sub-par Mac versions. In 2017 to still not have a way to connect to online data is just nuts...