pivot table and pick list problems

Copper Contributor

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

3 Replies

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"

Martin_Weiss_0-1692977983056.png

 

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"

Martin_Weiss_0-1692978548101.png

 

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