Workflow for updating excel table

[LeoLadefian1]

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]

Howzit

Source your locational-aware data from a database table,
Add the Database table to Excel through ODBC,
Add excel (lontigude and latitude) data to the embedded map in Excel,
Refresh and Refresh All will dynamically update both Excel and the Map layers,


It means, you only need to add the table once and the map layer once.

Susan

[LeoLadefian1]

Thank You!

This was very helpful, now I assume I should be updating the access database with new information?

[SusanJones]

Yeah, you will need to be updating the data source directly. ie the Database Table stored in with sqlserver, oracle, ms access etc

Excel is the end user client. You can schedule the data source to be refreshed from within Excel.
In summary, store the data external to Excel and office, if possible - we need to get away from standalone excel data files.

We use this for viewing the locations from Google Analytics. We refresh data once a day in MS Sql Server. Excel reports and ESRI Maps for Office do the rest.

Susan

[AndrewHargreaves]

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

[SusanJones]

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

[SusanJones]

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