Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Delinking a File

Posted by Robert Wilson on October 01, 2001 5:53 AM

CAn you let me know how one file can be delinked from another?

Re: Delinking a File

Posted by Mark O'Brien on October 01, 2001 6:10 AM

Go to Edit|Links then you can change the source to be the current book. This will still keep the link relative to the book you're in, so you may want to copy everything and do a "Paste Special" for "Values".

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.