SAS User getting SAS EG Message "Unable to send SAS Report filename to Microsoft Excel.

[nsahotay]

Hi,

We are using SAS 9.3, SAS Enterprise Guide 5.1.

One of my users has two devices and the first works fine but the second device is using a SAS Virtual Machine.

When they use Enterprise Guide, run some code and get the output and results then in the VM they get the following message:

SAS EG Message: Unable to send 'SAS Report filename' to Microsoft Excel. The SAS Addin 5.1 for Microsoft Office is either not installed or not enabled for this product. The message pops up and doesn't open Microsoft Excel and populates the SAS output table in the file.

But her normal SAS device where SAS has been installed onto it works fine.

We have other users who tried the same thing in the SAS VM and it works fine for them, clicking on the "Sent To" option in the SAS EG output opens Microsoft Excel and populates the file fine.

There doesn't seem to be an issue in the same VM for other users when they have the same permission, role and group assigned. Same access to the same software in the same VM.

So not sure why it isn't working for the one user?

Does anyone have any suggestions?

[jimbarbour]

Virtualized environments can be really tricky.  Is there anything that can be de-installed and a full install run thereafter?  Sometimes the right IOM modules (I think that's the right nomenclature) don't get installed. If you can work with an Admin on the local machine, you could try downloading fresh IOM modules from the SAS website.  I was able to fix a problem this way in 2015 on EG 5.1.

I'm probably preaching to the choir here if you're a fan of SAS at all, but have you considered moving to a newer version of SAS EG?  I don't know what the limitations of SAS 9.3 are in terms of compatibility with the various versions of EG, but I imagine something newer than 5.1 is available.  EG 5.1 isn't bad (version 4, now that was bad), but the current version is 8.3.  I'm just throwing out ideas here although if you're in a virtualized environment, you may be in a large company, and large companies sometimes move slowly on upgrades.

Jim