Solved Pivot tables in Excel

April 7, 2015 at 10:56:08
Specs: Windows 7
I have added a new row with the Number /Year data in a pivot table. I have labeled the row, but it is not showing up in the Pivot table choices. How can I get it so I can use the new column of data in the Pivot table?

See More: Pivot tables in Excel

April 7, 2015 at 12:38:18
✔ Best Answer
Did you right-click your Pivot Table and/or Chart and choose Refresh?

Did you check the Data Source and ensure that your new row is within the Data Source range?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

April 7, 2015 at 12:56:37
Yes, It was within the data range.
Clicking on REFRESH did it. Thank you!

message edited by Janettey

Report •
Related Solutions

Ask Question