Resolve Excel Related Issues
Symptom
Sometimes, when you run a Process file using an external Excel file, you may run into one of the following errors.
FM:48 Error During load sheet name
FM: 48 Invalid Index. (Exception from HRESULT: 0x8002000B) (DISP_E_BADINDEX))
FM:73 Process Runner
FM: 73 Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Workbook'. This operation is failed because the QueryInterface call on the COM component for the interface with IID '{000208DA-0000-0000-C000-000000000046}' failed due to '{000208DA-0000-0000-C000-000000000046}' failed due to following error : Library not registered. (Exception from HRESULT: 0x800280 1D (TYPE_E_LIBNOTREGISTERED)).
Microsoft Excel
Document with name “TempXL.xlsx” is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents.
Microsoft Excel is waiting for another application to complete an OLE action.
FM:49 Process Runner
FM: 49 The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
X-103: DsoFramerControl
System.Runtime.InteropServices.COMException (0x80041108): Cannot access document when in modal condition.
Solution
To resolve this issue, perform the following
- Close all the sessions of Process Runner.
- Open Excel.
- If Document Recovery Pane is displayed in Excel, recover all the files.
- Close all the sessions of Excel.
- Open Task Manager and select Processes tab. Ensure that no Excel or Process Runner instance is running.
- If you see any Process Runner or Excel instance, select Excel.exe or ProR.exe and click End Process.
- Start Process Runner, select Tools > Option.
- On the Excel tab, select Auto Detect > Apply > OK.
If the error is not resolved, refer Microsoft Excel Related Issues.
For further assistance, please create a support case on Salesforce.