Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet links Karen Excel Discussion (Misc queries) 1 September 11th 06 02:58 PM
Problem with links not working correctly in spreadsheet Nicky Zee Excel Worksheet Functions 0 September 11th 06 06:50 AM
updating links Laura Jean Excel Worksheet Functions 1 August 19th 06 11:07 AM
Hyperlinks - Move file to local drive, all links break Shawn McGowen Excel Discussion (Misc queries) 1 March 9th 06 01:52 AM
Updating links monthly... need help Excel Worksheet Functions 0 October 13th 05 07:30 PM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"