Skip to Content

Locked Context within Quick Links

Hi experts,

facing the following problem with a member quick link:

i have a sales account with a quick link, which jumps to a separate input sheet for entering additional details only necessary for this account.

The problem is everytime i use the quick link the linked input sheet opens but the context is locked for all dimensions excluding TIME. Now i want to change the context to my desired settings but of course i can't. Is there a way to prevent the context from locking after jump? I faced the problem with some EPM functions but when i use the formatting sheet and lock the sheet my self made drop down lists are also locked so... i need the context, so that i can use EPMContextMember for example...

As I found out: Members within Column axis get not locked when using the quick link. Is there any special etting for this issue?

Thx for help



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 15, 2015 at 09:32 AM

    Just found out what went wrong:

    Context was locked on workbook Level under Options -> Context Options. But it was not locked on worksheet level. So as it seems workbook settings override worksheet settings here.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 15, 2015 at 06:44 AM


    I think this is the way it will work as per the design. You can not change context in the target, it will be inherited from the source.

    Your target workbook context will freezes based on source.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.