Pivot Tables in Office 2002 vs Office 97

  • Thread starter Thread starter RHinNC
  • Start date Start date
R

RHinNC

My company recently upgraded from 97 to 2002 versions of Office. I was
comfortable using pivot tables in 97 and am appreciating the new features of
pivot tables in 2002. I do have one question. When I select a couple of
cells in the pivot table to add, or do some other simple calculation I get a
huge link that references the pivot table, a lot of $ signs, etc. In office
97 I simply got the cell locations. Can this be done in 2002?

Thanks
 
You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

As an alternative, you can simply type an equal sign, and type the cell
reference, instead of clicking on the cell to reference it.
 
Back
Top