Opening an Excel Document gives Run Time 13 error

asked 2022-06-11T07:25:08.3+00:00
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?

210455-image.png

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,333 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2022-06-13T02:18:37.623+00:00
    Ceasar Chen_MSFT 4,281 Reputation points Microsoft Employee

    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
      210607-image.png
    3. Open a new workbook to import module.
      You can also try to modify the registry LoadApplnit_DLLs value to 1.
      210681-image.png
      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. answered 2022-07-06T12:11:13.237+00:00
    Lorne Andersen 241 Reputation points

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

    No comments