Check out this link...
http://www.contextures.com/xlPivot06.html
--
HTH...

Jim Thomlinson


"Darin" wrote:

I know this can be done (I've just forgotten where the button is) but when
creating manual formulas off of the Pivot Data it always references "Get
Pivot" etc. unless I manual type cell F3*XZY. There's a button that allows
the data to behave "normally" so when I select the cell I want to do a
formula on it will default to F3*XYZ and then I can copy and paste the data
as normal in the same sheet w/ out it only referencing like the cell is
locked. I hope that makes sense thanks!

D