Excel 2003 Pivot Table as a source cell -

[Guest]

Had Excel 95 worksheet with PivotTable as a source for several other tables
on different tabs. Company upgraded to Windows 2003 and now cannot use the
copy and paste function to find correlating PivotTable cells. E.g., Table 1,
Cell A1 = Pivot Cell A1, then copy that down in the table and everything is
perfect in 95, but 2003 version get error messages all over the place and at
one point document would not even save. IT appears the problem is the new
labeling feature in the Pivot Table - can it be turned off or is there a work
around. Am desperate.

 

[Debra Dalgleish]

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