| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Destoy Links
I have Excel 200 on a hard drive connected to a network I am trying to link several spreadsheets together and want my links to be only those current spreadsheets. Under Edit Links, I have about 30 spreaqdsheets listed, most don't exist any more or have been archived to a new folder. How do I get rid of these "Ghost Links"? My reference book (Excel Tip 222-224) shows a Break Link button on the Edit Links dialog box. I don't have that in 2000. Is there a way to break the links? Thanks in advance. Deb -- Deb Pingel ------------------------------------------------------------------------ Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119 View this thread: http://www.excelforum.com/showthread...hreadid=498098 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Destoy Links
Perhaps you'd like to try Bill Manville's excellent "FindLink" utility?
It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Deb Pingel" wrote in message ... I have Excel 200 on a hard drive connected to a network I am trying to link several spreadsheets together and want my links to be only those current spreadsheets. Under Edit Links, I have about 30 spreaqdsheets listed, most don't exist any more or have been archived to a new folder. How do I get rid of these "Ghost Links"? My reference book (Excel Tip 222-224) shows a Break Link button on the Edit Links dialog box. I don't have that in 2000. Is there a way to break the links? Thanks in advance. Deb -- Deb Pingel ------------------------------------------------------------------------ Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119 View this thread: http://www.excelforum.com/showthread...hreadid=498098 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| options to update automatic links | Excel Worksheet Functions | |||
| Prompt to update links | Links and Linking in Excel | |||
| Deleting links to other spreadsheets | Excel Worksheet Functions | |||
| Update links prompt not wanted | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
