Skip to Content
0
Former Member
Aug 17, 2016 at 08:03 AM

Excel download issue with Excel 2016 'Server busy'

1158 Views

Dear Expert,

After i upgraded excel to excel 2016, following issue came out when i trying to download data from SAP to Excel 2016.

A dialog box is displayed with the title:

'Server busy' or 'OLE server busy' 'This action cannot be completed because

...the other program is busy'

'Switch to', 'Retry'

This issue will not happen if we downgraded excel to excel 2010.

Related ABAP coding as followings:

" Run excel
CREATE OBJECT l_excel 'Excel.Application'.

IF sy-subrc NE 0.
WRITE: / 'Excel initialization failed!'.
EXIT.
ENDIF.

SET PROPERTY OF l_excel 'DisplayAlerts' = 'False'.
SET PROPERTY OF l_excel 'VISIBLE' = 1.

" Open file
CALL METHOD OF l_excel 'WORKBOOKS' = l_workbooks.
CALL METHOD OF l_workbooks 'OPEN' = l_workbook
EXPORTING
#1 = p_file.

" Paste data to worksheet
CALL METHOD OF l_workbook 'Worksheets' = l_worksheet
EXPORTING
#1 = 1.
PERFORM frm_paste_itab_to_xls USING l_worksheet 2 1 it_line.

" Paste data to worksheet
CALL METHOD OF l_workbook 'Worksheets' = l_worksheet
EXPORTING
#1 = 2.
PERFORM frm_paste_itab_to_xls USING l_worksheet 2 1 it_line.

" Save xls
l_filename = 'C:\tmp\Ztest.xls'.

CALL METHOD OF l_workbook 'SaveAs'
EXPORTING
#1 = l_filename.

" Free object
FREE OBJECT l_worksheet.
FREE OBJECT l_workbook.
FREE OBJECT l_workbooks.
FREE OBJECT l_excel.


Could please let me know if you have faced same issue and if any solutions?

Thanks.

Attachments