I feel like I'm going crazy. Help please!
I have a pivot table with a slicer. I then created a separate report with a GETPIVOTDATA formula. In one file if I use the slicer to change my filters the GPD report is updated with the change in slicer. I created a second file with different data and tried to do the same thing (created pivot table, applied slicer, created a new report with GPD but in the 2nd file the data in my GPD is not updating if I change the slicer. WHAT THE WHAT?!
Any insight?
Thank you!
I have a pivot table with a slicer. I then created a separate report with a GETPIVOTDATA formula. In one file if I use the slicer to change my filters the GPD report is updated with the change in slicer. I created a second file with different data and tried to do the same thing (created pivot table, applied slicer, created a new report with GPD but in the 2nd file the data in my GPD is not updating if I change the slicer. WHAT THE WHAT?!
Any insight?
Thank you!