Forum Discussion
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...
Hi Chris, all filters are "all" view, nothing is filtered out at this stage.
AAH thanks Chris ! i`ve only been using Pivtables for 3 days or so. Thanks so much!!.
ChrisMendoza I have a problem with PivotTables sometimes where they get out of synch, which isn't the same as what you are saying but here is what I do to fix it.
open the fields window and remove all the filter fields.
refresh all
replace filter fields
refresh all
like I said it isn't the same problem but it couldn't hurt to try
mtarler Thanks mtarler for the advice !
