Excel spreadsheet update not updating in PRO

4768
13
06-03-2020 02:09 PM
JeanetteHarlow1
New Contributor III

When I update and save an xlsx sheet, the changes are not reflected in Arc GIS PRO.  Does anyone else have this problem?  Has anyone  found a specific method to making the changes reflect?

I usually have to turn off PRO and then restart the program for the changes to be reflected.  That said, recently I noticed that even turning off the software and restarting that the changes don't reflect in PRO.

Please note, I make the change in excel.  I save the file.  I close Excel.  

In PRO I remove the old sheet from the Contents pane and refresh the homefile the spreadsheet is in.  I also refresh the folder the spreadsheet is in.  And I do this in a variety of order.  

It also seems that just being patient does not work.

I have had this problem for many PRO versions and currently am running 2.5.0

13 Replies
LisaSenn
New Contributor

Simply version up your filename, so it cannot figure out it's the old one with minor changes!!! 😄 

ValerieZimmer
New Contributor

Still no solution for this?  Really?

 

 

EmilyGriswold
New Contributor

Agreed, this is mind boggling. There are very valid reasons for working from Excel, and Refresh should do just that. 

0 Kudos
Bud
by
Notable Contributor

I've seen the same issue in Pro 3.2.1 very recently. I refreshed the Excel file in Catalog, but it had no effect. The edits I made to Excel did not appear in the attribute table in Pro.

However, I tried testing it again just now (3.2.1), and couldn't reproduce the issue. Refreshing in Catalog worked. So that's interesting.

Video:


By the way, if you want Esri to change functionality like this, I think you'd have better success posting an idea, rather than commenting on it in a question. Or submit a case to Esri Support and ask them to report the issue as a bug.