Skip to Content

EPMMemberProperty refresh on load


I have an EPM 10.1 input schedule in which several of the EPM reports reference a cell with the following formula:


While testing we noticed this cell was not refreshing on load of the excel file. Specifically we modified this property, in the dimension, performed a full process, but noticed on load of the workbook the prior property value was retained.

Our solutions was EPM > Options > Sheet Options > Refresh (tab) > "Refresh Data in the Whole File when Opening it" (checkbox)

Is there a better way to do this?

Is there a way to set this to a system default?

(Having discovered this we're going to need to update all of our worksheets).

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 19, 2016 at 06:09 PM

    Hey Jon,

    In the EPMXLClientPreference.XML file ( under C:\Users\<USERNAME>\AppData\Local\EPMOfficeClient ) , change the value of this setting to true for all the users you want this setting to affect:




    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 07:33 PM

    Is there a template or some location where I can configure this to be the default for new EPMXLClientPreference.XML files?

    We're nearing the end of our 10.1 upgrade project and client installs have not yet been completed (we're actually publishing via Citrix).

    It would be great to change this once vs each time a new end-user generates an EPMXLClientPreference.XML file (we have hundreds of end-users)

    Add comment
    10|10000 characters needed characters exceeded

    • Please talk to your network administrators to create a script that will set this option (patching EPMXLClientPreference.XML file) each time user will login to windows server... I don't think there is a better option!

  • avatar image
    Former Member
    Oct 20, 2016 at 06:58 AM

    Hi Jon,

    How much is the data in the template? have you done any analysis testing on the same? Is this persistent with only one workbook or all workbooks?

    We had faced a similar kind of issues....but the template was heavy(large data volumes). We had used the options "Clear metadata Cache" and "Refresh Metadata for current connection" from More option in EPM! You can also schedule the clear metadata cache as per your requirement after 10 days 15 days etc... from the User options! It would be user specific then....You would have to ask the users to do the settings in their EPM.



    Add comment
    10|10000 characters needed characters exceeded