By dwight


2019-02-08 14:57:43 8 Comments

I load an xlsx file into ArcGIS Dektop 10.6.1, and realize I didn't have headers in my xlsx so I need to go back and add those. I close everything since ArcGIS locks xlsx files down and won't allow editing. I update the xlsx in Excel and save my changes. Restart ArcGIS, new project and load the updated xlsx. In excel, I can see my new edits. In ArcGIS, its still showing me the old version of my file.

My workaround is to save the xlsx file with a new name, but that does not really suit my workflow.

Can I force ArcGIS Desktop to recognize changes to the original xlsx file?

1 comments

@squirrel72 2019-02-12 01:22:33

This happens in 10.5.1 as well. The Office 2007 driver suggested in GeoNet help from ESRI does not help much, as it is no longer available to download. The tables in shapefile are dBASE IV which is, again, not much help.

You can export to .csv, .dbf, or save backwards to .xls or Excel 97-2003 using Excel. I will try this with 10.6.1 and Office 2019 at home. At the office I have O365/2016 and 10.5.1.

Related Questions

Sponsored Content

0 Answered Questions

1 Answered Questions

[SOLVED] ArcMap keeps loading old CSV file after I've updated it

1 Answered Questions

[SOLVED] How to fix Excel/Arcmap "data type mismatch" error?

1 Answered Questions

2 Answered Questions

[SOLVED] Multiple Users Accessing Same ArcSDE File?

0 Answered Questions

ArcGIS stops responding during Georeferencing Save?

1 Answered Questions

[SOLVED] Existing graphics in ArcGIS have limited functionality

1 Answered Questions

1 Answered Questions

[SOLVED] Delete records from table using ModelBuilder

Sponsored Content