Recent post by @rubenerd on Excel limits opening multiple workbooks with the same name. Main reason is the underlying VBA object model where an open workbook is identified strictly by its file name (without the full path). https://www.rubenerd.au/excel-cant-open-two-workbooks-with-the-same-name/