| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is the link? (non-rectangular reference)
Working on excel2002 SP3
I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This workbook contains one or more links that cannot be updated" with an option "Edit links" The next window shows me 2 links, the one that I know and another one (to Mds97.xla) that I do not know. This one shows a status of "Error: Undefined or non-rectangular reference" How can I find where this reference is located so I can remove it? Edit / Find (all) "[" does not show the mystery link. There are no hidden sheets. There are no macros. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the link? (non-rectangular reference)
Check under InsertNamesDefine.
Maybe a reference there? Gord Dibben MS Excel MVP On Thu, 22 May 2008 09:22:01 -0700, Michael R wrote: Working on excel2002 SP3 I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This workbook contains one or more links that cannot be updated" with an option "Edit links" The next window shows me 2 links, the one that I know and another one (to Mds97.xla) that I do not know. This one shows a status of "Error: Undefined or non-rectangular reference" How can I find where this reference is located so I can remove it? Edit / Find (all) "[" does not show the mystery link. There are no hidden sheets. There are no macros. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the link? (non-rectangular reference)
That worked, Thanks!
I found a number of names referring to workbooks which are not related to the current one at all. after deleting those names the problem was gone. "Gord Dibben" wrote: Check under InsertNamesDefine. Maybe a reference there? Gord Dibben MS Excel MVP On Thu, 22 May 2008 09:22:01 -0700, Michael R wrote: Working on excel2002 SP3 I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This workbook contains one or more links that cannot be updated" with an option "Edit links" The next window shows me 2 links, the one that I know and another one (to Mds97.xla) that I do not know. This one shows a status of "Error: Undefined or non-rectangular reference" How can I find where this reference is located so I can remove it? Edit / Find (all) "[" does not show the mystery link. There are no hidden sheets. There are no macros. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the link? (non-rectangular reference)
I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Michael R wrote: Working on excel2002 SP3 I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This workbook contains one or more links that cannot be updated" with an option "Edit links" The next window shows me 2 links, the one that I know and another one (to Mds97.xla) that I do not know. This one shows a status of "Error: Undefined or non-rectangular reference" How can I find where this reference is located so I can remove it? Edit / Find (all) "[" does not show the mystery link. There are no hidden sheets. There are no macros. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is the link? (non-rectangular reference)
Thanks Dave!
The tool did not find any links of the alleged name. However the method sugested by Gord (above) worked. "Dave Peterson" wrote: I would use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Michael R wrote: Working on excel2002 SP3 I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This workbook contains one or more links that cannot be updated" with an option "Edit links" The next window shows me 2 links, the one that I know and another one (to Mds97.xla) that I do not know. This one shows a status of "Error: Undefined or non-rectangular reference" How can I find where this reference is located so I can remove it? Edit / Find (all) "[" does not show the mystery link. There are no hidden sheets. There are no macros. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Polar to rectangular coordinate conversion | Excel Discussion (Misc queries) | |||
| Add reference to DDE Link formula | Excel Worksheet Functions | |||
| how to make the rectangular cursor box in blinking mode? | Excel Discussion (Misc queries) | |||
| External reference changing the link | Excel Discussion (Misc queries) | |||
| Can I change legend keys to rectangular instead of square in exce. | Charts and Charting in Excel | |||
Hybrid Mode
