Where is the link? (non-rectangular reference)

M

Michael R

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.
 
G

Gord Dibben

Check under Insert>Names>Define.

Maybe a reference there?


Gord Dibben MS Excel MVP
 
D

Dave Peterson

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Michael said:
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.
Click to expand...
 
M

Michael R

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 said:
Check under Insert>Names>Define.

Maybe a reference there?


Gord Dibben MS Excel MVP

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.
Click to expand...
Click to expand...
 
M

Michael R

Thanks Dave!

The tool did not find any links of the alleged name. However the method
sugested by Gord (above) worked.

Dave Peterson said:
I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Michael said:
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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Link To File That No Longer Exists 1
Invisible Link 4
Need to change cell reference of an already linked Excel data set 0
How to create absolute link to cell in another workbook (Excel 2003) 1
Link Error 2
non-rectangular name - definition? 2
Error: Undefined or non-rectangular name 0

Top