Does Excel For Mac Have Pivot Tables

MS Excel 2011 for Mac: How to Change Data Source for a Pivot Table. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu. When the Change PivotTable Data Source window appears, change the Location value to reflect the new data source for your pivot table. Click on the OK button.

It appears Joe has no clue about this. All it would take for him to do is to press Cmd + Alt + P in 2011 to see what happens.

But I guess he couldn't be bothered. As you already know, when you press Cmd + Alt + P is a keyboard shortcut to display the PivotTable wizard. The wizard has been cut from 2016. The Ribbon is supposed to replace the wizard. If you can provide a step-by-step what you are doing in 2011 in a reply perhaps someone out here in internetland can explain how to do the same thing 2016.

I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. It appears Joe has no clue about this. My tasks google.

All it would take for him to do is to press Cmd + Alt + P in 2011 to see what happens. But I guess he couldn't be bothered. As you already know, when you press Cmd + Alt + P is a keyboard shortcut to display the PivotTable wizard. The wizard has been cut from 2016. The Ribbon is supposed to replace the wizard. If you can provide a step-by-step what you are doing in 2011 in a reply perhaps someone out here in internetland can explain how to do the same thing 2016. Not sure about MAC products or functionality but you can use the wizard in Office 2016.

My Employer upgraded use to Windows 10 and Office 2016. The Wizard is still available. It can be added to a new group in the ribbon. It can still be accessed via shortcut by using + then as usual.

However, on our network, step 3 of the wizard will fail if you choose to put the pivot table in a new sheet. It still works if I select existing sheet. I can then cut/paste the newly created pivot table to a different sheet afterwards. This issue started with a recent update of Microsoft server side products on our network.

Folks are fairly clueless as to how to fix this and I can not find documentation from Microsoft on the problem or solution. If, however, you do not use consolidation ranges in pivot table functionality then you do not need the old wizard. I do not, therefore I should just use the newer 2-step process off the existing menu.

Hi Cupolone, Based on your description, you wanted to open *.cub file in MAC. First you need to know, Analysis Services is a built-in component of the Microsoft SQL Server software, and this applet uses files stored in the CUB format. Microsoft developed the CUB format as data files created and referenced by Analysis Services. And to open *.cub file OLAP (Online Analytical Processing) can be performed using the data in these CUB files. The PivotTable Service program is a component of the Microsoft SQL Server software, and it can be used to access the content of a CUB file. The Microsoft Excel spreadsheet application can also be used to open these CUB files for offline analysis, which means users of Microsoft Windows-based systems with Excel can open and save these CUB files as offline cubes. You can get these information from this link: Please Note: Since the web site is not hosted by Microsoft, the link may change without notice.

Microsoft does not guarantee the accuracy of this information. As the article you need to install SQL server and Office program, but SQL Server will not run on Mac OS. Hope it's helpful.

Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi Cupolone, Based on your description, you wanted to open *.cub file in MAC. First you need to know, Analysis Services is a built-in component of the Microsoft SQL Server software, and this applet uses files stored in the CUB format.