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 wrote:
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 ?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html