Excel link not update in Microstation

Question

Dear All, 
 We copy formula to Microstation and when we update something in excel, but in microstation not update , so what happen with this? 
 We have many Microstation files need to update from excel automatic. 
 In Microstation, I went to "Edit Menu"==> "Link" and at " Automatic" Radio Button is gray.. 
 So last way, we update all files one by one and take too much boring!

DavidFradley · Accepted Answer

Are your spreadsheets attached via the Link function? If that's the case, they wouldn't display in Microstation - you'd get a literal link that you could click on that would open your spreadsheet in Excel. So I'm assuming you've got them attached as reference files - in which case, right-click on your spreadsheet via the "Reference Manager" and choose "Reload Reference" after you've made your changes in Excel. That should do the trick.

BruceV · Answer

Dear David, 
 Thanks for your taking care. 
 I am not understand as well, but let me show you some i did and i will as you what is your step abov: 
 This what i did: 
 In Excel, I select "Cell" containing formular and hit copy. 
 In Microstaion ==&gt; Edit==&gt; Past Special==&gt; Embedded Microsoft Excel Worksheet 
 and when i updated something in Excel, it nothing in Microstation. 
 
 here is what i would like to ask you: 
 " in which case, right-click on your spreadsheet via the "Reference Manager" and choose "Reload Reference" after you've made your changes in Excel" 
 
 I am not clear about this, I didn't see " Reference Manager" ... i am sorry about this and if you can make clearly more, it is very great and thanks for your kindness about this. 
 best regards,