software

Hello,

I have an excel spreadsheet and when it opens it is asking me whether or not
to update info. I have searched using find quot;[quot; to try and find the externally
referenced programme with no joy. Please can you advide me of any other way
to track this down.

Thanks in advance

Check to see if you have an range names that reference ranges in the other
file. Click quot;Insert gt; Name gt; Definequot;. Scroll down the list of named
ranges, and looking in the quot;Refers to:quot; box at the bottom of the dialog box
for references to the other file.

You can also missing finding references in formulas if you just search on
quot;[quot;. If the formula refers to a named range in the other workbook, the
filename will not have brackets around it:

=SUM(OtherWkbk.xls!Range1)

Try searching on quot;!quot; (exclamation point) instead of the bracket. All file
name references will have an quot;!quot; in them.

Have you tried breaking the links (as opposed to editing formulas to remove
them)? Click quot;Edit gt; Links...quot;. Select the file you want to de-link, then
click quot;Break Linkquot;. Sometimes the file name will still remain in the list
even if the links really are broken, so save and close the workbook, then
re-open it to see if that worked.

Good luck!

-- David

quot;GBH99quot; gt; wrote in message
...
gt; Hello,
gt;
gt; I have an excel spreadsheet and when it opens it is asking me whether or
not
gt; to update info. I have searched using find quot;[quot; to try and find the
externally
gt; referenced programme with no joy. Please can you advide me of any other
way
gt; to track this down.
gt;
gt; Thanks in advance