BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Shakir_Juolay
Obsidian | Level 7
My SAS Excel Add-in doesn't load automatically always.
1 ACCEPTED SOLUTION

Accepted Solutions
Shakir_Juolay
Obsidian | Level 7

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

7 REPLIES 7
nhvdwalt
Barite | Level 11

What version is:

 

1.) OS

2.) MS-Office

3.) SAS add-in

 

Shakir_Juolay
Obsidian | Level 7
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
Barite | Level 11

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
Amethyst | Level 16

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
SAS Employee

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
Obsidian | Level 7

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
Barite | Level 11
Great to hear.

Does happen with one or multiple PCs ?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 7 replies
  • 29013 views
  • 2 likes
  • 4 in conversation