is there anyway you can see what links to other workbooks are associated with
the workbook you have open.

The problem i am having is when i open the workbook in question a message
appears and states "The workbook you opened contains automatic links to
information in another workbook. do you want to update this workbook with
changes made to the other workbook" Yes....... No. if i click No the workbook
opens, however if i click Yes the workbook just hangs and i have to go into
task manager to shut down the system. I can only assume that there is a
problem with one of the links.

ANY HELP PLEASE

Edit / Links

If you want to discover where the links are used, try FINDLINK from
http://www.OALtd.co.uk/mvp

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Try this: Navigator Utilities.

You can easily navigate and audit your workbooks using the following
Navigator tools:
Sheets - easily navigate through worksheets
Links - for all those hard to find links
Named Ranges - navigate through local/global and hidden names
Enhanced Find/Replace
Objects - easily find charts, drawings, comments, etc
Trace - navigate through cell dependents and precedents
You can find it at: http://www.robbo.com.au/