Excel 2016 for Mac Viewer

Question

Hello:

I have Office 2011 for Mac. I can't upgrade the version of my Office because it's an enterprise contract.

Recently, I received an XLSX file made with Excel 2010 for Windows that contains dynamic tables with data segmentation. Has anybody any idea about how I can view this type of file? Do you know if there's a viewer for Microsoft Excel 2016 for Mac?

Thanks

Answer 1

There is no viewer for Mac Excel that will do this. Based on your enterprise restrictions, i'm afraid you are out of luck. You will not be able to open and properly view, much less manipulate this type of file on the Macintosh. Use the smiley face in the upper right of Excel's menu bar to tell Microsoft of you disappointment. Better yet have you entire enterprise do this, maybe it will prompt Microsoft into realizing how important this is.

Answer 2

When I'm opening the file, an error message appears indicating that this version is unable to use segmented data.

Regards

Answer 3

Thanks for your answer, but I can not use a trial version, even in a virtual machine :(

Regards

Answer 4

Sounds like your data is within an Excel Data Model. This feature is not currently supported in Excel for Mac. 

Meanwhile, you can add your voice to the thousands who have requested this functionality, comment on, and read Microsoft's response here:

Add support for Power Components (Power Pivot, Query, Map, etc.)