3646310 - SAP IBP: "The SAP IBP, add-in for Microsoft Excel reached the memory limit of the local computer" Error When Logging In

The following error message is displayed when logging into IBP with other Excel workbooks open.

The SAP IBP, add-in for Microsoft Excel reached the memory limit of the local computer
Either the Microsoft Excel (32-Bit) or the local hardware memory limit has been reached.
The amount of usable memory for Microsoft Excel (32-Bit) can be increased with "Large Address Aware capability":
https://support.microsoft.com/en-us/kb/3160741
(The 64-Bit version of Microsoft Excel doesn't have a memory limit.)

You can decrease the amount of memory used if you close some of the open workbooks.
Logging off and logging back on can also help to decrease the amount of memory used.

For attributes that have a lot of attribute values, you can try to change the global configuration parameter "MAX_DIM_MEMBERS" to decrease the amount of memory used. This means that less data is loaded into the memory during log on.
With every workbook opened, memory is consumed but with the global configuration parameter “PV_COUNT_MAX" you can limit the number of open workbooks containing planning views.

• SAP Integrated Business Planning
• SAP IBP, add-in for Microsoft Excel

sap ibp, excel add-in, memory limit, out of memory, oom error, large address aware, blank custom properties, workbook issue, sap ibp excel error, max_dim_members, pv_count_max, excel memory usage, ibp planning views. , KBA , SCM-IBP-XLS-UI , SAP IBP, add-in for Microsoft Excel (User Interface) , SCM-IBP-XLS , Excel Client , Known Error