Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article provides mitigation steps for errors generated by Excel actions in desktop flows. Most errors occur in the context of multiple Excel actions, and there's no strict mapping between them.
More information
| Exception in error details | Mitigation steps |
|---|---|
| System.ArgumentNullException: Value cannot be null. Parameter name: type |
When Excel fails to open with this error, make sure that Excel is installed, licensed, and properly configured on the computer. You can also try to repair your Office installation. |
| System.IO.FileNotFoundException: documentPathSafe | The Excel file doesn't exist, or its name or path isn't spelled correctly. Also, the file path shouldn't contain more than 255 characters. |
| System.Runtime.InteropServices.COMException: Open method of Workbooks class failed | The Excel file path shouldn't contain more than 255 characters. |
| System.Runtime.InteropServices.COMException: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) | When an Excel file fails to open with this error, try to enable the Nest under a New Excel process option under the Advanced group of parameters. The existing Excel process might be terminated before opening this Excel file. |
| Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Excel document '<Excel_file_name>' not found. | Make sure that the Excel file is opened and its name or path is spelled correctly. |
| System.Runtime.InteropServices.COMException: Unknown name. (Exception from HRESULT: 0x80020006 (DISP_E_UNKNOWNNAME)) | Make sure that the target Excel file is opened in Protected View. |
| System.Runtime.InteropServices.COMException: Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) | The target Excel file shouldn't be edited (for example, a cell is actively being edited at the time of the action run) or blocked by a pop-up dialog when the corresponding Excel action runs. |
| System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC | When you use an Excel action where a column, a row, or both need to be specified, the column index should be greater than zero and less than 16,385, or the column letter should belong to the range between A and XFD. Furthermore, the row index should be greater than zero and less than 1,048,577. |
| System.Runtime.InteropServices.COMException: The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) | The Excel instance should be open and active, so the Excel file shouldn't be closed manually or through the "Close Excel" action before the rest of the Excel actions take place. |
The following exceptions come with embedded mitigation steps in their text.
| Exception in error details |
|---|
| System.Runtime.InteropServices.COMException: The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password. |
| System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: The column number must be greater than one or less than 16384. |
| System.Runtime.InteropServices.COMException: The file name is too long. Rename the file with fewer than 207 characters. |
| System.Runtime.InteropServices.COMException: The password you supplied isn't correct. Verify that the Caps Lock key is off and be sure to use the correct capitalization. |
| System.Runtime.InteropServices.COMException: Excel cannot open the file '<Excel_file_name>' because the file format or file extension is not valid. Verify that the file hasn't been corrupted and that the file extension matches the format of the file. |