Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas within a pivot table | Excel Discussion (Misc queries) | |||
Formulas within a pivot table | Excel Discussion (Misc queries) | |||
pivot table formulas | Excel Discussion (Misc queries) | |||
formulas in pivot table | Excel Worksheet Functions | |||
Pivot Table vs. Formulas | Excel Worksheet Functions |