Microsoft Excel Related Issues

Symptom

Sometimes, when you try to run a Process file, you may run into one of the following errors.

DISP_E_BADINDEX

Exception from HRESULT

Document with name “TempXL.xlsx” is already open

RPC_E_SERVERCALL_RETRYLATER

TYPE_E_LIBNOTREGISTERED

System.Runtime.InteropServices.COMException:Cannot access document when in modal condition

Solution

To resolve this issue, perform the following:

  1. Close all the sessions of Process Runner and Excel.
  2. Open Task Managerand select Processes tab. Ensure that no Excel or Process Runner instance is running.
  3. If you see any Process Runner or Excel instance, select Excel.exe or ProR.exe and click End Process.
  4. Delete the .xlsx file from My Documents\Innowera\Other folder.
  5. Open Excel and check whether any temporary instance is open.

Now, open the Process file and check whether you are able run the Process file. If you are still running into an Excel-related issue, perform the following:

 

  1. Close all the open Process files.
  2. Select Tools > Options > Excel tab.
  3. On the Excel tab, select Launch Excel natively on Excel Icon > Auto. Detect > Apply > OK.

internal-excel-ibook-error

Open the Process file and check whether you are able to use the external Excel file. If you are still running into the issue, then disable the protected view.

To disable the protected view

  1. Open the Excel File, select File > Option. The Excel Option window is displayed.
  2. Select Trust Center > Trust Center Settings.... The Trust Center window is displayed.
  3. Select Protected View and clear the options.

 

Once you have followed all the above mentioned options, manually run the Process file that is scheduled 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 the file and select Run.

HT-ResolveExcelIssuesWithPR6 (3)

 

Repair the Office from the control panel and try again. If you still face issues go to next step.

Office_365_Repair

 

For further assistance, please create a support case on Salesforce, with the error screenshot, steps you have already tried along with the reply to the questions below.

  1. Is the issue faced on using external Excel file?
  2. Is this issue seen in all the Process file or in any particular process file?
  3. Are two different version of Office installed on the local system?
  4. Send the screenshot of the version detail of Process Runner. Click Help > About in Process Runner.
  5. Send us the Office (Excel) version details screenshot. The Office version details can be seen under Files > Help.
    6. HT-ResolveExcelIssuesWithPR6 (4)
  6. You can also send us the COM Add-ins window screenshot. Start the Excel from Start > All program. Follow the steps as per the screenshot. Click Go and take the screenshot of COM Add-Ins pop up window and send it to the Magnitude support team.
    7. HT-ResolveExcelIssuesWithPR6 (1)
    COM_Add_in