Forum Discussion

jitterbug888's avatar
jitterbug888
Copper Contributor
Apr 06, 2020
Solved

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

  • ChrisMendoza's avatar
    ChrisMendoza
    Iron Contributor

    jitterbug888-

    Your Pivot Table Fields [week], [month], & [year] have filters applied. I think you'll want to check [month] is filtered as you desire.

Resources