Macro asking to manually update values

Hi there,

I have a Microsoft workbook data spreadsheet (also macro enabled) that I'm referencing with a macro enabled workbook. When running the two spread sheets on the same PC, the macro enabled workbook is updating automatically with no issues. When running the workbook on a separate computer, upon saving the workbook the macro enabled workbook is asking to update the values and forces me to select the data spreadsheet, much like opening an existing file. I want the macro enabled work book to not ask to reopen the file when the data spreadsheet saves much like it would if the same PC had both spreadsheets open. Is this possible? The macro enabled workbooks macro is simple:

Sub Macro3()
'
' Macro3 Macro
'
' Keyboard Shortcut: Ctrl+u
'
    Range("A1").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R234C3"
    Range("A2").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R234C4"
    Range("A3").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R236C3"
    Range("A4").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R236C4"
    Range("A5").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R237C3"
    Range("B1").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R238C3"
    Range("B2").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R238C4"
    Range("B3").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R235C3"
    Range("B4").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R235C4"
    Range("B5").Select
    ActiveCell.FormulaR1C1 = _
        "='S:\Continuous Improvement\[OEE Calculator v3.xlsm]Template'!R237C4"
'
' execute macros
    Macro3
' submit macro to run again in 1 sec
    Application.OnTime Now + TimeValue("00:00:01"), "CRTL U"
'
End Sub

Thank you in advance,

Kyle

Moderation removed. code tags are added.