Forum Discussion
Excel GetPivotData Function
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...
Hi
The GetPivotData creates an absolute reference and many Excel users prefer to turn of this functionality bygoing to:
- File Tab
- Select Options
- Select Formulas
- Uncheck the box for GetPivotData
- Hit OK
Hope That Helps
Nabil Mourad