topic Re: SAS Excel Add-in load issue in Microsoft Integration with SAS

SAS Excel Add-in load issue

Shakir_Juolay — Fri, 13 Oct 2017 06:13:27 GMT

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

Re: SAS Excel Add-in load issue

nhvdwalt — Fri, 13 Oct 2017 06:30:01 GMT

What version is:

1.) OS

2.) MS-Office

3.) SAS add-in

Re: SAS Excel Add-in load issue

JuanS_OCS — Fri, 13 Oct 2017 06:58:02 GMT

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-Excel/td-p/177953 (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/

Re: SAS Excel Add-in load issue

Shakir_Juolay — Sun, 15 Oct 2017 05:36:35 GMT

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)

Re: SAS Excel Add-in load issue

nhvdwalt — Sun, 15 Oct 2017 07:41:09 GMT

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

Re: SAS Excel Add-in load issue

Damo — Tue, 17 Oct 2017 20:28:45 GMT

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

Re: SAS Excel Add-in load issue

Shakir_Juolay — Wed, 18 Oct 2017 05:37:03 GMT

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.

Re: SAS Excel Add-in load issue

nhvdwalt — Wed, 18 Oct 2017 07:00:35 GMT

Great to hear.

Does happen with one or multiple PCs ?