How to link cell for value in another cell of pivot table? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
JamesChoi 9/14/2005 5:59 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Debra Dalgleish 9/14/2005 7:26 PM PST
  Answer
  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

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies