Background
Sending data from SAS Enterprise Guide to Microsoft Office does not require SAS® Add-In for Microsoft Office. Sending results from SAS Enterprise Guide to Microsoft Office requires SAS Add-In for Microsoft Office. Note: Using Send to in SAS Enterprise Guide is not the same as using the SAS Enterprise Guide Export wizard.
Issue
When you send data from SAS Enterprise Guide to Microsoft Office, the operation might fail with the following (or a similar) error:
--------------------------------------------------------------------------------
Exception information
--------------------------------------------------------------------------------
Object reference not set to an instance of an object.
-------------------------- Technical Information Follows --------------------------
Exception Details:
----------------------------------------
Exception type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Source: SAS.EG.ProjectElements
Target Site: DoSendToExcel
Stack Trace:
at SAS.EG.ProjectElements.SendInputDataToOfficeHelper.DoSendToExcel(Object
sender, DoWorkEventArgs dwea)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Try the following (in order of likelihood) to correct the issue:
- Ensure that the most recent SAS Enterprise Guide hot fixes are installed.
- Repair Microsoft Office from the Microsoft Windows Control Panel.
- Disable displaying SAS® Studio tasks in SAS Enterprise Guide options.