Error in enabling SAS Add-in for Office

[alko13]

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

[andreas_lds]

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

Have you installed the 32 bit version of the addin?

[alko13]

@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. 

[JosvanderVelden]

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.

[SASKiwi]

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

[alko13]

@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?

[SASKiwi]

@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: