Forum Discussion
Keeping up with changed cell references used in calculations in other cells in refreshed pivot table
I am trying to create a pivot table from a daily downloaded Excel sheet that is in reality a simple table containing rows of stock positions sorted by account. The number of rows for each account wil...
JRClev You don't share the real pivot table with us. Just some pasted values. Thus, the GETPIVOTDATA formulae are broken. But never mind. If you want to calculate the 5% position, you don't need to reference the subtotal in F10. A formula like:
=F3/O3*5%in P3 (and copied down) will do that trick.