I've done this on my old computer, but I can't remeber how. Whenever I'm building a formula, and I point to a cell within a pivot table, I get a long formula with a GETPIVOTDATA function - I want to switch that off so I get a simple cell reference.

Thanks