I need the output from spreadsheet C, but C requires input values returned by running spreadsheets A & B in order. I use VBA code (Workbooks.Open) to open A & B, but they both contains links to other data sources. As soon as the workbooks are opened, there will be a pop-up window asking the user to choose between "Update data" and "Don't update", and the operation of my VBA code breaks down here. Is there any VBA code available to make Excel select the "Don't update" option automatically?

(Since A & B contain some cell of same functions, I can't put them in one spreadsheet. I tried to rename functions in one of the spreadsheets, but then it failed to work)