GETPIVOTDATA formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2889815%22%20slang%3D%22en-US%22%3EGETPIVOTDATA%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889815%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20file%20with%203%20worksheets%2C%20the%20first%20one%20is%20my%20raw%20data%2C%20the%20second%20one%20is%20my%20pivot%20data%20table%20and%20the%20third%20one%20is%20a%20table%20where%20I%20use%20the%20getpivotdata%20formula%2C%20which%20works%20perfectly.%20However%20when%20I%20update%20the%20data%20from%20my%20raw%20and%20pivot%20data%2C%20it%20does%20not%20update%20on%20my%20table%20with%20the%20getpivotdata%2C%20unless%20I%20cut%20and%20paste%20the%20formula%20in%20each%20cell%2C%20is%20this%20normal%3F%20How%20can%20I%20get%20it%20to%20update%20by%20itself%20when%20I%20clic%20on%20the%20update%20button%3F%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2889815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2889873%22%20slang%3D%22en-US%22%3ERe%3A%20GETPIVOTDATA%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889873%22%20slang%3D%22en-US%22%3EFound%20the%20solution%2C%20I%20need%20to%20save%20the%20file!%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E
New Contributor

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!

1 Reply
Found the solution, I need to save the file!
Thanks