Forum Discussion
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...
Did you manually type the formula? If not, did you change the layout of the pivot table after entering that formula by any chance?