Automatic updating of workbook links

Originally Posted by ianh

Create an Auto_Open Macro

    
Sub Auto_Open
ActiveWorkbook.RefreshAll
End Sub

depending on what/how your links are you may need a slightly different code. This works for me reading XML into my workbook.

I understand the idea of this and your later amendment to the code, but I have some questions:

1. Where can I put this code so that it will run every time I open any workbook? I do not want to have to include it in each and every workbook, but I cannot identify an Application VBA project with a suitable module.
2. Will it definitely prevent the update prompt?