I am using the following;
Microstation V8i
Excel 2010
Windows 7
Issue:
I have linked and embedded excel workbooks into a 2D sheet in Microstation. I am wondering if it is possible to change the number of rows or columns after it has been placed or if I will have to detach and re-attach the link every time?
For example, I currently have 19 rows, I want to add in another row to have an even 20, is that possible? Or, I have 20 rows and I want to remove one so only 19 rows show up in Microstation, is that possible?
Taylor2357
in MicroStation select Edit>DDE Links... in the Dialog box, select the entry you want to change, then poke Edit Link... this should show Program: Topic: and Item... the Item shows the Row and Column Range, which you can edit... the the Column and Row are swapped and Columns use numbers instead of letters, so range A1:A10 will show as R1C1:R10C1... if you modify it to R1C1:R11C1 then hit OK it will update the link to display the extra row.
Brent
Answer Verified By: Taylor2357
Greg Smith
Microstation 10.17.01.058
Opinions expressed are my own and not necessarily those of my employer
Unknown said: However, with a rider, the main reason I use LINKED spreadsheets is so that Engineers have access to design data in the Drawing without needing a copy of Microstation.
Why not have Bentley View installed across your engineering group then engineers can read print and measure any cad file they want...
Its free and can be rolled out with a distribution install by IT very easily .... can even have your workspace custom settings for fonts, and level standards etc...
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
but if they delete or rename a spreadsheet mstn cant use the update link and your endanger of loosing the data arent you..?
Thats why I prefer the embedded method as they cant delete or edit the excel I want to use in my DGN ( without using mstn full version)
and I publish the dgn instead also when I send the dgn to external client it has the excel inside it ..
But there is no wrong or write method or even better or worse all the methods have their advantages and disadvantages..
And unfortunately the auto update menu of excel in mstn without manually forcing the links does not and has never has worked its a mistake in the menu or a glitch..
So this led me to adopt the embedded methodology as well as I have had 3rd party move/ rename / delete the linked excel file so I've been burned a few times...