Copying pivot table results

[Alex]

Hi, I am using pivot tables to analyze data. I need to be
able to link (past-link) the reults, i.e. grand total.
from one pivot table to another cell in a worksheet.

It seems impossible to copy certain cells with pivot
tables when they change shape and format depending on the
data options chosen.

Example.. cell G3 contains the grand total - i need to
copy it.

I then change the data ranges in the pivot table and now
cell H3 contains the grand total..i need to copy it??? how
can i do this as an automatic function???!!

Please help!

Thanks, Alex

 

[Ken Wright]

If you link the total cell to another cell, ie in any cell you hit = and then
click on the total, does it appear with a GETPIVOTDATA formula? eg

=GETPIVOTDATA("Sales",$A$3)

If not, then display the Pivot table Toolbar, hit the button that looks like a
square with an arrow coming up from a corner, and if you hover over it, it says
'Generate Getpivotdata'. Now try doing it, and you shoudl see something like
the formula above. You can move it around all you like now, as long as you
don't generate a table that will overwrite the cell containing your formula, OR,
remove the field you just summed from the Data area.

 

[Debra Dalgleish]

You can use the GETPIVOTDATA function to extract data. Look in Excel's
help for information and examples for your version of Excel.

In Excel 2002, this formula can be created automatically if the Generate
GetPivotData feature is enabled. For older versions, you'll have to
create the formula manually.

In Excel 2002, you can choose Tools>Customize, and from the Data
category on the Commands tab, add the Generate GetPivotData command to
one of your toolbars. Use this button to toggle the feature on and off.

 

[Guest]

No, it just acts the same as a normal linked cell,
although when the format area of the pivot table changes
the cell then contains either nothing or another unwanted
value.

 

[Ken Wright]

See Debra's reply for a more detailed response and see if that helps. What
version of Excel are you running?

 

[Guest]

2000

-----Original Message-----
See Debra's reply for a more detailed response and see if that helps. What
version of Excel are you running?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 11/02/2004


.