https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Export-to-Excel/m-p/2107#M115 I find that using the sas EXCEL engine with the libname statement creates a dynamic link where the XLS file is the :library" and the sheets are "datasets" within the library. We found it to be superior to the Import/Export Procs. Tue, 10 Apr 2007 14:33:36 GMT JohnH 2007-04-10T14:33:36Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Export-to-Excel/m-p/2106#M114 Is anyone aware of problems with the SAS Export to the EXCEL Workbook which has multiple sheets with links between them to create a summary sheet? I have no problem with a simple Excel Workbook but when I have to update a complex Workbook I do not get the results anticipated. SAS always creates a new sheet instead of updating the intended sheet. Wed, 17 Jan 2007 18:16:38 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Export-to-Excel/m-p/2106#M114 deleted_user 2007-01-17T18:16:38Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Export-to-Excel/m-p/2107#M115 I find that using the sas EXCEL engine with the libname statement creates a dynamic link where the XLS file is the :library" and the sheets are "datasets" within the library. We found it to be superior to the Import/Export Procs. Tue, 10 Apr 2007 14:33:36 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/SAS-Export-to-Excel/m-p/2107#M115 JohnH 2007-04-10T14:33:36Z