Menu
I use a Mac for work, and I have to send pivot table reports to colleagues and clients that use both PCs and Macs. I am using Excel 2007 to create the pivot tables, and I am having a lot of problems with producing a pivot table that looks the same on both Mac and PC.
Creating the pivot table on my Mac is such a pain, so I am now creating the tables on my personal PC. After I get the pivot table created and formatted it works/looks great on the PC, and any PC users I send it to. The problem I am having is when I send it to Mac users. All formatting seems to lost/messed up, and I can't seem to fix this on the Mac. I need the pivot tables to look professional and consistent for everyone I send them to, PC or Mac.
I am wondering if I need to write a macro to make the formatting stay the same on the Mac, and if I do, I am wondering how to do that? If anyone could help me out with this I would really appreciate it! Thanks!
Creating the pivot table on my Mac is such a pain, so I am now creating the tables on my personal PC. After I get the pivot table created and formatted it works/looks great on the PC, and any PC users I send it to. The problem I am having is when I send it to Mac users. All formatting seems to lost/messed up, and I can't seem to fix this on the Mac. I need the pivot tables to look professional and consistent for everyone I send them to, PC or Mac.
I am wondering if I need to write a macro to make the formatting stay the same on the Mac, and if I do, I am wondering how to do that? If anyone could help me out with this I would really appreciate it! Thanks!
- Secondly, Microsoft developed a feature for Excel that Lotus didn’t provide in 1-2-3, namely PivotTables. The PivotTables feature, exclusive to Excel, was deemed so staggeringly useful that people were willing to learn an entire new software package (Excel) rather than stick with a program (1-2-3) that didn’t have it.
- Click on the PivotTable button and select Create Manual PivotTable from the popup menu. A Create PivotTable window should appear. Select the range of data for the pivot table and click on the OK button. In this example, we've chosen cells A1 to D13 in Sheet1.
- How to unpivot a table in Mac Excel 2011: Press: Command + Alt + P to bring up the Pivot Table wizard; Choose the 3rd option 'Consolidate Multiple Ranges' Choose 'I will define my page fields' Select the whole table and add it to the ranges; Click finish (to create the pivot table in.
![Mac Mac](/uploads/1/2/7/1/127166076/605940699.png)
This Excel tutorial explains how to change the data source for a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).
Excel Pivot Table Training Pdf
See solution in other versions of Excel:
By Geetesh Bajaj, James Gordon. In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook.If you’re PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac.
How To Do A Pivot Chart In Excel For Macs
Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Answer:Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. 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.
Microsoft Pivot Table 2016
![How to do a pivot chart in excel for mac os How to do a pivot chart in excel for mac os](/uploads/1/2/7/1/127166076/177884440.png)
How To Do A Pivot Chart In Excel For Mac Osx
Now when you return to your pivot table, it should display information from the new data source.