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. Important note for Microsoft 365 subscriptions: After September 22, 2016, Office 2011 for Mac is no longer available for installation with a Microsoft 365 subscription.This doesn't affect one-time purchases of Office for Mac 2011 such as, Office Home and Student, Office Home and Business,. Ms Excel For Mac free. download full Version Microsoft Excel 2010 is the powerful software that has been designed to work with formulas, formatting, tables, accounting, and much more. You can do as many things as you want that come to your mind, you can create calendars using beautiful and professional templates.
Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote and OneDrive —combining the familiarity of Office and the unique Mac features you love. Work online or offline, on your own or with others in real time—whatever works for what you’re doing. Customer support and troubleshooting for Office for Mac 2011 ended October, 2017. To get all the latest features, upgrade to Office 2016 for Mac. Make a one-time purchase, or buy a Microsoft 365 subscription and stay up to date. Work with sheets and data.
![Download ms excel 2011 for mac versions Download ms excel 2011 for mac versions](/uploads/1/2/6/7/126749847/754335736.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).
See solution in other versions of Excel:
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.
Download Ms Excel 2011 For Mac 64-bit
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.
Download Excel 2011 For Mac Free
Now when you return to your pivot table, it should display information from the new data source.