Hi all,

I have a spreadsheet which contains links to other workbooks. Obviously when I open it it asks me if I wish to update these links. However, the spreadsheet is part of a report which I want to run automatically every night so I would like a way to write into the VBA code that when the workbook opens to automatically update these links and not ask me. Does anybody know of a way to do this?