You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Yes, turn off as sam_w has linked.
It depends exactly what you're picking up. It sounds like you really want to be using formulas that are selecting something to pick up the correct cells in your links so new stuff appearing won't screw up your links. Hard to tell without knowing what you're linking to/from though.
aggi
Thanks both @Sam_w & @aggi by turn off getpivotdata do you mean that is a setting (edit: Google tells me it is) I can disable, or replace it with direct cell? ref e.g.
Which could work until new rows appear mid pivot I think?
I inherited Worksheet B with lots of nested SUMIF's which I considered to be a very complex way of doing what Pivot Table does, but I guess it might have some advantages afterall. FILTER looks like it might help too.