BPC (ver 7.5 ) MS Excels option missing Add-Ins error “Object variable or With block variable not set “

 
Above error  "Object variable or With block variable not set"

Solution:

1. Open MS Excel sheet and check for Planning and Consolidation tab on the top ribbon. It would not be available.
2. Open excel sheet optionsclick on Add-ins select disabled Add-ins click Go.
3. Select Planning and Consolidation add-in and enable it.
4. Check if the planning and consolidation is active in the active Add-in list.

5. Close excel sheet and open it again. Now we can see the planning and consolidation tab in top ribbon.