Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 106,792 times.
Learn more...
After you create a pivot table, you might need to edit it later. This How.com.vn will show you how to edit a pivot table in Excel on your computer by adding or changing the source data. After you make any changes to the data for your Pivot Table, you will need to refresh it to see any changes.
Steps
Download Article
Open your project in Excel. To do this, double-click the Excel document that contains your pivot table in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file that has your pivot table.
Go to the spreadsheet page that contains the data for the pivot table. Click the tab that contains your data (e.g., Sheet 2) at the bottom of the Excel window.Advertisement
Add or change your data. Enter the data that you want to add to your pivot table directly next to or below the current data.- For example, if you have data in cells A1 through E10, you would add another column in the F column or another row in the 11 row.
- If you simply want to change the data in your pivot table, edit the data here. It won't be reflected in the pivot table until you refresh the data, though.
Go back to the pivot table tab. Click the tab on which your pivot table is listed.
Select your pivot table. Click the pivot table to select it.
Click the Analyze tab. It's in the middle of the editing ribbon that's at the top of the Excel window. Doing so will open a toolbar just below the editing ribbon.- On a Mac, click the PivotTable Analyze tab here instead.
Click Change Data Source. This option is in the "Data" section of the Analyze toolbar. A drop-down menu will appear.
Click Change Data Source…. It's in the drop-down menu. Doing so opens a window.
Select your data. Click and drag from the top-left cell in your data group down to the bottom-left cell in the group. This will include the column(s) or row(s) that you added.
Click OK. It's at the bottom of the window.
Click Refresh. It's in the "Data" section of the toolbar.- If you added a new column to your pivot table, check its box on the right side of the Excel window to display it.[1]
Expert Q&A
Tips
References
About This Article
1. Open your project in Excel.
2. Go to the spreadsheet that contains the data for the pivot table
3. Add or change your data.
4. Go back to the pivot table tab.
5. Select your pivot table.
6. Click Analyze tab (Windows) or PivotTable Analyze (Mac).
7. Click Change Data Source.
8. Click Change Data Source.
9. Select your data.
10. Click Ok.
11. Click Refresh.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
