2025 is Refreshing

[ShannonCardoza]

Welcome ArcGIS for Excel Community!

What is one common task we do in the computer information or mapping industry; we are told to do this as basic troubleshooting or to apply the latest updates. If you guessed REFRESH, you are correct! It is more common than not to refresh a web page, refresh our map, or refresh to sync our data.  

Refreshing ensures that all the changes, updates, and modifications made by others are reflected in the current view. It helps to maintain consistency and accuracy, which are crucial for data integrity and decision-making. Additionally, refreshing can prevent potential conflicts and discrepancies arising from working with outdated information. 

Here is everything you need to know about the ‘refresh’ features in ArcGIS for Excel and how the workflows are defined. 

What can we refresh? 

Layer refresh can be found under the Layer Properties tab. Toggle layer refresh on to automatically refresh the layer. Here you can manage settings and refresh intervals for live data layers, for example, live traffic. 

The map refresh or Sync with ArcGIS can be found under the Map Data tab. You can sync the ArcGIS Online or ArcGIS Enterprise attribute table with the connected table in Microsoft Excel, as well as Sync pivot tables. 

 It's important to mention that as you add a data layer to a map, the information added to the worksheet will refresh the map to load the new data. 

Conclusion 

In conclusion, the refresh features (map and layer) in ArcGIS for Excel provide a seamless and efficient way to keep your data and maps up-to-date. These tools enhance workflows and ensure that your visualizations are always accurate and current. 

[ShareUser]

Thanks for refreshing my memory on excel, and helping me to learn about ARCGIS.online....

[DougBrowning]

I have no Map Data tab at all?  @ShannonCardoza 

[ShannonCardoza]

Good afternoon, @DougBrowning,

Thank you for the question! The map data tab will be 'activated' or 'appear' based on the data in the worksheet. See my interactions in A4E in this short video - 

Let me know if this matches your experience (fingers crossed).

Best,

SC

[DougBrowning]

Oh well I was really just looking for a refresh button.  How do I do that to update the table in excel?

thanks

[ShannonCardoza]

Hi @DougBrowning, so under the Map data tab, you have some options. Sync updated rows between your spreadsheet and the portal attribute table hosted in ArcGIS Online or ArcGIS Enterprise using Sync with ArcGIS. 

I think this is what you were referring to but if not then you have found the correct blog to review for layer/map refreshing! To Add or Edit data, this blog maybe helpful.

All the best, 

SC

[DougBrowning]

Yes that is the button but the issue is I have no Map Data tab show up.

How do i get it to turn on?  thanks

[ShannonCardoza]

Hello @DougBrowning , you have to highlight the row of data. 

Hope this helps (and works)!

Best, 

SC

[DougBrowning]

Still no.  Not sure what is up

[ShannonCardoza]

Good day @DougBrowning, that's interesting! Does layer exists in the TOC (the same layer is in TOC that I see in the map from your screenshot)?

One other mention to try is delete and re-add the layer, then check if the Map Data tab is there. If so, save and close the spreadsheet, reopen and see if the Map Data tab is still there?

-SC

[DougBrowning]

Thanks but done all of that several times already.   Tried multiple computers as well.  Not sure what is up.  So close.  Thanks