excel spreadsheets with links to other spreadsheets

[holdend]

Hi guys

Im using excel 97 at work. I have built a spreadsheet that has links to other spreadsheets.

Is there any way i can refresh the link every so often, without having to close and reopen my sheet. Automatically would be even better !

 

[deviation]

You will need to know the path and file name.. Best bet is to use the record macro and go thru the links menu to update the files while recording then just make the macro from that.

Here is a sample of what you should see

Sub Updatelinks()
ActiveWorkbook.UpdateLink Name:= _
        "File Path\excelfile..xls", _ 'change to your file
        Type:=xlExcelLinks
End Sub

 

[holdend]

where is the links menu when done manually?

 

[Kinsdono]

The links menu is at the top of your excel under the Edit label. Just click edit and then links, this will show all things links within the workbook and the location of those links. There is also an option to open the source of the links as well. Hope that helps.

 

[holdend]

how many links can excel update in one click of "update now" ?

 

[Kinsdono]

I would guess that it should update all the links, or you can pick a link and then click update. How many links do you have in your current workbook?