topic Re: ArcGIS Pro 3.0 won't open projects with joined excel files in ArcGIS Pro Questions

ArcGIS Pro 3.0 won't open projects with joined excel files

B_Brooks — Fri, 29 Jul 2022 18:53:29 GMT

I upgraded to arcgis pro and had a few issues with opening excel files initially. Someone said to make sure I installed the .NET Desktop runtime - did that. someone said to upgrade the access driver. I did that. Still I have a project that has an excel file joined in the map and it won't ever finish loading the project. When I look at the task manager, the "ExcelToSQLite64.exe" seems to be where the hang up is.

Any other weird packages I need to install to get this software to work?

~Brandon

Re: ArcGIS Pro 3.0 won't open projects with joined excel files

George_Thompson — Fri, 29 Jul 2022 19:01:45 GMT

Be sure to review this doc: https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm

I have seen this help many people. It came from here: https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm

Re: ArcGIS Pro 3.0 won't open projects with joined excel files

B_Brooks — Fri, 29 Jul 2022 19:14:06 GMT

Thanks George! I'll keep trying. My IT department doesn't allow anyone to have admin rights, so every attempt to fix requires an additional20 minutes, which makes this extra aggravating. I just want to run my analysis. 🙂

Re: ArcGIS Pro 3.0 won't open projects with joined excel files

AdrianaAbramovich — Fri, 29 Jul 2022 19:33:22 GMT

I recommend:

* Open the project backup version and remove the excel file from the Map
* Upload the excel file to a new map. Open the geoprocessing tool, then convert the excel to a table.
* Lastly, add the table to the map.
Adriana

Re: ArcGIS Pro 3.0 won't open projects with joined excel files

RhettZufelt — Fri, 29 Jul 2022 19:39:39 GMT

If you have ArcMap installed on the same machine, will need to install both the 32 and 64 bit versions of the .NET Desktop runtime and the Access driver.

Re: ArcGIS Pro 3.0 won't open projects with joined excel files

B_Brooks — Mon, 01 Aug 2022 14:25:31 GMT

Thanks for the suggestions everyone. Nothing is working yet. I haven't even seen ArcMap in 6 years, so not worried about that. There is no backup. I'm gonna try and create a new project and hopefully load all the data I need from the side.