say =Sheet1!B32; then just drag the formula from there.
by typing in the reference vs selecting, the new table picks up the cell as opposed to a piece of pivot.
for the whole pivot table on a new sheet.
If it's something I'll use again, I'll use SUMIF instead of a pivot table.
but that gets old
I am hoping someone knows how to make cell references work. many times there is a way, I need an Excel Jedi to show me