Non-existing data link

[Mel Smith]

When I open a spreadsheet, to which I have got one link to another workbook, I get an error message which tells me that 'another' link cannot be found/opened etc. I have looked in Data/Edit Links and the only link listed is the one that I have put in. No other link is shown. How can I found where this non-existent link is and sever whatever connection there may be?


Thanks for your help.

Mel

 

[Ron Coderre]

Check Data Validation cells and Named Ranges.

Does that help?

 

[Mel Smith]

There are no Named Ranges. I'm not sure what you mean by Data Validation Cells. I couldn't see what you meant...

Mel

 

[Ron Coderre]

Occaisionally, I inherit workbooks where Data Validation (dropdown lists in cells) was used AND the list of valid items contains ranges on other workbooks.

I have some VBA code that lists the settings for every DV cell in a worksheet. But, if you only have a few it's worth scrutinizing them.

 

[Mel Smith]

Many thanks, Ron. Strangely there are no drop down lists or DV either. Very odd...

Mel

 

[sandy666]

Conditional Formatting?

 

[Mel Smith]

There is some CF which I will re-check but it only refers to ranges within each sheet i.e. if "home" colour the cell green and if "away" colour it blue. They don't refer to other sheets.

Mel

 

[sandy666]

No DV
No Names
No CF
so maybe check formulas (Formulas - Show Formulas)
or
Inquire tool (Developer - COM add-ins - Inquire) [See links between workbooks]

 

[Mel Smith]

Many thanks, Sandy. Some (more) investigative work this evening.

Mel

 

[sandy666]

You are welcome
btw. Inquire - Excel 2013 Pro Plus and higher