Hi all
I have searched the forums and suprisingly couldn't find anything that seemed similar, but apologies if this has been raised before.
I've inherited a spreadsheet that's clearly been a work in progress for several months and is littered with pivot tables which then feed out to various formatted tables for reports.
Is there any way that I can find out where a pivot table is linked to via a formula (i.e. GETPIVOTDATA)? I need to find out where all of these pivots are linked into so I can fully understand how this thing was built (in the dark is my first guess
).
Other than a clunky search process which I am currently subjecting myself to, I can't think of an efficent way of finding out where all of this data goes.
Any ideas?
Thanks
Phel
I have searched the forums and suprisingly couldn't find anything that seemed similar, but apologies if this has been raised before.
I've inherited a spreadsheet that's clearly been a work in progress for several months and is littered with pivot tables which then feed out to various formatted tables for reports.
Is there any way that I can find out where a pivot table is linked to via a formula (i.e. GETPIVOTDATA)? I need to find out where all of these pivots are linked into so I can fully understand how this thing was built (in the dark is my first guess
).Other than a clunky search process which I am currently subjecting myself to, I can't think of an efficent way of finding out where all of this data goes.
Any ideas?
Thanks
Phel
