Getting error while opening XLSB workbook

[ERROR] 2024-03-15 06:55:01 01m 01s (0h) - Error executing action [exceljacob->open-create-workbook]
Invoke of: Open
Source: Microsoft Excel
Description: Open method of Workbooks class failed


Hi, i am getting this above error when i am trying to open XLSB workbook through Appian RPA and for this i'm using "Open Workbook(license required)" component.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    To resolve the error when opening an XLSB file with Appian RPA:

    1. Confirm that Microsoft Excel is installed and properly configured on the RPA agent's machine.
    2. Ensure the XLSB file is not open elsewhere or locked by another process.
    3. Verify that the "Open Workbook" component supports XLSB files.
    4. Check that you have a valid license for both Excel and the RPA component.
    5. Update Appian RPA and Excel to the latest versions if compatibility issues are suspected.
    6. Inspect the Excel file to ensure it's not corrupted.
    7. Adjust Excel's Trust Center settings to allow automation.
Reply
  • 0
    Certified Senior Developer

    To resolve the error when opening an XLSB file with Appian RPA:

    1. Confirm that Microsoft Excel is installed and properly configured on the RPA agent's machine.
    2. Ensure the XLSB file is not open elsewhere or locked by another process.
    3. Verify that the "Open Workbook" component supports XLSB files.
    4. Check that you have a valid license for both Excel and the RPA component.
    5. Update Appian RPA and Excel to the latest versions if compatibility issues are suspected.
    6. Inspect the Excel file to ensure it's not corrupted.
    7. Adjust Excel's Trust Center settings to allow automation.
Children
No Data