Finding linked cells

ree001 · Apr 9th, 2002, 03:51 AM

When opening a exel file following message is displayed: The workbook you opened contains automatic links to information in another workbook.
Is there a easy way to find the linked cell.

Tom Urtis · Apr 9th, 2002, 04:02 AM

Try these links for starter advice:

http://j-walk.com/ss/excel/usertips/tip054.htm

http://support.microsoft.com/default...;EN-US;q188449

Also, you can try clicking on Edit > Links for the name & file path of the source workbook. Sometimes a named range refers to another workbook representing the link source, so check your named ranges too.

HTH & Good luck.

ree001 · Apr 10th, 2002, 12:38 AM

Thanks Tom that was exactly what i needed.

Apr 9th, 2002, 04:02 AM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	Try these links for starter advice: http://j-walk.com/ss/excel/usertips/tip054.htm http://support.microsoft.com/default...;EN-US;q188449 Also, you can try clicking on Edit > Links for the name & file path of the source workbook. Sometimes a named range refers to another workbook representing the link source, so check your named ranges too. HTH & Good luck. __________________ Tom Urtis Microsoft MVP - Excel

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

Apr 9th, 2002, 03:51 AM	#1
ree001 New Member Join Date: Apr 2002 Location: Netherlands Posts: 6	When opening a exel file following message is displayed: The workbook you opened contains automatic links to information in another workbook. Is there a easy way to find the linked cell.

Apr 10th, 2002, 12:38 AM	#3
ree001 New Member Join Date: Apr 2002 Location: Netherlands Posts: 6	Thanks Tom that was exactly what i needed.