Oct 27 2021 03:17 AM
Hi there,
I have a file with 3 worksheets, the first one is my raw data, the second one is my pivot data table and the third one is a table where I use the getpivotdata formula, which works perfectly. However when I update the data from my raw and pivot data, it does not update on my table with the getpivotdata, unless I cut and paste the formula in each cell, is this normal? How can I get it to update by itself when I clic on the update button?
Many thanks!