I have a worksheet report that represents production activity in weekly periods (two columns per week). All columns are working correctly up until week 40 and after week 40, where one specific cell i...
Hwqi67 Figured out that when the month changes in the middle of the week, that week is in the previous month as well as the next month - two data references to the same week confuses GetPivotData. I separated the month data from the weekly data to solve the problem.
