How to fix data analysis so it can run properly again?

Jacob Bergin 0 Reputation points

"Automation error (Error 440)" is showing up once I select to run the data analysis add in. I have been able to run data analysis before on this computer. Additionally, I have added and unadded the data analysis add ins from the excel options. Also, there are times when excel says "not responding". I have closed down excel and restarted my computer numerous times but has not helped.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
922 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,176 Reputation points

    Hi @Jacob Bergin

    Please make sure VBA is enabled for Office on your machine.

    When you enable Analysis ToolPak add-in, please click browser, and find the ANALYS32.DLL file. The example path for 64-bit version is C:\Program Files\Microsoft Office\root\Office16\Library\Analysis. If the file does not exist, it is recommended that you copy the file from another computer to this directory.

    If nothing helps, I suggest you perform an Online Repair for Office from Control Panel.

    You may also create a new Windows account, and run Excel in this new account to check this issue.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.