Though the latest package is still not on par with the Windows. Microsoft Office for Mac 2011 offers a solid update to the Word, Excel, PowerPoint, and the other members of the productivity suite. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu. 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. Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. Microsoft Office for Mac 2011 applications shown on Mac OS X Snow Leopard