Get rid of "GETPIVOTDATA"

		Microsoft Office Forums > Microsoft Excel > Excel
Get rid of "GETPIVOTDATA"

FAQ

Thread Tools

Display Modes

09-08-2014, 01:24 PM

jmhultin

Windows 7 64bit Get rid of "GETPIVOTDATA"

Office 2013

Novice

Join Date: Aug 2013

Posts: 13

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon	CensorTilSin	Outlook	1	12-11-2013 12:05 PM
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 PM.