https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-AddIn-for-Excel-Preserve-style/m-p/694562#M2480 <P>Hi folks,&nbsp;</P> <P>&nbsp;</P> <P>We have a simple process to execute and show a results directly on Excel using SAS AddIn. The user apply table format (Excel option) to present the results but after refreshing SAS, the style is not preserve.</P> <P>&nbsp;</P> <P>Any idea how to preserve Excel styling when refresh?</P> <P><SPAN style="font-family: inherit;">&nbsp;</SPAN><BR /><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.23.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51119i471A65F592BAFDD3/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.23.png" alt="Screen Shot 2020-10-27 at 09.47.23.png" /></span></P> <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.41.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51121i3C23723742188813/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.41.png" alt="Screen Shot 2020-10-27 at 09.47.41.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.47.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51122i37FC5E6C423E6AF5/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.47.png" alt="Screen Shot 2020-10-27 at 09.47.47.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.48.01.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51123i9889AE070355DB7B/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.48.01.png" alt="Screen Shot 2020-10-27 at 09.48.01.png" /></span></P> <P>&nbsp;</P> <P>Regards,</P> Tue, 27 Oct 2020 12:52:44 GMT MariaD 2020-10-27T12:52:44Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-AddIn-for-Excel-Preserve-style/m-p/694562#M2480 <P>Hi folks,&nbsp;</P> <P>&nbsp;</P> <P>We have a simple process to execute and show a results directly on Excel using SAS AddIn. The user apply table format (Excel option) to present the results but after refreshing SAS, the style is not preserve.</P> <P>&nbsp;</P> <P>Any idea how to preserve Excel styling when refresh?</P> <P><SPAN style="font-family: inherit;">&nbsp;</SPAN><BR /><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.23.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51119i471A65F592BAFDD3/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.23.png" alt="Screen Shot 2020-10-27 at 09.47.23.png" /></span></P> <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.41.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51121i3C23723742188813/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.41.png" alt="Screen Shot 2020-10-27 at 09.47.41.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.47.47.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51122i37FC5E6C423E6AF5/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.47.47.png" alt="Screen Shot 2020-10-27 at 09.47.47.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screen Shot 2020-10-27 at 09.48.01.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51123i9889AE070355DB7B/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2020-10-27 at 09.48.01.png" alt="Screen Shot 2020-10-27 at 09.48.01.png" /></span></P> <P>&nbsp;</P> <P>Regards,</P> Tue, 27 Oct 2020 12:52:44 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-AddIn-for-Excel-Preserve-style/m-p/694562#M2480 MariaD 2020-10-27T12:52:44Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-AddIn-for-Excel-Preserve-style/m-p/694853#M2481 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/36451">@MariaD</a>&nbsp;</P> <P>&nbsp;</P> <P>What is the full version of SAS Add-in for MS Office installed? Go to Help -&gt; About SAS Add-in on the SAS ribbon in Excel for this information. For example, 8.2 Update 5 (8.2.5.842) (32-bit).</P> <P>&nbsp;</P> <P>Please post a screen shot of the Results options in the "SAS Results" section:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fifthand57th_0-1603892434767.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51160i45815127171910D9/image-size/medium?v=v2&amp;px=400" role="button" title="fifthand57th_0-1603892434767.png" alt="fifthand57th_0-1603892434767.png" /></span></P> <P>&nbsp;</P> Wed, 28 Oct 2020 13:41:19 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-AddIn-for-Excel-Preserve-style/m-p/694853#M2481 fifthand57th 2020-10-28T13:41:19Z