Opening an Excel Document gives Run Time 13 error

Lorne Andersen 241 Reputation points

I have a password-protected Excel document that when I open it I get a run time error 13. This happens on my Windows 11 HP PC with the latest Excel, 365. This error does not occur on another user's Windows 11 PC, and a Windows 10 PC.

What I have done within Excel options:
a) Selected "Trust access to the VBA project object model" under Macro Settings in Excel
b) Selected "Disable VBA macros with notification" also under Maco Settings in Excel
c) Selected "Disable hardware graphics acceleration"

Additionally, I reinstalled Office. None of this works.

Is there a possible solution to this?


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,636 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ceasar Chen_MSFT 4,391 Reputation points

    Hi, @Lorne Andersen
    You can try to export the module in VBA and import it into a new Excel workbook.

    1. Use Project Explorer (Press [Ctrl]+R) > Right click on the module > Export File
    2. Type the name and folder of the module, repeat this step to export the entire module
    3. Open a new workbook to import module.
      You can also try to modify the registry LoadApplnit_DLLs value to 1.
      Note: Modifying the registry may cause adverse consequences, it is recommended that you back up the registry.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Lorne Andersen 241 Reputation points

    I also tried changing the value to 1 as stated and get the same error.

    0 comments No comments