How to Find All External Links Within an Excel File 1

[zinderellie]

I am hoping to find an easy way to locate all external links with an Excel file that has multiple worksheets.

To clarify... I have an Excel file with multiple worksheets, and I need to make sure there are no external links in formulas that will produce a calculation error when this one file is sent to an outside source for review.

Hope this makes sense, and thanks in advance for your help.
Zin

"If you can imagine it, you can achieve it.
If you can dream it, you can become it." -William Arthur Ward-

 

[AnotherHiggins]

Go to Edit > Links

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.