https://communities.bentley.com/members/a10db34a_2d00_b3d2_2d00_4c28_2d00_9bff_2d00_449840774a43Recent activity for people in Roberto Rodriguez's communityen-USTelligent Community 12https://communities.bentley.com/products/microstation/f/microstation-forum/195389/link-a-cell-from-an-excel-file-to-a-new-property-definitionSun, 12 Apr 2020 12:04:47 GMT6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:ab6d061b-41df-4915-b0ee-4d537b016501Roberto Rodriguez<p>Hello,</p> <p></p> <p>I have created a spread sheet in excel with the properties of some items.</p> <p>In Descartes I created an item type library with item types and properties definition.</p> <p>I am wondering if there is a way to link the cells from the spread sheets to the properties definition in a way that if I have a value in the spread sheet this is linked to the properties definition automatically in a way I just need to update the spread sheet.</p> <p>For example if the property in the spread sheet excel file for purchased date is 20/04/2019 and I have to change it to a different value like 12/04/2020, if that is updated automatically in the descartes item properties.</p> <p><br />Thanks</p> <p>Regards</p> <p>Roberto</p><div style="clear:both;"></div>https://communities.bentley.com/achievements/460ac7df-7ccc-4c42-a204-9e05eef3be09Sat, 28 Mar 2020 05:06:07 GMT6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:edf3dee5-97c7-461f-8b73-ac8de2dc06c0Ask a question in a forum.