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

Ted wrote:
I have a problem summing cells in a pivot table. When I double-click on a
cell that I want to add, the formula from that cell gets added. Eventually I
run out of characters. Is there a way to switch how the cell gets picked up.
I can manually enter the cell addresses that I am trying to sum but that
takes forever. Thanks,

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html