Excel 2002 Pivot Table: Can I copy link cell across ?

[Mr. Low]

Dear Sir,

I use pivot table to summarized large data quite frequently.

At times I need to extract data from the pivot table into the formats of my
own by linking cells.

So far I noticed that I could not copy the cell across or downwards as what
I usuaally do in the ordinary worksheets.

May I know if it is possible to overcome this problem ?


Thanks

Low

 

[Debra Dalgleish]

In Excel 2002 and later versions, a GETPIVOTDATA formula is
automatically created when you link to a cell in a pivot table. There
are instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling that feature on and off:

http://www.contextures.com/xlPivot06.html

When it's turned off, you'll create a normal reference when you click on
a cell in the pivot table. Then you'll be able to copy across or down.

 

[Mr. Low]

Hello Debra,

Many thanks for your tips and the recommended resources.

Your website is great.

Best Wishes

Low