https://communities.sas.com/t5/ODS-and-Base-Reporting/sas-code/m-p/232894#M14615 <P>You havent told us anything about the dataset you are exporting, how your exporting etc. &nbsp;The size of the Excel file is controlled by the Excel file format, and the size of data your exporting. &nbsp;Not much you can do about that. &nbsp;Have you tried exporting to Comma Seperated Variable file? &nbsp;That can be opened in Excel, but is smaller file size (for bigger files). &nbsp;However again, it depends on the data your exporting, Excel is not a data transfer/database or a tool for most jobs and it has limitations on the size of data it can handle. &nbsp;120mb is large for an Excel file, what are you going to do with it, nobody is ever going to look at a file that big. &nbsp;If its to transfer data then use a data transfer format (CSV, XML, dataset), if its for review then summarise the data.</P> Tue, 03 Nov 2015 15:12:28 GMT RW9 2015-11-03T15:12:28Z https://communities.sas.com/t5/ODS-and-Base-Reporting/sas-code/m-p/232889#M14614 Hi all, please help me in this. while i am creating xls file it is 120 MB it is taking time to get output. how can i decere excel file size it is urgent for me. is there any macro for this. regards. Srini Tue, 03 Nov 2015 14:58:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/sas-code/m-p/232889#M14614 srinivas6640 2015-11-03T14:58:28Z https://communities.sas.com/t5/ODS-and-Base-Reporting/sas-code/m-p/232894#M14615 <P>You havent told us anything about the dataset you are exporting, how your exporting etc. &nbsp;The size of the Excel file is controlled by the Excel file format, and the size of data your exporting. &nbsp;Not much you can do about that. &nbsp;Have you tried exporting to Comma Seperated Variable file? &nbsp;That can be opened in Excel, but is smaller file size (for bigger files). &nbsp;However again, it depends on the data your exporting, Excel is not a data transfer/database or a tool for most jobs and it has limitations on the size of data it can handle. &nbsp;120mb is large for an Excel file, what are you going to do with it, nobody is ever going to look at a file that big. &nbsp;If its to transfer data then use a data transfer format (CSV, XML, dataset), if its for review then summarise the data.</P> Tue, 03 Nov 2015 15:12:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/sas-code/m-p/232894#M14615 RW9 2015-11-03T15:12:28Z