Forum Discussion
MidnightChemistry
Apr 26, 2023Copper Contributor
GetPivotData Keeps Returning #REF Error
I am working with a file that has two sheets. The first sheet has a PivotTable that pulls in monthly spend projections on purchase order #s from an external data source. The second sheet needs to pul...
JKPieterse
Apr 27, 2023Silver Contributor
Did you manually type the formula? If not, did you change the layout of the pivot table after entering that formula by any chance?