Add-In Tab missing

From Sage Intelligence Knowledgebase
Jump to: navigation, search

ISSUE: ADD-INS TAB MISSING


SYMPTOMS:

Add-ins Tab is missing when report is loaded onto excel


CAUSE:

The DLL files have become un-registered, and need to be re-registered


RESOLUTION/WORKAROUND:

Here are the steps on how to register a DLL and how to check if the Add-ins folder exists on the windows registry.


How to register a DLL

Before you begin registering the PLDRILL DLL make sure excel is closed, Alchemex smart reporting is closed and all bicore.exe and excel processes on the task manager are closed.

1. Go to the Start Menu.

2. Search for cmd then right-click on cmd and run administrator.


Pic1.png


3. All of Alchemex Smart Reporting DLLs are found at this location on windows 7 C:\Program Files (x86)\Common Files\BIComponents and C:\Program Files \Common Files\BIComponents on XP.

4. When cmd is open enter the following command.

5. Type where blinking cursor the following command:

cd C:\Program Files (x86)\Common Files\BIComponents if you are windows 7 or cd C:\Program Files \Common Files\BIComponents on XP.

6. Then type regsvr32 PLDRILL.DLL and then DLL will registered successfully.


How to check if the Add-ins folder exists on the windows registry

1. Go to the Start Menu.

2. Search for regedit then click on the regedit.

Pic2.png


3. Browse the software folder :

SOFTWARE >> wow6432Node >> Microsoft >> Excel >> Addins >> PLDRILL.Connect folder on windows 7 has to be here for the Addins Tabs to show on excel.

SOFTWARE >> Microsoft >> Excel >> Addins >> PLDRILL.Connect folder on windows xp has to be here for the Addins Tabs to show on excel.


REFERENCES:


APPLIES TO: