Connected sheets not updating

Hello, Richard.

I have corrected that line to what you had said and I am not getting any errors! Thank you. The only problem I have now is that the log won't update until I save the workbook. So it does seem to be reading and updating the information from the Accom. Log, it just isn't showing up until the save button is clicked. Would an automatic save macro fix this, do you think? If so, how can I include this into the lines of code I already have.

I've decreased the amount of time for the autosave function to see if that would help, but it doesn't. It still will only update when I have manually clicked the save button.

Accom - Collective Data 1.xlsm

Sub UpdateFromLog()
    Application.DisplayAlerts = False
    If Range("H2") = "Y" Then End
    Workbooks.Open Filename:="T:\O\Op Info\NICCI HARROW\ACCOM SUPPORT\NEW ACCOM LOG 2014.xlsx", Notify:=False
    ActiveWindow.Close
    Call OnTimeMacro
    Range("H2") = "N"
End Sub


Sub OnTimeMacro()
    Application.OnTime Now + TimeValue("00:" & CStr(Range("H1")) & ":00"), "UpdateFromLog"
End Sub


Sub StopUpdate()
    Range("H2") = "Y"
End Sub

Kristian

Hi,

Are you sure your system is set to Automatic Recalculation? Check under the Calculation Options on the ribbon.
If that's OK then go to the Excel Options Advanced (from the Office Button), scan down to the 'When calculating this workbook' option and make sure it's ticked. See attached picture

Failing that then I don't understand why the links wouldn't update so the pragmatic approach would be to just add an

ActiveWorkbook.Save

instruction after the

ActiveWindow.Close

instruction.

But I'm sure you'll find one of the first two will fix it