Accidentally I removed my 'Planning and Consolidation' Add-ins from excel.
Can anyone please tell me how to get it back?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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?
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.
Will try that.
Re-Installing did not work.
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?
I uninstalled and re-installed.
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
I found something else too.
The addin file which gives that toolbar is 'mscoree.dll'
This file lies in following directory:-
I am trying if we can add it and get that ribbon back.
Will update the thread with my results.
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
"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