SAP Knowledge Base Article - Preview

1773794 - To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet.

Symptom

When trying to maintain the Dimension members the following front-end dump is displayed:

 Dump error.png

To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet.
Select another location in which to insert new cells, or delete data from the end of your worksheet.

If you do not have data in cells that can be shifted off of the worksheet, you can reset which cells Excel considers nonblank.
To do this, press CTRL+End to locate the last nonblank cell on the worksheet.
Delete this cell and all cells between it and the last row and column of your data then save.


Read more...

Environment

  • SAP BusinessObjects Planning and Consolidation 7.0, version for SAP NETWEAVER
  • SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NETWEAVER
  • Product

    SAP Business Planning and Consolidation 7.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver

    Keywords

    System.Runtime.InteropServices.COMException, Microsoft Excel, dimesnion members, Dump Error , KBA , EPM-BPC-NW-ADM , Admin , 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.