MrExcel.com - Your One Stop for Excel Tips & Solutions

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?

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".