SAP Knowledge Base Article - Preview

2219713 - BPC EPM add-in: EPM Excel Client Issues after Microsoft update KB3085502

Symptom

After applying the Microsoft Excel 2013 security update MS15-099: Description of the security update for Excel 2013: September 8, 2015 ( KB3085502 /  3085502),
various issues have been reported, this includes and is not limited to:

1. EPM Add-In reports that have "Freeze Panes" enabled, will have their views distorted after refreshing the report.

Before clicking the EPM Add-in Refresh button:

beforerefresh.png

After clicking the EPM Add-in Refresh button:

afterrefresh.png

2. When users enter the data in a cell and hit enter, the data in the cell disappears

3. Excel does not recognize the active workbook after installing the Microsoft update.

4. When users have multiple Excel worksheets open and enter data into one worksheet when pressing enter this data ends up going to the wrong worksheet due to Excel losing focus.

5. Excel crashes after clicking a button which uses the following VBA command:

Public EPM As New FPMXLClient.EPMAddInAutomation
Sub FermeMenu()
EPM.Logoff
ThisWorkbook.Close False
End Sub


Read more...

Environment

  • SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 10.0, version for Microsoft
  • SAP Business Planning and Consolidation 10.1, version for Microsoft

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

Windows updates released 9-8 causes display issues in Office 2013, pane, Freeze Pane option, refresh, KB3085502 Excel 2013 EPM Add-In reports  Microsoft Excel (2013) patch Office 2013, script, macro VBA Sub FermeMenu()
EPM.Logoff
ThisWorkbook.Close False
End Sub  Microsoft update KB3085502 , KBA , distorts , corrupts , excel doesn't recognize active workbook , corrupted , distort , corrupt , troubleshooting , 3rd party tools config and system admin , report , microsoft update , broken format , broken formatting , cell value disappears , active workbook , edit cell , EPM-BPC-MS , Microsoft Version , EPM-BPC-NW , NetWeaver Version , EPM-XLS , EPM Excel Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.