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

SAS Add-in wont start with user rights but will start with admin rights

Reply
New Contributor
Posts: 4

SAS Add-in wont start with user rights but will start with admin rights

Hi, I have deployed SAS Add-in for Microsoft Office v7.14 to my users via SCCM. When they start Word or Excel and the add-in is observed loading on the splash screen, we get "SAS Add-in for Microsoft Office has encountered a problem".

 

Word will eventually load, after clicking close on the error box, but the addins are not in the ribbon.

 

If I start Word with admin rights, the addins load and word starts with the addin in the ribbon.

 

We have Windows 10, Office 365 C2R and SAS Add-in 7.14.  I have attached the error dump.  We also have AppSense in our environment as well.

 

any advice would be appreciated.

 

thanks,

James

New Contributor
Posts: 4

Re: SAS Add-in wont start with user rights but will start with admin rights

Posted in reply to jimbocalvo

Just as a follow up to some more testing, we get the same error when we run word with an account that isnt in AppSense.  

SAS Employee
Posts: 302

Re: SAS Add-in wont start with user rights but will start with admin rights

Posted in reply to jimbocalvo

 Have you tried to enable logging ?

 

http://support.sas.com/kb/56/743.html

 

SAS Employee
Posts: 5

Re: SAS Add-in wont start with user rights but will start with admin rights

Posted in reply to jimbocalvo

Hi James,

 

One of the scenarios that can cause this is if the bitness of the Office product does not match the bitness of the SAS Add-In.  I would suggest checking your Office installation on the machine to see if it is 32 or 64 bit Office.  Then, make sure that your SAS Add-In was installed with the same bitness.

 

A common mistake is that someone will have a 64-bit machine, but the default Office installations are still 32-bit applications.

 

Tim Beese

New Contributor
Posts: 4

Re: SAS Add-in wont start with user rights but will start with admin rights

Hi, we are using 32bit Office 365. I will just add though that if I start Word or Excel with elevated rights, the add-in loads normally. If the bitness was an issue would it give me the error when running with elevated and non-elevated permissions?
SAS Employee
Posts: 5

Re: SAS Add-in wont start with user rights but will start with admin rights

Posted in reply to jimbocalvo

You're right, if the add-in was installed with the wrong bitness, then it wouldn't matter if the user had admin rights or not, it would be giving this error.  

 

I'm not familiar with the difference between running the install with SCCM vs using the SAS Deployment Wizard, so I'm not much help on that front.

 

As for the error that you're getting, another thing that could cause that would be if the Microsoft Visual C++ 2015 Redistributable (x86) was not available to the user.  it seems odd that this would only be available for a user with admin rights and not for the regular user, but it's a thought.  Is this component installed on the machine?

 

If this doesn't help, you could open a track with SAS Technical support and they can assist with further diagnosis to try and find out which component is not available.

SAS Employee
Posts: 199

Re: SAS Add-in wont start with user rights but will start with admin rights

Hi @jimbocalvo

 

Not sure if you're still experiencing the problem reported some weeks ago.

Did you try to use the Switcher utility as per Problem Note 52058 (If SAS® Add-In for Microsoft Office is installed with provisioning software, the SAS® menu is missing and the installation is incomplete) ?

 

Hope that helps.


Cheers,
Damo

New Contributor
Posts: 4

Re: SAS Add-in wont start with user rights but will start with admin rights

Thanks Damo, I will give this a try
Ask a Question
Discussion stats
  • 7 replies
  • 215 views
  • 0 likes
  • 4 in conversation