Forum Discussion
pivot table and pick list problems
Hello Tech Pros, I've added 2 new rows of data in my columns, but it's not showing up in my data validation table. And my pivot table is not showing the correct data from the validation table. I'm very new to excel and failing
Hi HHengler
pivot tables show new data only after a refresh. So, usually all you have to do is a right-click somewhere in the pivot table and choose "Refresh"
After that, you should see the new values in the dropdown lists in the pivot table.
Kind regards,
Martin
- Yes, I have refreshed but the new info isn't appearing.
Hi HHengler
ok, second issue could be the type of the data table. If it's not formatted as a table (menu "Home | Format as Table") then the pivot table refers to the original dimensions of the source table. In this case you have to click in the Pivot table and then choose from the menu "PivotTable Analyze | Change Date Source"
And then select the complete range of the data table, including the new lines.
To avoid this, use the above mentioned "Format as Table" function. This way, your source table is completely dynamic and grows automatically when new data is added. And a pivot table the refers to such a formatted table gets always the correct data range (after a refresh, of course).
Kind regards,
Martin
