I have a microsoft 365 subscription my mac is mac0s Sierra Excel: 16.11.1 There is no tab power query under data. See print screen attached. How can I solve this problem. ![]() I tried looking for an install of an add-in, but it doesn't exist. According to MS: Excel 2016 The Get & Transform (Power Query) experience is available in all Excel 2016 plans on the Data tab under the Get & Transform section. It is available with basic and advanced features depending on your version. Basic business analytics features • Available with any office 365 subscription or Office 2016. In some article I read removing all 11 CS6 pre-installed plug-ins was suggested. I've not encountered any other problems with CS6 and High Sierra, but then I'm not really a 'power user. Os x sierra 10.12. Adobe acrobat 7.0 for mac. Power query is a great tool built by Microsoft that will help you work with data in Excel. This tool is great for connecting to various external data sources, querying and transforming data, or cleaning and parsing data. Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.
0 Comments
Leave a Reply. |