Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut links between worksheets in same workbook | Excel Worksheet Functions | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |