catalog external links and list all pivot table sources
 

Two (possibly) related questions:

1) What is the easiest way to create a list of external links for a workbook?
2) What is the easiest way to create a list of all tables on which a
workbook's pivot tables are based?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.