Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on 

Excel 2010, 2013 - Pivot Table - How to add data to a Pivot Table

How to add data to a worksheet with pivot table data.
The pivot table is on sheet1 but the source data is on sheet2.

Do I merely append the new rows and columns to the bottom of the existing region?
Do I insert it in the middle?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Ana Neto
Avatar of Norie

Is the source data in an actual table?

If it is then you should be able to add/delete/change the data in the table and then right click the pivot table and select Refresh.
You don't add data to the pivot table, but to the data source (since the pivot table is build from the data source).
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

If the source data is not a table, just click within the data list, and use Ctrl-T to make it a table.  Then what Norie said will work, just adding data at the bottom of the table and refreshing the pivot table.
Avatar of Ana Neto
Ana Neto
Flag of Portugal image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo