Is there any nifty way to find all the Data Ranges referred to in all the
Pivot tables in a file.

I needed to change the ranges referred to and want to make sure I got them
all.

Thanks