If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Break link MS Excel 2000
How can I break a link to another Worksheet in MS Excel 2000? Edit -- Links
doesn't have a Break Link option in this version of Excel. I tried Select All -- Copy -- Paste Special -- Values to remove all references to other worksheets. Saved, closed, then re-opened. I'm still being prompted to Update links. I don't have access to the original worksheets this MS Excel document is linked to. Help! |
#2
|
|||
|
|||
Hi PetroChris
Use FindLink (great add-in) http://www.oaltd.co.uk/MVP/Default.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PetroChris" wrote in message ... How can I break a link to another Worksheet in MS Excel 2000? Edit -- Links doesn't have a Break Link option in this version of Excel. I tried Select All -- Copy -- Paste Special -- Values to remove all references to other worksheets. Saved, closed, then re-opened. I'm still being prompted to Update links. I don't have access to the original worksheets this MS Excel document is linked to. Help! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Activate method of Worksheet class fails in Excel 2000 | Chris Bloom | General Discussion | 3 | September 10th, 2005 12:05 AM |
PowerPoint to Excel link issues | DrLostinExcel | Powerpoint | 5 | November 19th, 2004 03:33 PM |
Paste link using Excel - Linking Excel and Visio | Will1234 | Visio | 1 | November 11th, 2004 08:15 AM |
Insert link to Excel Worksheet into Word (Office 2000) | Mark | General Discussion | 1 | November 9th, 2004 12:58 PM |
Link Lanscaped Excel spreadsheet w 14 columns into a word document | macropod | General Discussion | 1 | November 4th, 2004 01:23 PM |