'Link!' in Formula

[rjbinney]

So I inherited a spreadsheet from a client, and one (of many) formulas begins:

=IF(Link!$CW37=0

I presume that is telling me that the cell references a separate file, for which the link has been broken.

But if you Google "Link!" with the exclamation mark, you get all the same hits as without. So someone please confirm my presumption is correct. (Or correct me).

Thanks

 

[Aladin Akyurek]

That looks ill-formed, that is, incomplete.

Link should be the name of a sheet in the workbook. Link!$CW37 thus
refers to cell CW37 in sheet Link.

 

[rjbinney]

Problem is, I can't find it!

I've unhidden everything and still nothing.

 

[Dryver14]

link is the name of a worksheet in this instance probably a sheet whoever passed this on to you had, it seems you dont have the complete workbook