Skip to Content
Author's profile photo Former Member

Manual Entry of Members in the Context Bar of the EPM Add-In for MS Excel

While the latest version of the EPM Add-In for MS Excel user guide (,d.cGU was just updated, yesterday, it does not include at least one great feature that was rolled out for SP17.

You can now type directly into the member selector for each dimension in the Context Bar!  This is so much easier than having to use the GUI to select the member.  In order to make this work, you need to be sure to go to the User Options of the EPM ribbon, and select the Others tab, as shown below:


Be sure to check “Enable Manual Entry of Members.”

Now, you will be able to click in the member selector box for a particular dimension and enter the ID (not the description) directly into the member selector field, and press Enter.

This is a significant improvement, in my opinion!  Hope you find this useful for you and your users, as well.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.