Skip to main content
manavl5697
New Participant
Mar 15, 2024 7:31 AM UTC
Question

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.

    2 replies

    davidj137213
    davidj137213
    Brainy
    Mar 15, 2024 8:47 AM UTC

    Could you check if there is more information in logs please?

    srmm0001
    srmm0001
    Inspiring
    Apr 2, 2024 6:37 PM UTC

    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.
    Terms & ConditionsAccessibility statement