ArcGIS for Excel 2024.3.0.0.30 - Change log
ArcGIS for Excel 2024.3.0.0.30 - Change log
Calling all my non-GIS savvy friends, my pros, or anyone in between. Our latest release, ArcGIS for Excel 2024.3.0, is jam-packed with a new feature, bug fixes, and quality user interface and user experience polishes. This release is designed to enhance your productivity and make your workflow smoother and more enjoyable. Whether you are a beginner or a seasoned professional, there is something in this update for everyone. We are excited to share these improvements with you and look forward to your feedback.
New feature
Add features to ArcGIS layer workflow:
- Sign into ArcGIS for Excel
- Select Add layer
- Select ArcGIS
- Add a feature layer, the attribute table will be added to a sheet in your workbook
- Select done
You may add a new row in the last row of the table. Please note that the new Add features to ArcGIS layer pop-up window will appear.
Here, you will insert XY coordinates. Please note that the row and Spatial reference are automatically detected and are uneditable fields. If you’d like to undo edits, simply close the Add features to ArcGIS layer pop-up.
A few important mentions:
- Polyline and polygons are not supported
- Editing must be enabled on the feature layer
- To see the results of the added row, log into your ArcGIS organizational account. Select content > select the feature layer > select Data > select table
Sync with ArcGIS:
If a new row/feature was added but would like to remove the feature from the map, you may Sync with ArcGIS under the Map Data tab to return the map to its original state. The point feature is removed in the example below and the map is refreshed.
Custom symbology Workflow:
- Select Style option
- Select Shape
- Select uploaded symbols
- Drag and drop files from the desired file path
Once the symbols are uploaded you can adjust the size and rotation. You can also use the Adjust size automatically check box to adjust the size.
Fixed bugs
- BUG-000163152 Using formulas to populate latitude and longitude values delays the points being displayed on the map in ArcGIS for Excel until manually "reloading" the map
- BUG-000168605 Inconsistent behavior with sync and staying logged in when multiple users are working on a project in the ArcGIS for Excel add-in
- The Update Share map function fails to add the newly added row data into the ArcGIS Layer
- Unable to re-add Excel data
- Selecting a new color ramp affects the feature size on the map
- Selecting cancel option will remove added layers
- Excel Online only - handle pop-up blocking by browsers
- Nested group sublayers fail
- Switching between ArcGIS for Enterprise logins cause ribbon to become disabled
- Map book does not display when workbook is reopened with SSO token expires
- Cut + insert cut cells is not handle properly
- Filter sheet operation failed with ‘invalid SQL expression’
- Adding 500k XY on the map automatically signs user out from the map
- Added Table data: Selecting the 'remove attribute table from the Excel' icon does not remove the table from the Excel worksheet
- Macro script #CALC! error when using ArcGIS Functions.
- The info icon window for data variable list is not opening
- #CALC error when executing macro script with ArcGIS Function builder
Quality of Mapping
- ENH-000160510 Provide the ability to use custom symbology in ArcGIS for Office in Excel
- ENH-000164885 Ability to set a refresh interval for data tables in ArcGIS for Excel
- Add the 'remove all' option when using multiple data sheets
- Implement minimum window size
- Filter does not work if the field name and display name of objectID are not the same
- Warn the user when data is truncated because the text is too long
- Handle pop-up blockers
- Expand group layers when a sublayer’s attribute table is refreshed
- Display loading map dialog when map is in a blank state
- Performance improvement with larger datasets
- Update error and warning messaging
- Improved handling of keyboard shortcuts when navigating the map
Updates should be seen at once. If you do not see the changes, you may need to clear the web browser cache, refresh or close Excel, and restart it. See our FAQ documentation for more.
To verify your version, you may confirm by selecting the ArcGIS tab > Show map > sign in > select Settings > select setting cog wheel > see Current version.
Hot topic
Note: Topic taken from our Esri Community web pages.
Regarding the most recent ArcGIS Online user type updates, this was a concern voiced on our Esri Community forum and recorded as BUG-00017046, the attribute table cannot be accessed when the user's member role is not at least a Publisher. After further research, I can conclude this is not an issue with the user type updates but enabled editing must be allowed on the feature layer being accessed. The user type at minimum needs to be Creator or Professional with a Facilitator or admin role or have custom privileges.
Note: Contributor and Professional user types were previously Editor and GIS Professional.
Till next time
On behalf of my team, we appreciate all the feedback posted on our Esri Community site. Your insights and suggestions are invaluable in helping us improve and deliver a better experience.
With that said, my office is open! I encourage you to send me your success stories, my email is scardoza@esri.com.