I want my workbook to update links upon opening, but not prompt me as
I open the workbook. I have used the following code.

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub

And I still get the prompt. Any ideas why?

Thanks in advance.