Break Ambigous Links in Excel 2007

Spaniel

New Member
Joined
May 11, 2009
Messages
15
Hi folks,

I have an excel spreadsheet (xlsm), with some minor code in it. Now when I open it I get the common error of 'Enable Links?', at which point I can choose to enable or not. The problem is that this link shouldn't be here at all, and when I try to remove it using Data > Edit Links > Break functions it doesn't seem to do anything.

How How How?

Cheers in advance,

Sam
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

SusaninHouston

Active Member
Joined
Jan 13, 2005
Messages
261
To break the link, the worksheet that contains it needs to be unlocked. Is that it?

Or, sometimes links can be hidden in graphs or other objects, or in named ranges. Have you looked there?
 

Spaniel

New Member
Joined
May 11, 2009
Messages
15
Ahhhhh, feel really stupid now.

It was a named range that someone had obviously copied into the sheet and then kept the source range. I deleted these broken 'ranges' and it was fixed.

Many thanks.

Sam
 

Watch MrExcel Video

Forum statistics

Threads
1,099,739
Messages
5,470,458
Members
406,700
Latest member
Mark Rob

This Week's Hot Topics

Top