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.