I have about 80 fromulas that I need to update
It's a lot easier to list the formulas in a worksheet the change them there

does any one know Vba code that would update the formula in the pivottable
from the worksheet

--
Helping Is always a good thing