topic SAS Add in for Microsoft Excel - How to link with SAS code in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-for-Microsoft-Excel-How-to-link-with-SAS-code/m-p/197157#M1626 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I would like to send the SAS output in excel version and the user should be able to refresh/update this excel report whenever there is a change in the data.</P><P>An example would be Monthly sales of a Laptop.</P><P>If I created an excel report which contains the geography details, Price, Units etc on a month basis and wanted to add the next month when ever the new data is available in the server.</P><P>Can I use the SAS 7.1 excel add in option to refresh my results? How to I do this? I need to do this from scratch? Is there a good document available for reading?</P><P></P><P>Thanks,</P><P>+Sathyan</P></BODY></HTML> Tue, 11 Aug 2015 22:59:50 GMT skallamp 2015-08-11T22:59:50Z SAS Add in for Microsoft Excel - How to link with SAS code https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-for-Microsoft-Excel-How-to-link-with-SAS-code/m-p/197157#M1626 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I would like to send the SAS output in excel version and the user should be able to refresh/update this excel report whenever there is a change in the data.</P><P>An example would be Monthly sales of a Laptop.</P><P>If I created an excel report which contains the geography details, Price, Units etc on a month basis and wanted to add the next month when ever the new data is available in the server.</P><P>Can I use the SAS 7.1 excel add in option to refresh my results? How to I do this? I need to do this from scratch? Is there a good document available for reading?</P><P></P><P>Thanks,</P><P>+Sathyan</P></BODY></HTML> Tue, 11 Aug 2015 22:59:50 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-for-Microsoft-Excel-How-to-link-with-SAS-code/m-p/197157#M1626 skallamp 2015-08-11T22:59:50Z Re: SAS Add in for Microsoft Excel - How to link with SAS code https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-for-Microsoft-Excel-How-to-link-with-SAS-code/m-p/197158#M1627 <HTML><HEAD></HEAD><BODY><P>Sathyan,</P><P></P><P>You might find this Getting Started book useful:&nbsp; <A href="https://support.sas.com/documentation/cdl/en/amogs/68673/HTML/default/viewer.htm#titlepage.htm" title="https://support.sas.com/documentation/cdl/en/amogs/68673/HTML/default/viewer.htm#titlepage.htm">SAS(R) Add-In 7.1 for Microsoft Office: Getting Started in Microsoft Excel, Microsoft Word, and Microsoft PowerPoint, Second Edition</A>. </P><P></P><P>Marie</P></BODY></HTML> Wed, 12 Aug 2015 17:05:18 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Add-in-for-Microsoft-Excel-How-to-link-with-SAS-code/m-p/197158#M1627 M_Dexter 2015-08-12T17:05:18Z