Macros open server file hyperlinks in 2nd instance, preventing macros from seeing and interacting with the newly opened file. Manual clicking of hyperlink opens the files in the same instance as expected. Users with fresh login have no trouble with the macros opening the files in the same instance.

Esoteric macro and/or Microsoft 365 Active Directory problem.

Macros using hyperlink in a cell to .follow them to open. Then the next line is a sheet selection of a sheet in the new workbook. Error thrown because the new workbook is not visible to the macro and does not see the sheet name.

This works for everyone everywhere. Including on fresh logins.

Recently User1 started having the 2nd instance problem.

I thought it was isolated and fixed it by removing and recreating his profile. Worked fine for a week.

Then it came back. Then User2 logged in on the same machine had the issue.

Then the next day User3 on a separate machine had the issue.

All 3 users have no issues if they just use a clean login on a different machine.