Pivot tables updating wrong data values for the given filters
I've created a large excel file with many pivot tables from a single data source. I used macros to auto update pivot filters. The pivot data values show different values to the selected filters. When I double click on the data values it opens up source data in a separate worksheet with rows different from the selected filters.
Please see attached screenshots.
I can better explain this if you could call me back/arrange for a video call.