I'm currently working on an Excel file that includes external links to my CUBE. Within my cube, there's a Row-Level Security (RLS) function implemented to ensure that a manager can only view data related to their squad.
What I'm aiming for is to have my Excel file update automatically upon opening. I have configured this in my file, but when shared with others, the "Enable Content" security pop-up prevents the file from updating automatically and applying the data filtering for each manager.
Is there a workaround for this issue? For instance, is there a way to delay displaying data until the file is updated, or are there any alternative solutions that don't involve using VBA? Any guidance on resolving this matter would be greatly appreciated.
This post describes the same issue regarding the enable content prompt halting an update. The comment below is the answer given that provided links on how to setup the trust center.
"Connections to external data may be currently disabled on your computer. To refresh the data when you open a workbook, you must enable the data connections by using the Trust Center bar, or you must place the workbook in a trusted location. For more information, see Add, remove, or modify a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center."