ERROR in opening Excel report after running proc export successfully

Abhinav26 — Thu, 24 Sep 2020 13:33:55 GMT

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 ??

Re: ERROR in opening Excel report after running proc export successfully

ballardw — Thu, 24 Sep 2020 14:49:53 GMT

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?

topic ERROR in opening Excel report after running proc export successfully in SAS Programming

ERROR in opening Excel report after running proc export successfully

Re: ERROR in opening Excel report after running proc export successfully