How do I get rid of old links in a spreadsheet?

G

Guest

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.
 
G

Guest

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get rid of expired links 3
Automatic update of links has been disabled - how do I get rid of 1
Get rid of Automatic Links when opening 2
How do I get rid of automatick links? 3
Link bar links open in new window - how do I stop that? 3
How do I get rid of a blank row at bottom of Excel spreadsheet? 1
how to get rid of errors? 1
how do I link 2 differnt spreadsheets to pull specific info. 2

Top