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