Automatic links message when opening a workbook
 

How in the world do I find the formula that is linked to another workbook?
And yes, I have turn on the "formulas" in the Options menu and look on ever
tab but can not find it. Could it be a maco or VB code?

Automatic links message when opening a workbook
 

It could be a named range in InsertNamesDefine that is linked to another
workbook.

Take a look at this link and download Bill Manville's FindLinks addin...

http://www.oaltd.co.uk/MVP/


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 13:53:16 -0800, pgarcia
wrote:

How in the world do I find the formula that is linked to another workbook?
And yes, I have turn on the "formulas" in the Options menu and look on ever
tab but can not find it. Could it be a maco or VB code?

Automatic links message when opening a workbook
 

Edit-Links. If the "Links" item is disabled, then there's none.

You can also try Edit-Find. Look for "[" (no double quotes). Select within
workbook, and look in Formulas.


"pgarcia" wrote:

How in the world do I find the formula that is linked to another workbook?
And yes, I have turn on the "formulas" in the Options menu and look on ever
tab but can not find it. Could it be a maco or VB code?