I have an Excel workbook which was linked to another external workbook. The linked workbook was accidentally deleted (not by me) and was recreated with a slightly different path and file name. Having changed the code for the link and got it working again I now get messages when opening as follows
Microsoft Excel cannot find 'Tick1' on 'JLSS May 04.xls' etc.
I have searched all sheets for the word Tick both in text and formulas also the VBA code but can find nothing.