Linked Spreadsheets

johnston_joan · May 15th, 2002, 11:23 AM

I'm working on a file that, somehow, has been linked to another workbook. The linked workbook doesn't exist. How can I delete the link?

Drmwvr7266 · May 15th, 2002, 11:31 AM

Click on EDIT, then on LINKS and BREAK LINK. This will svere the liink. You can also edit the link if need be.

johnston_joan · May 15th, 2002, 11:40 AM

Thanks, however, I don't have the Edit or Break Link option in the Links option box. Is it because I'm working on Excel 97?

Steve Hartman · May 15th, 2002, 11:45 AM

Do the edit > Links thing and choose change source. select the file you currently have open and it will break the link. You are basicly linking the file to itself.

NateO · May 15th, 2002, 04:37 PM

Speaking of links, Barrie dropped a good one to a MS add-in to help clean up your file. See post #2 if you're still having trouble.

http://www.mrexcel.com/board/viewtop...c=8267&forum=2

May 15th, 2002, 04:37 PM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Speaking of links, Barrie dropped a good one to a MS add-in to help clean up your file. See post #2 if you're still having trouble. http://www.mrexcel.com/board/viewtop...c=8267&forum=2 __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 11:23 AM	#1
johnston_joan New Member Join Date: Apr 2002 Posts: 11	I'm working on a file that, somehow, has been linked to another workbook. The linked workbook doesn't exist. How can I delete the link?

May 15th, 2002, 11:31 AM	#2
Drmwvr7266 Board Regular Join Date: Apr 2002 Location: Nashua NH Posts: 164	Click on EDIT, then on LINKS and BREAK LINK. This will svere the liink. You can also edit the link if need be.

May 15th, 2002, 11:40 AM	#3
johnston_joan New Member Join Date: Apr 2002 Posts: 11	Thanks, however, I don't have the Edit or Break Link option in the Links option box. Is it because I'm working on Excel 97?

May 15th, 2002, 11:45 AM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Do the edit > Links thing and choose change source. select the file you currently have open and it will break the link. You are basicly linking the file to itself.