To refresh queries generated from Text, CSV, XLSX, XML or JSON files, triggering the Refresh command is done the same way as previously, e.g. If you are running an earlier version, you will need to update. This new functionality is live for all Office 365 subscribers in Excel for Mac running version 16.29 (19090802) and later. This “Phase 1” release allows you to refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files (yes, we’ve just said most of that has been around from June), but you can author queries with VBA. Well, today, Microsoft has announced the first step towards full support for Power Query in Excel for Mac. But it’s been missing from Mac Excel.īack in June, there was a little teaser of what was to come with the ability to undertake limited Power Query query refreshes for CSV, JSON, Text, XLSX and XML files only.
We have a Power Query blog each Wednesday that keeps you apprised of all the things you can do with the Extract, Transform and Load (ETL) tool. For several years now, the Windows platform has introduced a powerful set of Get & Transform Data / Power Query tools, starting way back with Excel 2010. Question: How do I refresh a pivot table in Microsoft Excel 2011 for Mac Answer: To refresh a pivot table, right-click on the pivot table and then select 'Refresh Data' from the popup menu.
