The August 2023 update includes new functionality and enhancements throughout the ArcGIS for Microsoft 365 product suite. Highlights are provided below.
ArcGIS for Excel
- Use the Zoom To or Select tools on the Map Data tab to zoom to or select a specific feature or features on a map from their corresponding row, cell, or cell range in the Microsoft Excel spreadsheet.
- You can now add and edit an ArcGIS Online or ArcGIS Enterprise layer attribute table in an Excel worksheet.
See the Esri Community blog article for more information and a video.
- Use the ENRICHBYADDRESS function to get enriched demographic information about the people, places, and businesses in a specific area or within a certain distance or drive time from an address. The default distance is within a one-mile radius of the point.
- Questions about the pivot table and other subjects are answered in the updated FAQ topic.
- In general, the data types that can be written to a cell are number, text, logical (true and false), or error value. When you type input in a cell, Microsoft Excel automatically detects and assigns the type.
Learn more about data types, formats, and categories
Learn more about comma, decimal point, and semicolon separators
ArcGIS for Power BI
- Basemaps—The Basemap tool is now more intuitive to use. Previously, settings for this tool were managed from the Visualizations pane. Now, when the Basemap tool is turned off and you drag data into a Power BI field well, the Basemap tool is automatically turned on, allowing you to update the basemap. Click Reset to default or turn off the Basemap tool on the Format visual tab in the Visualizations pane or clear the field well to remove the Basemap tool from the map tools.
- Time slider—When you select features on a time-aware layer and run the time animation, only the features visible during the specified time period are visible when playing the animation.
- Additional support, bug fixes, and improvements to the user interface have been made.
ArcGIS for SharePoint
- Use the Reset connection button to reset a connection and remove a map's content or switch your ArcGIS organization connections.
- Use new PowerShell commands to edit ArcGIS connections and control ArcGIS organization access.
ArcGIS for Teams
- Options tab—The Options tab layout in the personal (private) scope installation has been improved.
- Search item types—Additional item types are available to open in ArcGIS for Teams as you search.
- Additional support, bug fixes, and improvements to the user interface have been made.
ArcGIS Connectors for Power Automate
- ArcGIS Connectors for Power Automate now includes the ArcGIS Enterprise connector to access and use certain actions.
- The Find address candidates action now provides multiple results, ranked by match score, containing location information about an input.
- The Find address candidates and Geocode addresses actions now support custom geocoders.