Excel Links

  musicmike 10:49 10 May 04
Locked

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.

Has anybody any ideas on this?

Thanks

  VoG II 11:00 10 May 04
  musicmike 11:48 10 May 04

Thanks VoG but that didnt work however i did find this which did the trick for anyone else who might have a similar problem

click here

  scooby43 11:51 10 May 04

I just tried your link page cannot be displayed

  scooby43 11:52 10 May 04

regarding musicmike link

  musicmike 13:44 10 May 04

I dont know if I'm allowed to post links to other forums but this is where i got the file FindLink.zip

click here

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac