Skip to Content

Disable the EPM logon box when opening a report from Excel

Jun 22, 2017 at 09:41 AM


avatar image


We have recently upgraded to EPM 2.4 and have an issue where users can save an EPM report in an excel file locally and when they open it in Excel it prompts them to login as the reports are saved to refresh on open. We do want the refresh on open to be active when the user accesses the reports through EPM but not when they have saved it locally. Is there a way to stop the automatic logon showing when a user opens a report they have saved locally in Excel?

Thanks in advance,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Jun 22, 2017 at 02:12 PM

Not possible. Only some VBA that will use flags in workbook_open and epm event function for the same. If local copy is opened workbook_open event will trigger. If you open file from server folder - workbook_open will not trigger. Epm function will trigger in both cases.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Vadim, I was assuming this would be the case