topic Re: SAS AddIn Excel | Not show Server in Administration and Deployment

SAS AddIn Excel | Not show Server

MariaD — Tue, 15 Sep 2020 02:16:14 GMT

Hi folks,

We have a user that, from one day to another, when tried to open a Data on SAS AddIn in Excel shows only SAS Folder. The Server to select libname, that not appears. She also use SAS EG and everything works fine on SAS EG.

Thanks,

Re: SAS AddIn Excel | Not show Server

AnandVyas — Tue, 15 Sep 2020 04:15:13 GMT

Hi @MariaD

Is this scenario only for a single user or all users? If it is for a single user, can you compare the permissions in SMC for this user with others?

Re: SAS AddIn Excel | Not show Server

JuanS_OCS — Tue, 15 Sep 2020 07:34:42 GMT

Hello @MariaD ,

I would suspect there is a problem in Firewall and/or registration of the COM components. Indeed, I would check if this issue happens only for this user, or more. Is this a virtualized client (Citrix/AppV...) or is it a local installation?

I would definitely try to enable the logging for this client, restart the client and try again the operation, to check the log afterwards: https://support.sas.com/kb/56/743.html

Re: SAS AddIn Excel | Not show Server

MariaD — Tue, 15 Sep 2020 10:32:30 GMT

For now, happens only for one user. Until last week, the user has not problem.

Regards,

Re: SAS AddIn Excel | Not show Server

JuanS_OCS — Tue, 15 Sep 2020 10:44:25 GMT

I can imagine well that something changed from the infra side. The answers to the questions above would help to filter and surround the issue.

Re: SAS AddIn Excel | Not show Server

DanielKaiser — Tue, 15 Sep 2020 10:50:14 GMT

I would do two things:

1) Go to %APPDATA%\SAS and rename the SAS-Folder. Then try again.

2) Go to Excel --> Options --> AddIns --> COM AddIns and delete the SAS AddIn. Then go to the Installationdirectory of your Add-In and execute the SwitcherUtility.exe to reinstall the COM-Addin. Then try again.