Pro not reading changes to Excel file after being read.

379
7
10-02-2021 12:56 PM
DavidPike
MVP Frequent Contributor

Hi,

Pro 2.8 - excel file being read by Pro doesn't show edits made to the file after being read by Pro.

refreshing folder connection or removing and re-adding to TOC also does not work.

 

I can of course work around the issue, but it wastes time and is a source of frustration.

Excel spreadsheet update not updating in PRO - Esri Community

Any new workarounds other than renaming a version or closing and reopening Pro?

Also does anyone know if this is being worked on as an issue or a fix is in the pipeline? 

Thanks.

0 Kudos
7 Replies
JayantaPoddar
MVP Esteemed Contributor

Instead of XLSX, is it possible for you to work with CSV? Then the changes made to the CSV (even using MS Excel) should reflect if I simply close and reopen the table from Content.



Think Location
0 Kudos
DavidPike
MVP Frequent Contributor

Hi Jayanta,

That's useful to know, will try CSV instead and see if that's a better experience.

0 Kudos
DanPatterson
MVP Esteemed Contributor

table to excel

edit

excel to table (new name) or table to table (Table To Table (Conversion)—ArcGIS Pro | Documentation ) for csv etc

Pro isn't supposed to be a way to edit excel files


... sort of retired...
0 Kudos
DavidPike
MVP Frequent Contributor

Hi Dan,

In this case it's edits made in MS Excel.

In your reply to Excel spreadsheet update not updating in PRO - Esri Community

you kindly shared this link

 Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

And from this I now doubt esri have it classed as a bug, and is rather an accepted limitation.  It would be nice to see a fix in the pipeline however wishful that may be.

0 Kudos
DanPatterson
MVP Esteemed Contributor

I wouldn't count on Excel being cajoled into being a defacto method of working with data for Pro.  What has already been mentioned above by many before is the route to take.  If people can enter data in Excel, they can also enter data in a table in Pro... at least you can't enter text in a numeric field and blank cells more or less have some meaning ( The solution to <null> in tables - Esri Community ).


... sort of retired...
0 Kudos
DavidPike
MVP Frequent Contributor

It probably is defacto already, unless you mean something different.

If it's something which has been mentioned many times before, to me that would indicate a lack of expected functionality.

If people can enter data in Pro, then people can enter the data in Hex, if people can enter the data in Hex...

It's not a useful argument imho as it's my belief that in most tasks, there's going to be a balance of expediency and effort against best practice.

The world will keep spinning if the issue isn't addressed, and I will also lose little sleep over it. 

0 Kudos
curtvprice
MVP Esteemed Contributor

If one really needs this workflow, XTools Pro has implemented a method to edit attribute tables in Excel in their add-on software.  They handle all the export, update, refresh behind the scenes for you... pretty amazing coding IMHO!

0 Kudos