nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pro not reading changes to Excel file after being read.

DavidPike

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.

Encontre mais publicações marcadas com

Accepted answers

All comments

DavidPike

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.

danretired

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 ).

DavidPike

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.

DavidPike

Hi Jayanta,

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

danretired

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

JayantaPoddar

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.