on 10-26-2020 8:05 PM
Hi experts, we are using EPM addin 10.0 SP36 Patch1.
And we have a very strange behaviour for Sheet Options. (by definitions sheet options should be saved with workbook and remains the same for every single user.)
But, for some users, when they open the same workbook and sheet as I do, the sheet options are gone - changed.
Thank you for any ideas.
Tomas.
examples: (this is what I try to preserve within the workbook)
by SAP:
Hi tvarga,
Check the user access to EPMXLClientPreference.xml in the presentation layer ( local computer / citrix) - make sure it has Write and Read at least.
The settings for the EPM Add-in are stored in the file EPMXLClientPreference.xml
I would check the users access which the functionality work correctly and compare against the one's that are in trouble.
Upon startup, the EPM Add-in reads the user preference options and tries to determine if the file exists first. If the file does not exist, the EPM Add-in will create a new EPMXLClientPreference.xml file with default values.
The default values are built in the EPM Add-in code for situations where the EPMXLClientPreference.xml contains incorrect values. In such cases, the EPMXLClientPreference.xml will be overwritten in order to avoid launching the add-in with invalid values.
You can also edit the file manually and apply the changes. It would be another way of testing it.
Furthermore, the document link below is a great asset to help with EPM Add-in Issues
How to Debug the EPM Add-in Manual -http://docshare02.docshare.tips/files/15528/155280283.pdf
Should this help to address your topic, please kindly accept the answer.
Cheers.
Luis 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but:
"The screenshot was wrong. The answer though is about sheet options, not user options."
From the mentioned document:
"The EPMXLClientPreference.XML file stores user preferences, current view of all connections, last selected members, and the default sheet options."
Default!!! Default settings for creating new reports!
And in the question we can see the issue with already build reports. And the mentioned settings are stored in the workbook with report.. Do you understand the difference?
svea.becker
"exclamation marks and bold format might be understood as an aggressive tone by others" Let's disable "Bold" button and restrict "!" usage. 🙂
Please look on the history of this discussion and you will understand my points. I have clearly explained that the answer is not related to the issue in the question, but the answer author insisted on the opposite.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.