| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 Pivot Table: Can I copy link cell across ?
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 -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 Pivot Table: Can I copy link cell across ?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 Pivot Table: Can I copy link cell across ?
Hello Debra,
Many thanks for your tips and the recommended resources. Your website is great. Best Wishes Low -- A36B58K641 "Debra Dalgleish" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table changes cell contents - Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel Pivot Table link page field to spreadsheet cell | Excel Discussion (Misc queries) | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Hybrid Mode
