Workflow for updating excel table

Question

I have an excel table with Lat Long coordinates among other columns.  I'm trying to create a workflow where I can update the table, add new rows and edit fields, and update the layer in arcgis online.  However the update layer button doesn't seem to be working when I add a new Lat and Long and fill out the fields.  It simply overwrites the service.  Any ideas?

SusanJones · Answer

... and don't forget to set the refresh interval in ArcGIS Online.

SusanJones · Answer

Please look at the Connection Properties for the data source from Excel. Get the option from the Refresh All button.

Attached is a small screen shot of the dialogue box inside of Excel.

The map inside of Excel will then update itself when the data source is updated.

Just to reiterate, We are not making a copy of the data inside of Excel, just linking to the table.

Susan

refreshDataSource.JPG

AndrewHargreaves · Answer

Excel is the end user client. You can schedule the data source to be refreshed from within Excel.

Hi,
can you expand on this some more - how do I schedule Excel, and specifically Maps for Office, to update my shared layer with ArcGIS Online?

Thanks