The VBA editor on Excel for Mac 2016 is in a sorry state compared to its windows counterpart. The following image shows an error message while opening a file in MacOS.
Any pivot table having source data based on Excel data model will be unfilterable if the spreadsheet is opened by a Mac user. Static Charts can be depicted in Mac, but they are not interactive like Windows excel charts and they don’t update upon changing the source pivot table. The below table clearly shows the major differences in windows and MacOS versions of Excel. In this article, we will be focusing on some of the major differences between Excel for Windows & Mac. Excel is one of the widely used spreadsheet applications created by Microsoft for Windows, MacOS, Android and iOS.
