Error HRESULT: 0x80040501 when adding excel files

[IreneFernández_López]

When I try to agregate an Excel File to ArcGIS Pro it comes out an error with the message: Exception of HRESULT 0x80040501.

It doesn't show any details on the error. I have already installed the Access Database Engine Controller, but I can't find where this error comes from.

Can anyone help me with this?

Thank you.

[RafałRokicki]

Just finished install only Standard 32 bit and still this errror

[AlexanderGlonti]

Hello, I have a same error into ArcGIS Pro during add data from PostgreSQL. Do we have any solution in such case?

[AndrewDolch2]

Convert the file to a CSV and then import.  

[TomStephenson3]

I still have this issue on ArcGIS pro 2.6.4 running 32bit Access only. Please come up with a better solution than this Esri!

[ALESSANDRASPREAFICO]

Hello all,

I get the same error when opening the project file in ArcGIS.

I have a connection to a PostgreSQL database on a remote server and I use a VPN to connect to the database.

The connection worked till last week. From another computer I don't have this error.

Is there a solution?

Thanks

[JoeBryant1]

Some employees at my org are also getting this error when trying to open an APRX with a layer joined to an excel table on our fileshare server. It works for some employees and not for others (all have access to the file). Running Pro 3.1 and 3.3.

We get "Failed to open table - The source data of the Layer or Standalone table is disconnected.

If I try to preview the sheet from the Catalog Pane, I get the error "Not running inside a server process."

If I try to add the sheet to my map's Table of Contents, I get "Error: 0x80040501".

[JoeBryant1]

To resolve the issue, I had our engineers move the complex charts and graphs they were making in separate sheets in the Excel file to another workbook that calls the data from this workbook. Once I cleared Pro's cache and reduced the Excel workbook down to a single sheet, it consistently opened.