Pivot Table Problem

[Val Steed]

When we try to reference a formula inside of the table and then copy down or
accross the absolute nature of the formula now does not allow us to copy
this in a relative format.

Any ideas?

 

[MattShoreson]

unfortunately, absolute cell references dont change when filling dow
and across

 

[Debra Dalgleish]

You can prevent the GetPivotData formulas from appearing. 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