SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Excel Add-in load issue

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 11
Accepted Solution

SAS Excel Add-in load issue

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

Accepted Solutions
Solution
Wednesday
Occasional Contributor
Posts: 11

Re: SAS Excel Add-in load issue

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.

View solution in original post


All Replies
Regular Contributor
Posts: 171

Re: SAS Excel Add-in load issue

What version is:

 

1.) OS

2.) MS-Office

3.) SAS add-in

 

Occasional Contributor
Posts: 11

Re: SAS Excel Add-in load issue

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)




Regular Contributor
Posts: 171

Re: SAS Excel Add-in load issue

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

Trusted Advisor
Posts: 1,197

Re: SAS Excel Add-in load issue

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/

SAS Employee
Posts: 93

Re: SAS Excel Add-in load issue

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

Solution
Wednesday
Occasional Contributor
Posts: 11

Re: SAS Excel Add-in load issue

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.

Regular Contributor
Posts: 171

Re: SAS Excel Add-in load issue

Great to hear.

Does happen with one or multiple PCs ?
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 181 views
  • 0 likes
  • 4 in conversation