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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Are copied Pivot Tables "linked" to each other ? 2
Linking Pivot Table data 3
Select a cell in a Pivot table 2
Single Filter to change all Pivot Tables in a Workbook 8
Copying pivot table 2
Excel 2002: Can Pivot Table show headings beside the row labels ? 2
Duplicating Pivot Tables 2
Excel 2002 Pivot Table: Can I customize formulas ? 3

Back
Top