Forum Discussion

Copper Contributor

Aug 25, 2023

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 ve...

excel

office 365

Martin_Weiss

Bronze Contributor

Aug 25, 2023

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

HHengler
Copper Contributor
Aug 25, 2023
Yes, I have refreshed but the new info isn't appearing.
- Martin_Weiss
  Bronze Contributor
  Aug 25, 2023
  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