topic Re: ArcGIS Pro can't find an Excel worksheet, freezes/hangs in ArcGIS Pro Questions

ArcGIS Pro can't find an Excel worksheet, freezes/hangs

Matt-Goodman — Wed, 19 Oct 2022 13:21:54 GMT

I quickly found a workaround, but am so frustrated with the fact that ArcGIS Pro can't seem to to 'see' an Excel worksheet through the "Add Data" dialog. When I click into the workbook (xlsx), the dialog just spins and spins and spins....then canceling or closing down the application often requires an "End Task" in the Task Manager.

Things I've tried:
- check the Excel workbook for correct formatting (there are only two simple columns, both named with text names and containing simple integers).

- tried both .xlsx and .xls

- tried moving the Excel file to a different location in the directory

- tried updating ArcGIS Pro 3 to the latest patch (3.0.2).

- tried rebooting the computer

- while Pro was spinning its wheels, I launched ArcMap (10.7) and added the Excel worksheet without issue

Anyone else experiencing this?

Attached: .xlsx file

Re: ArcGIS Pro can't find an Excel worksheet, freezes/hangs

Robert_LeClair — Tue, 18 Oct 2022 21:18:01 GMT

Matt - I'm working with ArcGIS Pro 3.0.2 and had no problems loading your Excel file using the Add Data button or via the Catalog Pane. I'm wondering if you have the necessary drivers for Excel to work properly in ArcGIS Pro?

Re: ArcGIS Pro can't find an Excel worksheet, freezes/hangs

Matt-Goodman — Wed, 19 Oct 2022 14:35:08 GMT

I've confirmed:

Running Office 365, v.2209, click-to-run, 32-bit
have MS Access db engine 2016, 32-bit, silently installed
have .NET Desktop runtime 6.0.5.31215 x86, silently installed

The weird thing is, I've been on ArcGIS Pro 3.x since July (3 months now) and haven't had any issues with Excel tables until the last week or so.

Re: ArcGIS Pro can't find an Excel worksheet, freezes/hangs

Robert_LeClair — Wed, 19 Oct 2022 20:43:35 GMT

Matt - I think the problem is you're running the MS Access DB engine 2016, 32-bit versus the 64-bit driver. You can learn more about this and other Excel solutions here.

Re: ArcGIS Pro can't find an Excel worksheet, freezes/hangs

LuisLaredo — Thu, 27 Oct 2022 05:13:08 GMT

Hello,

I agree with Robert above. Pro would use the 64bit version of Access DB engine. When we've 'packaged' ArcGIS apps for our organisation, we've had to include both versions for Pro and Desktop users. Since Microsoft 365 came about, it became a bit of a problem because of compatibility with the Standard Operating Environment.

Having said all this, in our testing, we have seen cases where people in our team, with seemingly identical setups, would be successful and not when trying to open an Excel file in ArcGIS Pro. So in the next version, we'll be including both 32bit and 64bit versions of ADE and save ourselves the trouble.

. Luis