topic Re: Error HRESULT: 0x80040501 when adding excel files in ArcGIS Enterprise Questions

Error HRESULT: 0x80040501 when adding excel files

IreneFernández_López — Wed, 15 Jan 2020 15:49:13 GMT

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.

Re: Error HRESULT: 0x80040501 when adding excel files

VictoriaAnderson — Wed, 15 Jan 2020 16:56:58 GMT

Do you have 2 versions (64 and 32 bit) of Microsoft Access Database installed? If so, can you uninstall both versions and reinstall just the 32 bit?

Re: Error HRESULT: 0x80040501 when adding excel files

IreneFernández_López — Wed, 15 Jan 2020 23:25:37 GMT

That was the problem! Thank you so much!!!

Re: Error HRESULT: 0x80040501 when adding excel files

RafałRokicki — Thu, 07 May 2020 12:50:08 GMT

Hello,

i have same problem and same error, but after reinstall whole Office and install Standard x64 (without Access) instead of Profesional x32 (with Access) i still have this error

Re: Error HRESULT: 0x80040501 when adding excel files

VictoriaAnderson — Thu, 07 May 2020 12:55:37 GMT

Could you try uninstalling the 64 and install the 32 instead?

Re: Error HRESULT: 0x80040501 when adding excel files

RafałRokicki — Thu, 07 May 2020 13:58:02 GMT

Just finished install only Standard 32 bit and still this errror

Re: Error HRESULT: 0x80040501 when adding excel files

AlexanderGlonti — Sat, 24 Apr 2021 21:21:57 GMT

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

Re: Error HRESULT: 0x80040501 when adding excel files

AndrewDolch2 — Wed, 05 May 2021 19:38:39 GMT

Convert the file to a CSV and then import.

Re: Error HRESULT: 0x80040501 when adding excel files

AlexRudowski — Tue, 25 May 2021 22:14:06 GMT

I get this same error sometimes when I'm trying to save a new ArcPro project. I'm not sure what the Access driver has to do with my situation, but I checked and I only have the 32-bit version on my machine. The error message appears, but sometimes if it sits for about five minutes with the error message up the project will finally save. I'm working in 2.7.3 but will soon update to the newest version.

Thanks

Re: Error HRESULT: 0x80040501 when adding excel files

ZacharyHart — Fri, 16 Jul 2021 12:58:11 GMT

having the exact same issue still. @AlexRudowski did you ever find a solution?

Re: Error HRESULT: 0x80040501 when adding excel files

AlexRudowski — Fri, 16 Jul 2021 18:13:27 GMT

I'm not getting the error anymore, but I'm still having the issue where it takes forever to save. Sometimes it just spins and never saves at all 🤔

Re: Error HRESULT: 0x80040501 when adding excel files

AlexRudowski — Thu, 19 Aug 2021 16:21:00 GMT

@ZacharyHart I'm getting the same error again this morning. I'm still on 2.7.3, so I think I'm going to move to the newest version. What version are you running?

Re: Error HRESULT: 0x80040501 when adding excel files

ZacharyHart — Tue, 14 Sep 2021 17:46:27 GMT

same version still 2.7.3. If the upgrade process didn't break my dev environment every single time you upgrade, I'd make the jump much more often.

Re: Error HRESULT: 0x80040501 when adding excel files

TomStephenson3 — Tue, 16 Nov 2021 08:43:18 GMT

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!

Re: Error HRESULT: 0x80040501 when adding excel files

ALESSANDRASPREAFICO — Mon, 16 Sep 2024 08:50:38 GMT

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

Re: Error HRESULT: 0x80040501 when adding excel files

JoeBryant1 — Wed, 16 Apr 2025 23:10:50 GMT

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".

Re: Error HRESULT: 0x80040501 when adding excel files

JoeBryant1 — Thu, 17 Apr 2025 00:49:06 GMT

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.