Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i.e. I need to make a cell in worksheet show the same value, as summary of my Pivot Table?

share|improve this question
up vote 1 down vote accepted

Generally, you can just click into the cell in the pivot table you want to summarize. For a grand total it should generate a formula that looks like this:

=GETPIVOTDATA("data values",Sheet2!$A$1)

This assumes the field you're summarizing is called "data values" and that the top left cell of the pivot table is located at Sheet2!$A$1.

If this type of formula isn't automatically generated, you need to activate the "Generate GetPivotData" feature. See this Contextures page for instructions.

GetPivotData is more complex if you are summarizing subtotals or individual items. You can use variables in the formulas, which makes it quite powerful.

share|improve this answer

In the formula bar,

=<cell number of the Pivot table summary>
share|improve this answer
Bad idea. Summary is at the bottom, and table has variable count of rows – user626528 Nov 28 '11 at 12:09
you need to be more specific then what exactly your requirements are and how your data is structured. – Sathya Nov 28 '11 at 12:15
What exactly info you miss? – user626528 Nov 28 '11 at 12:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.