Forum Discussion
jitterbug888
Apr 06, 2020Copper Contributor
pivot table wont update.
I have sheet 1 where I will enter my data.
namely Date, Invoice Amount, and this normally reflects in the pivot table on Sheet 2. after I press ctrl alt F5 or refresh all. The chart then also udates, but when I enter data now nothing happens, even after attempting a refresh. ?
attached spreadsheet here.
data for the pivot table,
here on the pivot table, the years are showing up in the filter, but nothing visible in the table itself even after refresh, see attached workbook.
6 Replies
- ChrisMendozaIron Contributor
Your Pivot Table Fields [week], [month], & [year] have filters applied. I think you'll want to check [month] is filtered as you desire.
- jitterbug888Copper Contributor
Hi Chris, all filters are "all" view, nothing is filtered out at this stage.
- ChrisMendozaIron Contributor