Desktop productivity for business analysts and programmers

Send to Excel without opening a new Excel instance

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Send to Excel without opening a new Excel instance

Send to Excel without opening a new Excel instance.
Having changed from EG 7.12 to 7.15 we have encountered a small problem.

In 7.12, when we used the menu option "send to Excel", it used to open the spreadsheets in the same, active instance.
In 7.15 we get new instances of excel everytime we send to excel.

Are there any ways to change this?

/Ste

 


Accepted Solutions
Solution
‎12-19-2017 03:43 AM
SAS Super FREQ
Posts: 381

Re: Send to Excel without opening a new Excel instance

This was an intentional change. Prior to EG 7.12, we always created a new Excel instance for sending data to Excel. Starting in EG 7.12, we started re-using the existing Excel instance, if one was open. However, a problem that resulted from re-using the existing Excel instance was reported...  specifically, if you edit any Excel cell while data is being sent to Excel an error occurs that interrupts the send-to processing. There was not a good solution, so we reverted the behavior in EG 7.13 (and 7.12 HF5) back to always creating a new Excel instance.

 

Casey

View solution in original post


All Replies
SAS Employee
Posts: 199

Re: Send to Excel without opening a new Excel instance

Hi @StefanoC

 

Are you saying that prior to your upgrade, you were sending information from EG to an opened/active spreadsheet?

Are you sending SAS datasets?

 

I tried with few different versions and it is sending each attempts to a new instance of Excel.

 

Cheers,
Damo

New Contributor
Posts: 3

Re: Send to Excel without opening a new Excel instance

Thanks for your reply.

Yes. Unfortunately that is exactly what I mean.
I'm sending a SAS dataset using the sas menu option send to excel

Prior to the upgrade everything worked as wanted by the end users.
I.e the output landed in a new workbook in the same excel instance.

After the upgrade the output ends up in a new instance of excel.

Nothing else has changed.

I only have one computer that still have 7.12 installed.

I have contacted SAS Support, but I would love a quick answer.

/Ste

Community Manager
Posts: 3,362

Re: Send to Excel without opening a new Excel instance

As far as I know it always has created a new instance...but it might be controlled partly by Windows shell open settings for Excel.  The difference might also be triggered by whether you have the SAS Add-In for Microsoft Office installed (with same bitness as EG).

 

Solution
‎12-19-2017 03:43 AM
SAS Super FREQ
Posts: 381

Re: Send to Excel without opening a new Excel instance

This was an intentional change. Prior to EG 7.12, we always created a new Excel instance for sending data to Excel. Starting in EG 7.12, we started re-using the existing Excel instance, if one was open. However, a problem that resulted from re-using the existing Excel instance was reported...  specifically, if you edit any Excel cell while data is being sent to Excel an error occurs that interrupts the send-to processing. There was not a good solution, so we reverted the behavior in EG 7.13 (and 7.12 HF5) back to always creating a new Excel instance.

 

Casey

New Contributor
Posts: 3

Re: Send to Excel without opening a new Excel instance

Posted in reply to CaseySmith

Thank you for explaining it all.
That matches exactly the behavior we have with current and prior versions.
/Ste

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 429 views
  • 5 likes
  • 4 in conversation