The Windows and Mac variations of PowerPoint are also mostly in. Here are a couple things to note, though: These are some quite power user features, so it’s likely you will not miss them much. Both variations support all the significant functions. If you’re accustomed to using workbook and worksheet events for triggering your VBA routines, you’re in for a disappointment – none of these will execute on MAC.Ħ. Fortunately, the variation in between the Windows and Mac variations of Excel are minimal. There’s no option to apply a value filter that has been placed in second or further position in the pivot table.ĥ. Excel for MAC does not support Pivot Charts.As a result, they will no longer be interactive and change simultaneously with their source Pivot Table but remain static screenshot-like graphsĤ.Pivot table value filters on Excel for Mac can only be applied to the left-most value field. It does work for ODBC connections, though, so this may be your workaround…ģ. So will be any pivot table, that was created via the “Import from Microsoft Access Database” option as Excel for MAC does not support OLEDB connections, either. Multi-threaded, simultaneous calculations of spreadsheet formulas is now supported in the latest Excel for Mac release.Consequently, any pivot table based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user. 1.Excel for MAC does not support PowerPivot. And so much more.' Says Apple: 'All the business apps you need run beautifully on Mac - from Microsoft.
