Object variable or with block variable not set (BPC Excel)

[chemicala_srimallikarjuna]

When opening the BPC Excel the following error is display, follow this guidelines to fix the issue:

1. Go to the EXCEL options:

2. A pop-up window will appear, please click on Add-ins

3. In the drop down list in manage, select Disable Add-ins and click on GO:

4.Another pop-up window will appear with the disable items, it the white box it will say “planning and consolidation”, please click on top of it and then select ENABLE

5. Close your excel and log on to BPC again