Excel stops responding when sort by State and Style by County but has a space in front of State in the data.
Last Published: October 8, 2015Esri Maps for Office
Bug ID Number
July 31, 2015
November 3, 2022
Esri Maps for Office
Operating System Version
7.0 64 Bit
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
In the dataset provided, there are 3222 valid features that you can add to the map.
Adding this entire dataset to the map as a layer will add 3222 polygons on to the map.
This is very heavy and will take a very long time to draw. It might seem like excel is crashing during the drawing process.
if you wait, all polygons will be added to the map.
It is recommended to aggregate rows when adding large data sets - especially polygons.
Ensure there is not a space in front of the State Names in Excel.