ArcGIS for Excel 2024.2.0.0.28 - ‘What hasn’t changed?’ Change log

[ShannonCardoza]

Our exceptional and most extraordinary update yet for ArcGIS for Excel 2024.2.0.0.28 has new features, improved functionality, and an excel-lent new user interface. It is an entirely new user experience that will hopefully blow your mind!  

New Features: 

The latest update of ArcGIS for Excel introduces spatial filtering and navigation tools as new features. 

• Spatial filtering – is an analysis function that compares two layers to match specific input spatial criteria and generate a result layer. 

Select Analysis option and create spatial filter 

Next, Select Layers and Filter type 

• Navigation tools – Set a home or map extent or add a bookmark  

Click to Set home extent or Lock map extent 

To add a new bookmark, simply select the new bookmark shortcut   

This update also fixes several bugs related to languages.  Additionally, to make mapping easier, we have redesigned the following: 

• Getting Started pages 
• Function builder 
• Improved error messaging  
• Tooltips 
• Symbology 
• Share and export 
• Selection  
• Buffer 
• Infographic cards 
• Analysis tools 
• Add from ArcGIS 
• Layer properties 
• Full-screen view option 
• Fixed multiple language issues 
• BUG-000150596 If values are filtered out, they are visible again in the map when opened again in ArcGIS for Excel 
• BUG-000165203 ArcGIS for Excel method 'Filter sheet' throws error 'The object path isn't working for what you're trying to do.' 

Example: 

• Redesigned Getting Started pages 

• Redesigned Function builder 

• Selection 

• Buffer 

• Export 

Quality of mapping: 

• Enhanced geolocator and geocoding functionality. 
• ENH-000160820 Allowing ArcGIS for Excel to retain the changes made in the application even after updating the layer. 
• ENH-000160946 Unable to view the records from the related table of a feature service in ArcGIS for Excel. 

Updates should be seen at once. If you do not see the changes, you may need to refresh or close Excel and restart it. 

On behalf of my team, we would love to hear your thoughts on the update, so feel free to leave your feedback in the comments section of the blog post about the update. 

Till next time! 

[dcallaghan]

This is great 👍
I'm increasingly encouraging my non-GIS savvy colleagues to explore their spatial data in ArcGIS maps in Excel - these changes look like a significant improvement in usability.

Question:

Can you show more about "Spatial filtering – is an analysis function that compares two layers to match specific input spatial criteria and generate a result layer" please? In a short screen record like the others?

[ShannonCardoza]

Good morning @dcallaghan Thank you for the positive feedback. It is much appreciated 😊 As requested here is a short clip of Spatial filtering - 

In this hypothetical example, I have 1 Excel added layer and 1 ArcGIS added layer. The Excel data are Lotto winners and the ArcGIS layer is the districts the winners may elect to purchase. The Spatial filtering result layer selected the nearest housing district in which someone may considering purchasing. 

Once the analysis is completed, if you select 'Show layer details' a new web page will open to the item  in your organization. 

Hopefully this was helpful! Let me know if you have any further questions/inquiries.

-SC