topic How to reflect the updates of excel data on a table in a template in ArcMap9.3 ? in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/how-to-reflect-the-updates-of-excel-data-on-a/m-p/189191#M4928 <HTML><HEAD></HEAD><BODY><SPAN>Greetings,</SPAN><BR /><BR /><SPAN>I wonder if there is a way to do the following:</SPAN><BR /><UL><BR /><LI>I have created a template in ArcMap 9.3</LI><BR /><LI>Then I added an object to it and I chose "Create from File" option </LI><BR /><LI>Then I browsed to an excel 2007 file that contains my data as a table and added it to the template</LI><BR /><LI>Now when I update the data on that excel file, the data on the table of the template is not updated directly</LI><BR /><LI>And to update it, I should double click that table to open the linked excel and then close that excel, and then the table on the template is updated</LI><BR /></UL><SPAN>Is there any way to do that using Vb.net code because I can update the content of that excel file but the problem is how to reflect this update directly on that template object (table).</SPAN><BR /><BR /><SPAN>I have tried to refresh the active view but still the template object (table) is not reading the updates from the excel file.</SPAN><BR /><BR /><SPAN>Please advise becuase it is very urgent..</SPAN><BR /><BR /><SPAN>Help me~!</SPAN></BODY></HTML> Thu, 09 Jun 2011 12:03:47 GMT dgesridgesri 2011-06-09T12:03:47Z How to reflect the updates of excel data on a table in a template in ArcMap9.3 ? https://community.esri.com/t5/arcobjects-sdk-questions/how-to-reflect-the-updates-of-excel-data-on-a/m-p/189191#M4928 <HTML><HEAD></HEAD><BODY><SPAN>Greetings,</SPAN><BR /><BR /><SPAN>I wonder if there is a way to do the following:</SPAN><BR /><UL><BR /><LI>I have created a template in ArcMap 9.3</LI><BR /><LI>Then I added an object to it and I chose "Create from File" option </LI><BR /><LI>Then I browsed to an excel 2007 file that contains my data as a table and added it to the template</LI><BR /><LI>Now when I update the data on that excel file, the data on the table of the template is not updated directly</LI><BR /><LI>And to update it, I should double click that table to open the linked excel and then close that excel, and then the table on the template is updated</LI><BR /></UL><SPAN>Is there any way to do that using Vb.net code because I can update the content of that excel file but the problem is how to reflect this update directly on that template object (table).</SPAN><BR /><BR /><SPAN>I have tried to refresh the active view but still the template object (table) is not reading the updates from the excel file.</SPAN><BR /><BR /><SPAN>Please advise becuase it is very urgent..</SPAN><BR /><BR /><SPAN>Help me~!</SPAN></BODY></HTML> Thu, 09 Jun 2011 12:03:47 GMT https://community.esri.com/t5/arcobjects-sdk-questions/how-to-reflect-the-updates-of-excel-data-on-a/m-p/189191#M4928 dgesridgesri 2011-06-09T12:03:47Z