View Single Post
 
Old 09-08-2014, 01:24 PM
jmhultin jmhultin is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2013
Posts: 13
jmhultin is on a distinguished road
Default 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
Reply With Quote