The Sage Excel Integration Add-in SGXLADDIN.DLL is not visible from Excel 2007


The Sage Excel Integration Add-in SGXLADDIN.DLL is not visible from Excel 2007


Issue

You are unable to access the Sage Excel Integration add-in from Office 2007 when Sage and Excel are installed on a Windows 2008 Terminal Server.  The user account that was used to install the applications can access the addin OK.

Problem

Even though Sage and Excel have been installed correctly on the terminal server the required registry keys are not initialised for other users that log into the system so they dont have access to the add-in.

Resolution

The following has been tested on Windows 2008 R2, Excel 2007 and Sage Accounts 2011. In order to get this working you need to be able to add information to the registry either by entering the keys manually or by creating a .REG file. To create the registry file simply copy the text between the ******** at the bottom of this document into notepad and then save the file to your system. Do not include the ******* in the file.

 

1. Open Excel and Excel Options ( Button - Excel Options)

    

2. Add the Excel Add-in

  • Select Addins

  • Select Excel Add-ins and click Go

  • Click Browse

  • Browse to C:\Windows\System32 (be sure to select All files from the drop down option next to file name)

  • Select SGXLADDIN.DLL
  • Click OK
  • The Addin should be listed and selected




3. Close Excel
4. Open Windows Explorer and browse to the folder where you saved the registry file.
5. Double click the registry file to load the Sage keys into the registry. (you should see the following)




6. Open Excel and Excel Options ( Button - Excel Options)

    

7. Add the COM Add-In


  • Select Add-ins

  • Select COM Add-ins and click Go
  • Browse to C:\Windows\SysWOW64 and select SGXLADDIN.DLL

  • Click OK and the Sage Excel Integration add-in should be listed and selected

  • Click OK to return to Excel. The Add-ins tab should be displayed. Select the tab to confirm the Sage add in has loaded.




Repeat this process for each user who needs to access the Sage Excel Integration add-in.


Additional Information

These are the keys extracted from HKCU. Copy everything between the ********* into a .REG file then double click the file.

****************************************************************************
Windows Registry Editor Version 5.00

 

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options]

"OPEN"="/R \"C:\\Windows\\system32\\SGXLADDIN.dll\""

"SP1FirstRun"=dword:00000000

"MsoTbCust"=dword:00000008

"OptionFormat"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\

  00,00,00,00

"Pos"="154,154,1065,675"

"TipShown"=hex:00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\

  00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00

"FirstRun"=dword:00000000

"OptionsDlgSizePos"=hex:48,03,00,00,ad,02,00,00,22,01,00,00,78,00,00,00,00,00,\

  00,00

"DefaultSheetR2L"=dword:00000000

"UseSystemSeparators"=dword:00000001

"ThousandsSeparator"=","

 "DecimalSeparator"="."
******************************************************************************


 

Cardium offer services including Cloud Computing using Microsoft Remote Desktop Services paid for monthly and per user, installation, consultancy and virtualisation best practises.

Company Registration 5135448 VAT registration 834 5840 16

Your Office Anywhere, Cardium Outsourcing, Unit 4, Dominion Court, Billington Road, Burnley, Lancashire, BB11 5UB, UK.

 © Your Office Anywhere 2011


Add Feedback