Using ArcGIS 10.2, I am receiving an Excel sheet, on a daily basis, which contains 105 columns(Fields) and includes has X and Y values.
For whatever reason (which I cannot understand) all data types in the sheet were formatted as "Currency" so I run a Macro to change all values reformat the field as:
"@", "0" , "0%" and finally "0.000000" for X and Y column before adding the sheet to ArcMap.
- I use the Add Data --> Add XY Data... method to add the Sheet to ArcMap
- I then Use Data--> Export Data --> all Features to export as a shapefile.
Now after the process shapefile automatically can be added to map I have all points on the map and the table shows all values which were in the Excel file BUT whenever I try to Select Points by Select Feature tool or Select From Table the ArcMap Crashes.
Selecting by Attributes also does not get any Unique values!
And finally after closing the map I am not able to add the shapefile into Map again.
Can you please let me know what may cause such an issue?