Hello, I have a problem when i want to open Excel File with many sheets after a proc export on server. Sometimes its works, sometimes not. After analyse, for Data < 5500 rows, i can't open the excel file, for the data > 5500 rows, it's working. Do you have a idea ? Thanks a lot. ps : On server, i can't use XLSX, EXCEL, EXCEL5. %MACRO Export_ness (data,table, sheet); PROC EXPORT DATA = &data. OUTFILE = "/..../&table..xlsx" DBMS = xlsx REPLACE ; SHEET = "&sheet." ; RUN ; %mend; %Export_ness (test,FIILE, sheet1); %Export_ness (test,FILE, sheet2); Best Regards Hazou
... View more