Now, this communication system is working badly. I'll try to explain
1 Be sure to need the ability to create macros and bind to the buttons or keys. Saychas due to a general window "paste special-relationship-sheet excel" and "paste special-relationship-object autocad" can not do this. You just have to divide into different windows. This is used by 200 times a day, every time it is impossible to use menu.
2. Established relationship "special insert-link-object autocad" can not be edited in practice. Usually, all links in the drawing have the same font, style, etc.
3, Table styles and text styles are not related
Often after the update links, which are single-cell table, table styles vozbraschayutsya with the standard, and have to start all over again. No need to display the names of rows and stobtsov in relationships - they close nearby objects, and make it impossible for their joint selection.
4, "The properties of the format" does not work for "a special insert-link-object autocad"
5. The default connection should be editable, but not locked. During configuration, it has to unlock a lot of time.
6. It might be better to create a new "communication style", prone to edit all the links in the drawing, to give and change their common properties.
A little more, what I have been suffering for nearly 3 years
Imagine that the drawing is 100 "special insert-link-object autocad" with the file path1/file1.xlsx
And I needed to change the location and name of the file on path2/file2.xlsx
Try to solve this problem
It is necessary to give more information.
The value of 41.8 in the second figure is the original. Its takes a cell named "urojaynost" from the third file, divide by 10.
The cell contains $J1 "[PerspPortyanko.xlsx]Sheet1!" This file name and sheet.
The purpose of the function of indirect forwarding =INDIRECT(CONCATENATE ($ J1;"urojaynost")) to result from a direct link [PerspPortyanko.xlsx]Sheet1!"Urojaynost", which is the number of 4.18.
This is the result, which should be transferred and AutoCAD.
Communication with Excel, as an object of autoCAD, gives an error #REF.
I apologize for such a complex example, it is difficult to understand without a bottle.