topic Refresh data from a joined spreadsheet in Mapping Questions https://community.esri.com/t5/mapping-questions/refresh-data-from-a-joined-spreadsheet/m-p/739833#M7978 <HTML><HEAD></HEAD><BODY><SPAN>I have joined an excel spreadsheet to a polygon feature class. The data in this spreadsheet changes based on a model we are running in Excel. I would like to have GIS show updated data when I update the model withouth having to break and re-form the join each time. </SPAN><BR /><BR /><SPAN>Is there a way to do this? I have tried refreshing the data, but it does not seem to empty the copied values and refresh joined attributes.</SPAN><BR /><BR /><SPAN>Thanks for any help you can provide</SPAN></BODY></HTML> Tue, 12 Jun 2012 14:39:32 GMT MikeBeyer 2012-06-12T14:39:32Z Refresh data from a joined spreadsheet https://community.esri.com/t5/mapping-questions/refresh-data-from-a-joined-spreadsheet/m-p/739833#M7978 <HTML><HEAD></HEAD><BODY><SPAN>I have joined an excel spreadsheet to a polygon feature class. The data in this spreadsheet changes based on a model we are running in Excel. I would like to have GIS show updated data when I update the model withouth having to break and re-form the join each time. </SPAN><BR /><BR /><SPAN>Is there a way to do this? I have tried refreshing the data, but it does not seem to empty the copied values and refresh joined attributes.</SPAN><BR /><BR /><SPAN>Thanks for any help you can provide</SPAN></BODY></HTML> Tue, 12 Jun 2012 14:39:32 GMT https://community.esri.com/t5/mapping-questions/refresh-data-from-a-joined-spreadsheet/m-p/739833#M7978 MikeBeyer 2012-06-12T14:39:32Z Re: Refresh data from a joined spreadsheet https://community.esri.com/t5/mapping-questions/refresh-data-from-a-joined-spreadsheet/m-p/739834#M7979 <HTML><HEAD></HEAD><BODY><SPAN>When you join an Excel table to layer, an Excel spreadsheet is locked to write so you cannot save changes if ArcMap is running.</SPAN><BR /><BR /><SPAN>Try to save your ArcMap project, exit ArcMap and then run your Excel model and save spreadsheet. </SPAN><BR /><SPAN>When you open your ArcMap project, values from the joined Excel table should be updated.</SPAN></BODY></HTML> Wed, 13 Jun 2012 05:51:49 GMT https://community.esri.com/t5/mapping-questions/refresh-data-from-a-joined-spreadsheet/m-p/739834#M7979 MarcinGasior 2012-06-13T05:51:49Z