Sounds like you placed all o fth ecode into the Class Module for the Sheet. Be sure you delete this code before proceeding.
It breaks down like this:
Each workbook has several class modules, one for each sheet, and one for the entire workbook. These class modules all you to add code that will be run when certain events happen. these events may be isolated only to a certain sheet, or may be captured from anywhere in the book. There ar eno standard modules in a workbook, unless you add one or more manually.
The code that I recommended comes in 2 parts. That first part needs to go in a standard module. When you right-click on th esheet tab and select View code, there should be a pane to the side of the window calle dthe Project Explorer. It has a tree-view of all open books (plus any addins that you have installed). If you see nothing that looks like this, hit Ctrl+R. In the project explorer, expand the selction for the appropriate workbook, then expand the selection for Microsoft Excel Objects for that workbook, and double click ThisWorkbook. Insert this code into the code pane at the right:
Code:
Private Sub Workbook_Open()
call link_update
End Sub
What this does is to run the Link_Update routine when the workbook is opened...
Now from the Top menu, select Insert->Module... a new blank standard module pane will appear toward the right of the VBA window. Insert the Link_Update routine as posted above... change the time interval as needed (I posted it with a 1 minute interval). Now press F5. to start the code running... it should update the links on the time interval you specifyed, until you save and close the workbook...
Hope this helps... let me know ho wyou make out.