How to resolve Microsoft Excel is waiting for another application to complete an OLE action issue error & A-144-1 : Error during load sheet name

 Previous  Home  Next

In Process Runner, iBook provides an integrated Excel with in Process Runner and allows users to perform all Excel operations from Process Runner. Users can also use any external excel file as a data source. At times, you may experience issues with Excel (iBook/External excel file). Here are some of the most common problem areas:

i.Excel temporarily lock issue on clicking iBook.

ii.Add-ins in Excel causing issue while using iBook / external excel.

iii.Scheduler hanging issues due to excel.

iv. Error messages displayed while using Excel 2013 or Office 365.

 

Microsoft_OLE

 

Excel_error

 

Suggested Solutions:

This section provides you with the steps on how to troubleshoot the problems and the possible remedies to the correct them.  Please note that Process Runner will work only with the MS Excel installed locally.

 

a)Close all the running instances of Process Runner and MS Excel.

b)Go to “Task Manager” (CLT+ALT+DEL and select Task Manager). Go to “Processes” tab and ensure that there are no ‘Pror.exe’ and ‘Excel.exe’ instance running. If any instances are found, then kill those instances.

c)Delete iBook.xls or iBook.xlsx file from My Documents\Innowera\Other folder.

d)Open the Excel from Start menu and check whether any temporary instance is open or not as shown in below image.

    Temp_xl_new

After you have followed the above mentioned steps, open the process file and check whether you are able to use iBook or external excel without any issue.  If you are still facing problems with iBook or excel, you may use few possible workarounds as described in this section.

hmtoggle_plus11. For all excel issues

 

Close all open process files. Go to the Options menu -> select Excel tab -> click on Auto Detect button  -> enable “A lways open new Excel instance for iBook” functionality  as shown in below image and try again.

 

Excel_issues

 

Open the process file and check whether you are able to use iBook/external excel file. If you still get the same issue then disable the protected view. To disable the protected view Open the Excel File ->  Select File menu -> Option ->  Trust Center -> Click on Trust Center Settings... button -> select Protected View option from left panel ->  Uncheck all box and save these settings.

Trust Center_Excel

If you still face issues, go to step 4.
hmtoggle_plus12. For Scheduler hanging issues due to excel

Once you have followed all the above mentioned options, manually run the process file which is schedule in Task Scheduler. After the normal run is successful, run the process file through Task Scheduler. To run process file through task scheduler, right click on the file and select Run as shown in below image.

 

Task scheduler

If you still face issues then go to step 4.
hmtoggle_plus13. For Office 365

If none of the above option works in case of Office 365 then kindly repair the MS office from control panel as shown in below image and try again.If you still face issues go to next step.

 

Office_365_Repair
hmtoggle_plus14. Support request via e-mail

 

If the above suggestions does not help then please contact us at support@innowera.com with the error screenshot, steps you have already tried along with the reply to the questions below.

 

a.Is the issue faced on using iBook or External Excel?

b.Is this issue seen in all the process file or in any particular process file?

c.Are two different version of MS office installed on the local system?

d.Send the screenshot of the version detail of Process Runner. Click on Help -> About in Process Runner.

 

sending license details

 

e.Please send us the MS office (Excel) version details screenshot. The MS office version details can be seen under Files menu -> Help  as shown in below image.

 

Xls_Files_Help

 

f.You can also send us the COM Add-ins window screenshot. Start the excel from start menu-> All program. Follow the steps as per the screenshot. Click on ‘Go’ button and take the screenshot of  COM Add-Ins pop up and send to Innowera support.

Xls_Options_Addin

COM_Add_in

 

 

Next:

Innowera Control Panel web service access errors