So each data point across the row of Main links to a subsequent row on the Actions spreadsheet.
Any help would be most gratefully appreciated and save me many long hours of data entry!
Opening Workbook via VBA Code If you are using Excel VBA to open the Workbook the problem can be addressed in the Workbook Open Method. Open File Nmae:= _ "C:\My Documents\Linked Book.xls", Update Links:=xl Update Links Always End Sub Sub Open Dont Update() Workbooks.
Open File Nmae:= _ "C:\My Documents\Linked Book.xls", Update Links:=xl Update Links Never End Sub Sub Open Update Links Per Settings() Workbooks.
Note You will still be notified if there are any broken links Warning This option affects all users of the workbook.