For anyone else struggling with the same problem, in another thread someone linked to a solution that solved the problem for me.

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-opens-2nd-subsequent-file-from-explorer

Happy computing...