topic Re: Error in enabling SAS Add-in for Office in Administration and Deployment

Error in enabling SAS Add-in for Office

alko13 — Thu, 17 Aug 2023 10:07:55 GMT

We have performed a fresh install of SAS Add-in for Office. Installation went successful,

However when trying to activate the SAS menu in excel it is failing with below error:

Complete log of the error:

Name:

From: file:///C:/Program Files (x86)/SASHome/x86/SASAddinforMicrosoftOffice/8/SAS.ExcelAddIn.vsto

************** Exception Text **************

System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/SASHome/x86/SASAddinforMicrosoftOffice/8/SAS.ExcelAddIn.vsto did not succeed. ---> System.Net.WebException: Could not find a part of the path 'C:\Program Files (x86)\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.ExcelAddIn.vsto'. ---> System.Net.WebException: Could not find a part of the path 'C:\Program Files (x86)\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.ExcelAddIn.vsto'. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files (x86)\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.ExcelAddIn.vsto'.

at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)

at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)

at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)

--- End of inner exception stack trace ---

at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)

at System.Net.FileWebRequest.GetResponseCallback(Object state)

--- End of inner exception stack trace ---

at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)

at System.Net.FileWebRequest.GetResponse()

at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

--- End of inner exception stack trace ---

at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.GetManifests(TimeSpan timeout)

at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

Please advice

Re: Error in enabling SAS Add-in for Office

andreas_lds — Thu, 17 Aug 2023 10:25:25 GMT

Have you verified that C:/Program Files (x86)/SASHome/x86/SASAddinforMicrosoftOffice exists?

Have you installed the 32 bit version of the addin?

Re: Error in enabling SAS Add-in for Office

JosvanderVelden — Thu, 17 Aug 2023 10:26:40 GMT

Have a look at the solution in this thread: https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Add-in-Disabled-in-Excel/td-p/542236
I hope it helps you to solve the problem you are experiencing.

Re: Error in enabling SAS Add-in for Office

SASKiwi — Thu, 17 Aug 2023 20:29:14 GMT

Check for the existence of the paths mentioned in the errors. If they don't exist I would deinstall and reinstall.

Re: Error in enabling SAS Add-in for Office

alko13 — Fri, 18 Aug 2023 03:54:08 GMT

@andreas_lds we have installed the 32 bit version, however it is not being created on the C:\Program Files (x86)\SASHome path

Only EG is there.

Same goes with C:\Program Files\SASHome. it does not have the AMO inside even after successful SDW installation of AMO.

Re: Error in enabling SAS Add-in for Office

alko13 — Fri, 18 Aug 2023 03:55:44 GMT

@SASKiwi the paths does not exist.

No AMO is created in C:\Program Files (x86)\SASHome path

Only EG is there.

Same goes with C:\Program Files\SASHome. it does not have the AMO inside even after successful SDW installation of AMO.

Also, AMO is not available in Add/Remove programs and in SAS Deployment Manager under Uninstall SAS Software, hence cannot uninstall.

Are there other options to uninstall/remove this?

Re: Error in enabling SAS Add-in for Office

SASKiwi — Fri, 18 Aug 2023 04:13:37 GMT

@alko13 - Do you use 32-bit or 64-bit Office? If it's 32-bit then that is the correct install location. Make sure you have admin access, then try a reinstall.

You could also try going into Excel Options and check the Add-ins options. If the SAS-Add-in is listed as disabled then reenable it.

If successfully installed then the SAS Add-In should be listed in Apps & features: