You could give Bill Manville's Find Link Excel add-in a try.
It can provide a list of all the links in a workbook.
Maybe that will do the job for you. Available here...
http://www.oaltd.co.uk/MVP/Default.htm

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Mark"
wrote in message
Hello,
I have looked through the board for awhile and cannot locate the answer I
need.
I have a consolidated excel file that links from 2 to 13 excel worksheets
depending on the month. What I usually do every month is copy and paste the
links depending on how many files I need. This wouldn't be so bad but there
are about 30,000 different links to the various tabs. It takes forever to
copy and paste the forumla to the consolidated file linking the excel
worksheets. Sometimes I'm in luck and the number of worksheets needed are the
same so all I have to do is change source (which still takes time but its
only one click).
Any ideas on what I could do?
Thanks in advance...