| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Workbook resets calculation to automatic from manual etc | Excel Discussion (Misc queries) | |||
| Disable find files error message for missing links on opening WB | Excel Discussion (Misc queries) | |||
| Updating LINKS when opening a workbook | Excel Worksheet Functions | |||
| compile error message on a new excel workbook opening | Excel Discussion (Misc queries) | |||
| Error message opening Excel97 workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
