Open two Excel files at once

[henryg]

I have an Excel file that is linked to another, and when I open it I get the usual do I want to update dialogue. All good so far. But then it says that it cannot update some links so I get #ref! all over the place. If I then open the linked file manually, the links refresh correctly; this may be due to Power Query/Pivot but I'm only guessing.

So to the point! How can I open both files at the same time without having to do so manually? I feel sure that in the past I could do this, but if so I have forgotten. Come to think of it, I could try a batch file but any better way/s?

Excel 365 beta (with the 14 latest functions), Windows 10x64

 

[Anthony47]

You might use a Sub Workbook_Open macro that checks if the second workbook is already open and, in Not, open it.
If you need help for doing that, just ask.

 

[henryg]

You might use a Sub Workbook_Open macro that checks if the second workbook is already open and, in Not, open it.
If you need help for doing that, just ask.

Thank you, but a very simple batch file does the trick and I am not familiar with VBA. Don't know why I didn't think of it before posting here.

And I think it was the unlamented "briefcase" I had in mind for doing this years ago.