I've been making copies of a spreadsheet for a project (say ABC.xls
[orig], and DEF.xls [copy]), and in the process, accidentally made an
external workbook reference that I can't seem to get rid of. Whenever I
open DEF.xls, I get a prompt for Update/Don't Update.

Since external referencing uses [ABC.xls] in the formula, I ran a
search and replace for 'ABC.xls' and removed those instances. However,
I still recieve a prompt when I open DEF.xls.

Is there a way to highlight cells referencing another workbook, or any
other way to remedy this situation?

Thank you


--
timsantiago
------------------------------------------------------------------------
timsantiago's Profile: http://www.excelforum.com/member.php...o&userid=28656
View this thread: http://www.excelforum.com/showthread...hreadid=483507