cancel
Showing results for 
Search instead for 
Did you mean: 

BPC Toolbar is missing in Excel

Former Member
0 Kudos

Hi Gurus,

Accidentally I removed my 'Planning and Consolidation' Add-ins from excel.

Can anyone please tell me how to get it back?

Regards

Ray!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ray,

You should open Excel menu and select Excel Options.

Click on Add-Ins and on the "Manage" drop-down menu select "COM+ Add-Ins", click "Go".

Make sure the Planning and Consolidation is checked and click OK.

You might have to re-open excel for the changes to take place.

Regards,

Marcelo

Former Member
0 Kudos

Hi Marcelo,

Actually I deleted from there only while trying to enable Live Office Toolbar.

Is there anyother directory I can get that file add and enable it?

Regards

Former Member
0 Kudos

Hi Ray,

I believe that reinstalling BPC Client would fix that for you.

I am checking my own client but still haven't found a way to add it back manually.

Regards,

Marcelo

Former Member
0 Kudos

Thanks!

Will try that.

Former Member
0 Kudos

Re-Installing did not work.

Former Member
0 Kudos

Hi Ray,

On my system I ran the install file again and selected the Repair option.

The Ribbon Tab for Planning and Consolidation was restored without further issues.

Have you checked if after the re-install the COM+ Add-In is enabled or it wasn't added back to Excel?

Regards,

Marcelo

Former Member
0 Kudos

I uninstalled and re-installed.

That worked.

Thank you!

Former Member
0 Kudos

I am glad that it worked!

I got intrigued by the fact that I can't add it back in manually.

I'll keep looking into it and I'll update this topic if I find something new.

Just to keep track of it, so far we have found two solutions:

1) Repair BPC Client

2) Uninstall and Reinstall BPC Client

Regards,

Marcelo

Former Member
0 Kudos

Hi Marcelo,

I found something else too.

The addin file which gives that toolbar is 'mscoree.dll'

This file lies in following directory:-

c:\WINDOWS\system32.

I am trying if we can add it and get that ribbon back.

Will update the thread with my results.

Former Member
0 Kudos

Hi Ray,

I found a way to restore the Planning & Consolidation tab without reinstalling BPC Client.

We just need to edit the registry to re-enter the key for BPC Add-in.

When we remove it from Excel its reg. entry is deleted.

I have exported the entry from my system to a *.reg file:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\AddIns\OSoftAddIn50.Connect]
"LoadBehavior"=dword:00000003
"FriendlyName"="Planning and Consolidation"
"Description"="OSoft Logon AddIn"

The path is: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\AddIns\OSoftAddIn50.Connect

I still think that repairing the installation is way safer and simpler

Regards,

Marcelo

Answers (0)