Get rid of "GETPIVOTDATA"
Every time I reinstall Excel, I have to do this, but I can't remember how:
When I use data from within a pivot table in a formula, it returns some kind of lengthy "GETPIVOTDATA" formula, which is useless to me. I know there is some toggle that allows me to simply access the contents of the cell.
Can someone remind me where that is? (using Excel 2013)
Thanks
|