Start a new topic

EPM Add-in / EPM Plug-in freezes / crashes with Microsoft Office 2013 / 2016

Symptom

When opening a report or input schedule after multiple reports and input schedules have been opened and closed or when you click the "View Formats" button one or more of the following behaviors can occur.

2-1-2017 11-18-40 AM.jpg

Error message "Microsoft Excel is trying to recover your information..." is generated.
Excel is running into problems with the 'epm add-in for microsoft office' add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?
Microsoft Excel stops responding without error
Microsoft Excel has stopped working

2-1-2017 11-22-27 AM.jpg

2-1-2017 11-25-52 AM.jpg


Environment

Microsoft Office 2016
Microsoft Office 2013
EPM Add-in
Analysis for Office - EPM Plug-in

Reproducing the Issue

Go to the EPM tab in Excel and log on to a BPC Connection.
Go to Open > Open Server Input Form Folder (this has only been tested with input forms at this time however it is assumed the issue can happen with Reports as well).
Open 5 or Input Schedules.
Close the 5 input schedules but do not close the Excel Book the 5 were opened from.
Open another Input schedule.
- At this point with the customers input schedules that were used to recreate the issue Excel stopped responding and the error Microsoft Excel is trying to recover your information appeared. The number of input schedules or reports that this may occur on different systems may vary.

Or

click the View Formats button

Cause

This appears to be an issue with Microsoft Excel 2013 and 2016 related to performance or stability.

Resolution

Apply the following Microsoft updates which includes specific issue updates as well as the stability and performance updates

Excel 2016 https://support.microsoft.com/en-us/help/3141472/january-3,-2017,-update-for-excel-2016-kb3141472
Excel 2013 https://support.microsoft.com/en-us/help/3141475/january-10,-2017,-update-for-excel-2013-kb3141475

 
Login or Signup to post a comment