Clearing Links

[Connie Martin]

In Excel 2000, I have a file that I don't want to update any more. I went to
Tools/Options/Calculation and removed the check mark in "Update remote
references", clicked OK, and saved the file. Everytime I open it, it still
asks if I want to update links. I click NO! "Update remote references" has
the check mark back again. What gives? How do I make clear the links from
this file? I know I can also do Edit/Copy/Paste special.../Values, but these
links are here and there in the file, with formulas here and there, and I
don't want to get rid of the formulas, so that Edit/Copy/Paste special...
would be a long tedious task. Connie Martin

[ancasa]

no problem....the solutions.

copy the code in an module to vb in excel and o.k. then run macros zaphyperlinks

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub


Best regards

Andy

[Connie Martin]

Sorry, you've completely lost me. I'm not an Excel guru, and surely you
shouldn't have to be one to simply get rid of links!

"ancasa" wrote:

>
> no problem....the solutions.
>
> copy the code in an module to vb in excel and o.k. then run macros
> zaphyperlinks
>
> Sub ZapHyperlinks()
> Cells.Hyperlinks.Delete
> End Sub
>
>
> Best regards
>
> Andy
>
>
> --
> ancasa
> ------------------------------------------------------------------------
> ancasa's Profile: http://www.excelforum.com/member.php...o&userid=23862
> View this thread: http://www.excelforum.com/showthread...hreadid=377072
>
>

[Connie Martin]

I found a good solution: http://support.microsoft.com/kb/q188449/

"ancasa" wrote:

>
> no problem....the solutions.
>
> copy the code in an module to vb in excel and o.k. then run macros
> zaphyperlinks
>
> Sub ZapHyperlinks()
> Cells.Hyperlinks.Delete
> End Sub
>
>
> Best regards
>
> Andy
>
>
> --
> ancasa
> ------------------------------------------------------------------------
> ancasa's Profile: http://www.excelforum.com/member.php...o&userid=23862
> View this thread: http://www.excelforum.com/showthread...hreadid=377072
>
>

[Connie Martin]

Actually, the very best one is here: http://www.mrexcel.com/td0048.html
Just download the file: http://www.herber.de/andere/findlink.zip found
part way down the page.

"ancasa" wrote:

>
> no problem....the solutions.
>
> copy the code in an module to vb in excel and o.k. then run macros
> zaphyperlinks
>
> Sub ZapHyperlinks()
> Cells.Hyperlinks.Delete
> End Sub
>
>
> Best regards
>
> Andy
>
>
> --
> ancasa
> ------------------------------------------------------------------------
> ancasa's Profile: http://www.excelforum.com/member.php...o&userid=23862
> View this thread: http://www.excelforum.com/showthread...hreadid=377072
>
>