Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I get rid of old links in a spreadsheet?
It's bugging the bejeezus ou of my users (especially the folks opening it via
trans-oceanic links). There are tons of pop up messages saying Unable to open http://blahblah.bla.com/Documents/Stuff.xls. The internet site reports that the item you requested could not be found. (HTTP/1.0 404). Now obviously it's trying to pull up links that no longer exist. How can I either 1(Prefered) remove dead links or 2(Not so good) make it stop popping up with these errors? These are very large spreadsheets. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I get rid of old links in a spreadsheet?
Take a look at this link and download Bill Manville's FindLinks addin...
http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "JeremyInNC" wrote: It's bugging the bejeezus ou of my users (especially the folks opening it via trans-oceanic links). There are tons of pop up messages saying Unable to open http://blahblah.bla.com/Documents/Stuff.xls. The internet site reports that the item you requested could not be found. (HTTP/1.0 404). Now obviously it's trying to pull up links that no longer exist. How can I either 1(Prefered) remove dead links or 2(Not so good) make it stop popping up with these errors? These are very large spreadsheets. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I get rid of old links in a spreadsheet?
That works to find where the links are, but how do I delete them? If I tell
it to delete or ask it pops up with a window that says it cannot do it with out a name. I have no idea what I should be naming this stuff or if I am destroying the integrity of the worksheet. "Jim Thomlinson" wrote: Take a look at this link and download Bill Manville's FindLinks addin... http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "JeremyInNC" wrote: It's bugging the bejeezus ou of my users (especially the folks opening it via trans-oceanic links). There are tons of pop up messages saying Unable to open http://blahblah.bla.com/Documents/Stuff.xls. The internet site reports that the item you requested could not be found. (HTTP/1.0 404). Now obviously it's trying to pull up links that no longer exist. How can I either 1(Prefered) remove dead links or 2(Not so good) make it stop popping up with these errors? These are very large spreadsheets. |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I get rid of old links in a spreadsheet?
Don't worry about destroying the integrity of the worksheet.
If you make a mistake, you are only harming the backup copy you are working on. That's how we learn to do things. Twist it until it breaks then drag out the next backup copy and start twisting on that one. Gord Dibben MS Excel MVP On Tue, 12 Sep 2006 10:41:02 -0700, JeremyInNC wrote: That works to find where the links are, but how do I delete them? If I tell it to delete or ask it pops up with a window that says it cannot do it with out a name. I have no idea what I should be naming this stuff or if I am destroying the integrity of the worksheet. "Jim Thomlinson" wrote: Take a look at this link and download Bill Manville's FindLinks addin... http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "JeremyInNC" wrote: It's bugging the bejeezus ou of my users (especially the folks opening it via trans-oceanic links). There are tons of pop up messages saying Unable to open http://blahblah.bla.com/Documents/Stuff.xls. The internet site reports that the item you requested could not be found. (HTTP/1.0 404). Now obviously it's trying to pull up links that no longer exist. How can I either 1(Prefered) remove dead links or 2(Not so good) make it stop popping up with these errors? These are very large spreadsheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet links | Excel Discussion (Misc queries) | |||
Problem with links not working correctly in spreadsheet | Excel Worksheet Functions | |||
updating links | Excel Worksheet Functions | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
Updating links monthly... | Excel Worksheet Functions |