laptop and a wrench

Bug

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, 2015 Esri Maps for Office
Bug ID Number BUG-000089563
SubmittedJuly 31, 2015
Last ModifiedNovember 3, 2022
SeverityMedium
Applies toEsri Maps for Office
Version found3.1
Operating SystemWindows OS
Operating System Version7.0 64 Bit
StatusNon-Reproducible

Additional Information

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.

Workaround

Ensure there is not a space in front of the State Names in Excel.

Steps to Reproduce

Bug ID: BUG-000089563

Software:

  • Esri Maps for Office

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback