Invisible linked workbook?
 

Hi All

On Excel97, Windows NT, I have a spreadsheet that links to 11 others
on a network to build reports.

On that sheet, I've put an image so that users can click to update all
links in one go using the following code:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

The code worked fine all last year but I'm now getting a run time
error of 1004 with the message "Method 'UpdateLink' of object
'_Workbook' failed"

Knowing that I've created new sheets for 2004 for all the "linked to"
sheets (and changed the layout/code etc for some of them) I assumed
I'd made a mistake somewhere and attempted to track it down.

So far, I've found one sheet to be the culprit but now I'm really
confused:

When prompted to update the links on opening the reporting sheet, all
the links are correctly refreshed.

However, when I've recorded a macro updating the suspect sheet
(EditLinks[select the sheet]Update NowOK) I get this code:

Sub Macro1()
'
' Macro4 Macro
' Macro recorded 19/01/04 by scooper
'

'
End Sub

It's empty! It seems that Excel is happy to update the link on
opening but LinkSources can't see it.

Has anybody else encountered this problem and do you know of a
resolution?

Thanks for your patience.

Steve