Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling color from cell of workbook to another linked workbook | Excel Discussion (Misc queries) | |||
Invisible Workbook | Excel Discussion (Misc queries) | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Linked workbook(s) | Excel Discussion (Misc queries) | |||
Set Workbook to invisible? | Excel Programming |