formulas next to pivot table
 

Hi there!

Whenever I put formulas to the right next to a pivot table, and refresh the
table, these formulas are sometimes overwritten due to the pivot table
extending with more information. Is there a way to prevent this and have
"floating" cells that moves as the pivot extends / retracts?

Thank you in advance, as usual!

formulas next to pivot table
 

Hi

If your formulae are to the right or below a PT, there is no way to stop it.
You could place your formulae to the left.

Alternatively, use the GetPivotData function to pull the data to another
sheet, and have your formulae adjacent to this fixed report.

--
Regards
Roger Govier

"PsyberFox" wrote in message
...
Hi there!

Whenever I put formulas to the right next to a pivot table, and refresh
the
table, these formulas are sometimes overwritten due to the pivot table
extending with more information. Is there a way to prevent this and have
"floating" cells that moves as the pivot extends / retracts?

Thank you in advance, as usual!