Is it possible to open an existing Windows Power Pivot Excel on Mac? Excel for Mac more in line with Apple Numbers which currently offers something similar. Power Query is a free add-in built by Microsoft for Excel users like you and I. On Mac using Parallels, Boot Camp or VMWare Fusion and then install Excel.

Get over 500 hours of software training courses for $1 here ► During this Microsoft Excel 2016 training tutorial video, discovery how to use Power Query / Get and Transform in Microsoft Excel 2016 Checkout our other training on YouTube: Word 2016 training tutorials: PowerPoint 2016 training tutorials: VBA for Excel tutorials: Excel 2016 training for beginners: Project 2016 training: Stay in touch: SimonSezIT.com: StreamSkill.com: YouTube Channel: Facebook: Twitter: Google+: If you enjoyed the video, please give a 'thumbs up' and subscribe to the channel;-).

Goodmorning All I have a small dilemma and was looking for ideas on a work around. There is an Excel report that I have built on our shared drive. This report is based on a table created from a power query link into our company database. I have inserted a macro so that when the workbook is opened the connection to the database is refreshed so that the latest data is pulled in. The dilemma is that I use a windows based machine and this report is for my boss who is on a mac. Apparently Mac's do not support power query so this kicks of an error as 'the connection is not supported' Any ideas on how I can work round this and still achieve an automated solution?

Thank you Herbz. Not to worry RoryA, I have figured it out, many thanks. VBA code that I was using to update the links on opening when I was using PQ was: Private Sub Workbook_Open() ' Macro to update my Power Query script(s) Dim lTest As Long, cn As WorkbookConnection On Error Resume Next For Each cn In ThisWorkbook.Connections lTest = InStr(1, cn.OLEDBConnection.Connection, 'Provider=Microsoft.Mashup.OleDb.1', vbTextCompare) If Err.Number 0 Then Err.Clear Exit For End If If lTest > 0 Then cn.Refresh Next cn End Sub Would you be able to assist with an equivalent when using MS Query. Many many thanks.

Click an item to edit it if you need—or go back to the Outline mode to add more details. Slidebeam's automated slides will try to arrange everything on slides for you, or you can rearrange the elements, dragging them around on the grid. Best mac for creating apps. Then, select a theme and Slidebean will create a presentation for you, complete with formatting. All you have to do is write an outline of sorts, typing in headings, uploading images, and entering details for graphs.