Select to view content in your preferred language

ArcGIS Pro Table to Excel not working

421
8
2 weeks ago
JoeyAbalos
Emerging Contributor

Hello Esri Community,

I need your assistance with ArcGIS Pro as I could not user the function "Table to Excel" when trying to export project. 

I am currently using ArcGIS Pro version 3.4 and getting the following error message:
Error 000574: Python is not installed 
Error 000600: Cannot delete "the file path which is in OneDrive". It is being edited by the application.

I have performed a clean reinstallation as suggested on this link, but the issue persists.
reference: Install and Setup | ArcGIS API for Python | Esri Developer

Kindly advise on how I can resolve this. Thanks!


 





 


0 Kudos
8 Replies
ChrisUnderwood
Esri Regular Contributor

Hello @JoeyAbalos 

It might be worth double-checking the Drivers you have installed, or may need to install. 

https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.ht...

 

ChrisUnderwood_1-1758701450646.png

 

0 Kudos
JoeyAbalos
Emerging Contributor

I did install the following MS Access Datable Engine 2016 Redistributable 64-bit driver and both .NET Desktop Runtime 32/64 bit. I still get the error message.

I have attached the error message received. 

0 Kudos
ChrisUnderwood
Esri Regular Contributor

It's not clear where the Calculate Field in your screenshot fits into the Table To Excel problem, but Calculate Field can use an Expression Type of Arcade rather than Python. Does that allow you to workaround the problem ?

0 Kudos
DanPatterson
MVP Esteemed Contributor

redirect the output to a local drive, not a Onedrive destination,

do the errors still appear?


... sort of retired...
0 Kudos
JoeyAbalos
Emerging Contributor

Thanks for the response.

I tried saving the file in C:\ drive but getting the same error message. 

0 Kudos
DanPatterson
MVP Esteemed Contributor

How To: Perform an ArcGIS pro Soft Reset

How To: Perform a Clean Uninstall and Reinstall of ArcGIS Pro

or Tech Support  are your options, especially the python not installed error suggests a larger issue is at hand


... sort of retired...
0 Kudos
JoeyAbalos
Emerging Contributor

Hello Dan, I tried the above recommendations, but the issue persists. Unfortunately, tech support could not help with our case as we are a non-profit organization. If you have any other recommendations that I could try, I would very appreciate that. 

Thanks for all of yours inputs so far!

0 Kudos
DanPatterson
MVP Esteemed Contributor

If you aren't working with onedrive and only have the version of python installed by Pro, then I am out of options (other than try another machine).

It is either your data or your installation.  Sorry


... sort of retired...
0 Kudos