"Open in Smart View"
Issue Description:
When selecting "Open in Smart View," the data automatically opens in the most recently used Excel file.
While this is generally problematic, it becomes a significant security risk when two users with different access levels are working in the same file. In these cases, security restrictions are not enforced, and a user who should not have access to certain data is able to view it.
Ideally, Smart View should always open in a new Excel file by default, instead of appearing in an already open file.
Could you please assist with resolving this issue or suggest a possible workaround?