0

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.

Improve this question

1 Answer 1

Reset to default
0

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."

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for your help, but unfortunately, none of the provided solutions is suitable for my situation. Modifying settings, such as removing security protections from my file, only affects my access and doesn't resolve the issue when the file is shared. Additionally, adding new trusted paths to the base is ineffective since my file is shared through our SSRS, resulting in other users encountering pop-up prompts.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.