Updating Links Automatically

[OfficeUser]

Is it possible to eliminate the message from appearing but also NOT allow the links to update? This is really causing issues with my worksheets and cells being updated that should not be. Thanks.

 

[OfficeUser]

I have figured out that if I write some code that pastes the values of the cells containing the linked formulas, that it does the job. I still don't suppose there is a way to always answer this message box as "Don't Update". I believe it fires before the workbook open event thus you can't code it in?