Problem after exporting data using ODS Excel

[vikaskubde]

Hello Team,

I have a formated ODS Excel code to export data.

I exported it successfully using ODS Excel.

The problem I am facing that when I open that exported file from the location and write some text manually in sheet 1, the same is reflecting on each sheet.

I need to write something on sheet 1 before sending it to the client.

Please provide the solution to this problem.

see the attached file here.

Thanks in advance,

With kind regards,

Vikas

[Tom · Accepted solution]

This has come up before on this forum. The problem is that ODS has somehow created a workbook where the sheets are linked or grouped together.  I forget the Excel terminology for this type of linkage and what the right solution was. 

Try searching this forum for your problem.

If nothing else just open the workbook and un-link the sheets before editing any of the values.

[vikaskubde]

Thanks, Tom 

It is okay to ungroup worksheet manually in Excel (right click sheet and click Ungroup sheets).

However, I need the solution in SAS.

Can we implement the SAS code for Ungroup the worksheet in ODS Excel?

Greatly appreciate if we have a solution to it in SAS.

Thanks in advance,

Vicky

[SuzanneDorinski]

Are you using SAS 9.4 maintenance release 3?  If so, there is a hot fix.  

Problem Note 56878: The ODS destination for Excel generates grouped worksheets when multiple sheets ...

[vikaskubde]

I am using SAS 9.4

[vikaskubde]

Hello Suzanne,

I am using SAS version 9.4 M3.

Is it any solution of Ungroup worksheet in SAS version M3?

Thanks in advance,

Vicky