ERROR in opening Excel report after running proc export successfully

[Abhinav26]

I have Excel report with multiple sheets having formula's refreshing from Backend sheet of same excel. After exporting data to one of the sheets, i can't open the excel.

filename temp "/home/ouput/auto/sas/NAV_Report3.xlsx";

proc export data=Test
outfile=temp
dbms=xlsx
replace;
sheet='Backend';
run; quit;

Error that i am getting is

" We found a problem with some content in 'NAV_Report3.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes."

After clicking Yes, i am getting

"The workbook cannot be opened or repaired by Microdoft Excel because it is corrupt."

 Any idea folks ??

[ballardw]

My first guess is that your data set you export contains something that is being interpreted by EXCEL as an "instruction" of some sort. What is in your data?