topic Re: Still having problems with 3.0 and Excel in ArcGIS Pro Questions

Still having problems with 3.0 and Excel

ToddFagin — Tue, 18 Oct 2022 15:27:11 GMT

Despite having installed every conceivable driver, I am still having issues with Excel in ArcGIS Pro 3.x. I go to add a table and it just spins and and spins and spins and never shows the table.

Yes, I have installed:

Microsoft .NET 6 Desktop Runtime x64
Microsoft Access Database Engine 2016 Redistributable 64-bit drive
.NET 6 Desktop Runtime Windows x86

I have even tried to install the 32-bit Microsoft Access Database Engine 2016 Redistributable driver, but get a setup error message that I cannot install the 32-bit version because I currently have 64-bit Office products installed.

And I have restarted my computer--repeatedly.

I have wasted hours of my life trying to get this to work. At this point, I am beyond frustrated and am a bit livid.

What gives?

Re: Still having problems with 3.0 and Excel

mlyons — Tue, 18 Oct 2022 16:26:33 GMT

Todd,

Reaching out because I am also running into the same issue.

Excel file itself is visible in geoprocessing tools (e.g. XY Table to Point, Table to Database...) but continuously spins when trying to open the excel file and view the sheets inside.
Viewed through a folder connection, the excel file is not visible at all.

I'm using 3.0.2, but I was able to load excel tables in previous 3.0 versions. I have this post stickied and will keep my eye out for any solutions. If I find out anything, I'll reply with the solution.

Re: Still having problems with 3.0 and Excel

ToddFagin — Tue, 18 Oct 2022 16:24:20 GMT

This sounds identical to my problem. I am sure we are not the only two.

Re: Still having problems with 3.0 and Excel

mlyons — Tue, 18 Oct 2022 16:49:38 GMT

Todd,

I was able to get it to work. Here were my steps assuming you have MSO x64 Office products installed:

Uninstall all versions of the Microsoft Access Database Engine using 'Add or Remove Programs'.
Reinstall the x64 Microsoft Access Database Engine (only download the x64 installer, make sure to uncheck the x32 installer.)
Restart ArcGIS (did not need to restart computer, but wouldn't hurt.)

Using these steps, sheets within excel files were able to load within ArcGIS again.

Hope this helps!

Re: Still having problems with 3.0 and Excel

RhettZufelt — Tue, 18 Oct 2022 19:27:04 GMT

If you have ArcMap on the same machine, you will need the 32 bit Redistibutable as well.

If not allowing to install because you have the 64 bit office, you need to install it silently. See step 4

Re: Still having problems with 3.0 and Excel

ToddFagin — Tue, 18 Oct 2022 21:43:13 GMT

It is working now after many uninstalls, reinstalls, restarts, etc. I don't know what did the trick.

It is nonetheless painfully slow.

Re: Still having problems with 3.0 and Excel

ToddFagin — Tue, 18 Oct 2022 21:44:37 GMT

I tried this and then received an error message for the first time indicating the x64 driver wasn't installed. Perhaps, because I was doing so many uninstalls/reinstalls/silent installs, etc., I managed to forget to reinstall the x64 driver first.

At the end of the day, it's "working" but is painfully slow.

Re: Still having problems with 3.0 and Excel

AmberTobin — Wed, 19 Oct 2022 13:38:18 GMT

Hi Todd. I had the same problem and now have both drivers installed. Now ArcMap crashes when I try and open an Excel file despite working fine before I installed the x64 driver. I'm wondering if you have ArcMap installed too and have the same issue?

Re: Still having problems with 3.0 and Excel

ToddFagin — Wed, 19 Oct 2022 13:40:50 GMT

I work on several different computers (desktop and laptops) and encountered this issue both where ArcMap was installed (desktop) and not installed (laptop).

I do not use ArcMap much anymore, but I will give this a test sometime today to see if it crashes on me, as well. I think I have 10.8 installed (but will need to double check).

Re: Still having problems with 3.0 and Excel

RM22 — Sat, 29 Oct 2022 01:32:37 GMT

I am having the same issue. I have reinstalled the x64 driver twice and rebooted but still no luck. Also, when trying to add the excel table, ArcGis Pro (version 3.02) keeps spinning, and if I cancel the upload it goes into a weird status. Everything is greyed out in the menu, and cannot even save and/or exit the file or the program. At that point, I can only kill the task from the task manager. I also do have ArcMap but not the x32 driver installed.
Would greatly appreciate any help/suggestion of what else to try. Getting highly frustrated and annoyed by the time wasted with no pop-up window or any other type of indication of the error.
Many thanks in advance -

Re: Still having problems with 3.0 and Excel

RM22 — Sat, 29 Oct 2022 15:37:54 GMT

I am not sure if this is of any help, but I managed to make it work by saving the excel table with the earlier excel version and splitting the original excel table into two smaller-size files. The tables uploaded. However, ArcGIS Pro keeps crashing now after the multiple x64 drivers reinstall and reboot the PC! hurray!
The joining of the table to the shapefile isn't working yet; that is my new headache!

Re: Still having problems with 3.0 and Excel

RosialineRoedel — Fri, 01 Sep 2023 21:19:40 GMT

I am also having issues with Excel in ArcGIS Pro 3.x. I`ve installed Microsoft Windows Desktop Runtime - 6.0.5 (x64) but when I try to import an excel table the program keep spinning and it does not work.

Re: Still having problems with 3.0 and Excel

RosialineRoedel — Fri, 01 Sep 2023 21:37:14 GMT

After install x64 Microsoft Access Database Engine the problem was solved.