| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to link cell for value in another cell of pivot table?
In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata
formular. And when I drag or copy this cell, again it copies the formular. Can you help how to just get the value, then be able to drag to link next cell and its value? thanks. |
|
#2
|
|||
|
|||
|
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html JamesChoi wrote: In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata formular. And when I drag or copy this cell, again it copies the formular. Can you help how to just get the value, then be able to drag to link next cell and its value? thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions | |||
| Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
Linear Mode
