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

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

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
 
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.
 
Hello Debra,

Many thanks for your tips and the recommended resources.

Your website is great.

Best Wishes

Low
 
Back
Top