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.
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.
Hi Jayanta,
That's useful to know, will try CSV instead and see if that's a better experience.
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
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.
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 ).
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.
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!