Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
Help!! clearing links to other workbook /Sheets
Posted by Marc on November 21, 2001 9:52 AM
I've copied several sheets from other from other excel workbook that i've created before, to complete another new workbook.
Everytime I start excel an open this new workbook, I get the message that excel has found other links to other workbooks, and if I want to restore those links or not.
I dont want to restore the links , and I dont want to get that message anymore.
I've already seen that in the submenu Edit, you can find the origin of the links. ( there you can restore or edit them), but is'nt there anyway to delete thos links. Please help.
Re: Help!! clearing links to other workbook /Sheets
Posted by Juan Pablo on November 21, 2001 9:57 AM
Copy and paste them as values.
Juan Pablo
Re: Help!! clearing links to other workbook /Sheets
Posted by Ivan F Moala on November 22, 2001 1:34 AM
Goto Edit | Links
Then change source
In the file selection select the current workbook
Ivan
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.