Interactive dashboard created in using MS Office 365 enterprise for Windows (using pivot slicers and timelines) doesn’t work on Office 365 for mac

Question

Good afternoon.

Our company has developed a interactive dashboard using MS Office 365 for Windows, using features like power query, data models pivot slicers and timelines. It works perfectly across the various services we have, even if we share it outside of our organization everyone is able to open and interact with the dashboard. However a new board member used Office 365 for mac and the dashboard doesn’t work. The slicers are non-responsive as if they were just images.

Would you be able to help with us with this.

Thank you in advance.

All the best,

Marco Branco

Answer 1

Hi Marco,

When Satya Nadella took over the reigns as Chief Software Engineer from Bill Gates, he had a vision that using a single code base would enable Microsoft Office to run nearly identically across all end points: Windows, Mac, iPhone, iPad, iPod, Android and (at the time) Windows Phone.

During the middle of Office 2016's life, Microsoft made the big switch in code base from Mac code base to the common Office code base. It was when the version numbers went from 15.x to 16.x in the fall of 2018. That change killed off some Mac-only features and brought in many features that previously were Windows-only. It brought the 64-bit version of Microsoft Office to the Mac, something Apple had been pushing for since Mac OS 9 was replaced.

In theory, with the base being the same for Office for Mac and Office for Windows, with a little tweaking here and there Mac users and users of the web versions of Office should automatically get all the latest Office features in Microsoft Office.

Sadly, Satya's vision has failed. Along with it, Office for Mac and Office for the web appear to be over.

This quote from the UserVoice forum "...we’ll be unable to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS" means Microsoft has thrown in the towel. They've given up. It seems that every feature that relies heavily on Windows APIs is simply too difficult to bring forward. To me, it appears Office for Mac and Office on line products are officially dead.

PowerPivot, the Data Model, UserForms, Ribbon customizations, 3D maps, Com Add-ins - all of these are core features of Microsoft Office that are now missing or broken in Office for Mac and Office for the Web. Without them, a workbook that ought to work cross-platform simply falls apart, as yours did. You have complete data loss. Complete loss of functionality.

Gong forward, that leaves only the Windows Desktop version of Microsoft Office as a viable office product in the Microsoft sphere.

This means that you and everyone who uses Microsoft Office in an cross-platform environment needs to make choices.

You are lucky that you have an Office 365 subscription because you can run the Windows version of Microsoft Office on your Mac using the same license. Perpetual license holders can't do that.

To run Microsoft Office for Windows on your Mac you will need to purchase a retail copy of Microsoft WIndows and be willing to run and support Windows on your Mac. You can use Apple's all-or-nothing Boot Camp and choose whether to run Mac OS or Microsoft Windows when you boot your Mac. Or, you can use Parallels (another added cost) and run Microsoft Office concurrently with your Mac applications. Microsoft Office runs well in both Boot Camp and Parallels.

What about other Office products? I think the next best thing to Microsoft Office is Libre Office. LibreOffice is better than Microsoft Office at cross-platform compatibility. You can build your documents, workbooks, and presentations on one platform and be pretty darn shure your files will work on Windows and Mac. LibreOffice falls down in that its automation story is pitiful. Its feature set is more than 10 years out of date. Here's what your workbook looks like when opened in LibreOffice:

If you can live without the new stuff, then LibreOffice is a very good alternative to Microsoft Office. It's dated, yes. But it's free and easy to support. It's definately worth looking into. 10 years-ago Office was not that bad.

There are some BI (Business Intelligence) programs that are cross-platform. Tableau is one that comes to mind because it is favored by academics. It's pricey and focuses on the charting aspects of Excel. There's no word processor, a limited and weak presentation component, and no email. Tableau and its competitors are very pricey for what you get IMHO.

Sorry to have to deliver what I consider to be bad news.

Answer 2

Good morning.

Yes please do share the link.

The feedback buttons are on the excel online version, correct?

Thank you,

Marco

Answer 3

Dear Macro,

If you approve that the SharePoint anonymous link can be shared publicly, welcome to provide the link here.

About the Excel Feedback option, it is in the Excel for Mac application. I suggest you open the Excel for Mac application>Help>Feedback to report this issue to our related team directly.

Thanks for your understanding and effort.

Cliff

Answer 4

Thank you Cliff.

I don’t have direct access to Excel for mac but will request that the user places the issue directly there.

Thank you for your help. At least i know that there isn’t anything we could have done to make the file work and the issue lies on the Office for Mac incompatibility.

All the best,

Marco

Answer 5

Hi Marco,

PivotTables, Slicers and TimeLines are supported in Excel for Mac. I can not download your example file because Cliff obliterated the download link you provided.

I can provide a screen shot showing that there is full support for these features.

You can modify your previous reply and restore the broken link, or reply again with the download link. I think it is unfortunate that Cliff has left you with the impression that this is a platform compatibility issue. These features work cross-platform Mac and Windows. I am not aware of any reports of incompatibility other than yours, which suggests the problem lies with the data or perhaps the way the features are being used.