SAS Excel Add-in load issue

[Shakir_Juolay]

My SAS Excel Add-in doesn't load automatically always.

[nhvdwalt]

What version is:

1.) OS

2.) MS-Office

3.) SAS add-in

[Shakir_Juolay]

Classified as Ooredoo General Business



1.) OS : Windows 10 32 bit

2.) MS-Office : Professional Plus 2016 (16.0.4498.1000) 32-bit

3.) SAS add-in : 7.13 (7.100.3.5386)

[nhvdwalt]

When this occurs, see if the SAS add-in appears under 'Slow and Disabled COM Add-Ins' in Excel under the File tab.

[JuanS_OCS]

Hello @Shakir_Juolay,

perhaps you can try to give a look into https://communities.sas.com/t5/Integration-with-Microsoft/SAS-Office-Add-In-is-not-available-in-Exce... (see last post) and http://support.sas.com/kb/53/764.html

Indeed, to know some additional details will help us to help you.

Also, as last resort, if we cannot help you, you can always open a ticket with SAS Technical Support. https://support.sas.com/techsup/contact/

[Damo]

Hi @Shakir_Juolay

Is the issue intermittent or not (sorry I could not say based on your initial statement) ?

In addition to previous information posted, I would use the Switcher Utility in command line.

You'll find further details with Usage Note 38700 (Command-line usage with the SAS® Add-In for Microsoft Office Switcher Utility.).

Hope that helps.

Cheers,

Damo

[Shakir_Juolay · Accepted solution]

Dear @nhvdwalt, @JuanS_OCS, @Damo,

The issue is intermittent. I raised a ticket with SAS Support. And they suggested

1. Close all SAS and Microsoft Office applications, including Outlook.
2. Navigate to the SASAddinForMicrosoftOffice\x.x\ folder. (where x.x is your version of the SAS Add-in).
3. Right click on the switcherutility.exe and choose "run as admin".
4. Select Excel, but not Outlook.
5. Complete the process.

Now, test by doing the following:
1. Open Excel (to check Disable items first)
2. Go to File -> Options -> Add-Ins
3. At the bottom of the window, in the drop down menu 'Manage' select Disabled Items -> Click Go
4. Does SAS Add in appear here, if it does click the enable button.

Next, check Com Add-ins:
5. Go to File -> Options -> Add-Ins
6. At the bottom of the window, in the drop down menu 'Manage' select COM Add ins -> Click Go
7. Check the box for SAS Add In and Select ok

Now close Excel and re-open. Is the SAS tab present?

Though I could not run the SwitcherUtility as not admin rights, enabling it from Disabled Add-Ins and checking it from COM Add-Ins helps.

[nhvdwalt]

Great to hear.

Does happen with one or multiple PCs ?