I had an Excel question today that I just can't answer.
The client is running 32Bit Excel 2010 under 64Bit Win10 Pro.
They often open two instances of Excel, the first to be opened (call it 'A') being their 'working instance' and the second (call it 'B') in which they open a set of large workbooks, into which data is downloaded and analysed / reports generated etc - this one is slow to update, and is also slowed by VBA that finds subsidiary data files in file shares, copies them to a central location, then opens, and pulls data from many external sources.
For the avoidance of doubt, I am not looking for suggestions on how to speed up the workbooks running in instance 'B'. There are also good reasons why they don't want to move that process off to a different machine at this time - that's a whole separate project!
The reason for opening two instances is that it keeps the slow calculation / progress of the second instance from affecting calculation / updates in the first. Also, if they open a file (from Windows File Explorer), it will open in the first instance opened ('A') which is what they want.
Sometimes, they forget, and close the first instance, leaving only the second ('B') open.
They can open a new instance again, but now it is not the 'first instance' opened - that is now 'B', which means that files opened from Windows File Explorer are now opened in 'B'. They can use File - Open to open a file, but that is the slowest method known to humankind, especially for someone that lives on their file share, and is also much more likely to slow them down by having to use the mouse - they also live in Excel, so they hate using the mouse :-).
They can solve this by closing all Excel instances, and starting from scratch, but that is unwelcome due to the calculations running in 'B'.
Is there any way of making Excel (or, presumably more likely, Windows) regard 'A' as being the instance in which to open a new file from Windows Fkile Explorer, even if instance 'A' was opened after instance 'B'?