Hi All,

Is it possible to use GETPIVOTDATA for data that doesn't exist yet?

For example, I want a sheet to return all of the values from a pivot table and update as the pivot table grows with new data.

Am I off my rocker?