The EPMXLClientPreference.XML file is located in the EPMOfficeClient folder.
The EPMOfficeClient folder can be found in your local directory. The easiest way to find this is to open Windows
Explorer and type in %temp%, then go up one level.
The EPMXLClientPreference.xml file stores user preferences, current view of all connections, last selected
members, and the default sheet options. The values stored in this file directory correlate to the User
Preference tab within the EPM Add-in.
To ensure multiple users have the same preferences, simply copy the EPMXLClientPreferences.XML
to each users machine and place them in the correct directory
(C:\Users\xxxxx\AppData\Local\EPMOfficeClient) where xxxxx is the user name for the machine.