Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel download issue with Excel 2016 'Server busy'

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

Does anyone faced such issue?

Thanks

satyabrata_sahoo3
Contributor
0 Kudos

1: Ensure any Excel page is not open in system.

2: If any excel page open and still you get this, then kill the process in Windows Task Manager.(excel.exe)

3: If still issue persists, uninstall MSOffice completely and reinstall.

Hope this helps.. For me 2nd option worked.. The excel process was still running even after closing all open pages.

-Satya