excel spreadsheets with links to other spreadsheets

holdend

New Member
Joined
Dec 5, 2005
Messages
29
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 !
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

deviation

Board Regular
Joined
Dec 17, 2004
Messages
171
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

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

Kinsdono

Board Regular
Joined
Sep 30, 2004
Messages
100
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.
 

Kinsdono

Board Regular
Joined
Sep 30, 2004
Messages
100
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top