BookmarkSubscribeRSS Feed
alko13
Quartz | Level 8

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:

alko13_0-1692266699415.png

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

 

 

 

6 REPLIES 6
andreas_lds
Jade | Level 19

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

Have you installed the 32 bit version of the addin?

alko13
Quartz | Level 8

@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
SAS Super FREQ
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
PROC Star

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

alko13
Quartz | Level 8

@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
PROC Star

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

SASKiwi_0-1692332000489.png

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1578 views
  • 0 likes
  • 4 in conversation