Problem Open Excel file after proc export

[Hazou]

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

[ChrisNZ]

> On server, i can't use XLSX, EXCEL, EXCEL5. 

Yet the code uses XLSX

> Sometimes its works, sometimes not. 

What does that mean? Errors in the log? missing data?

Show us the log.