Clearing Links
 

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

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

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

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

Actually, the very best one is he 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