In AutoCAD displays a cell , linked with Excel.
If simple text is entered in Excel, then the link works.
If the in cell is complex formula, such as = VLOOKUP (cell reference to another file) -- there is no connection.
and
If the cell is present the simplest formula, for example = UPPER (cell reference in this file) -- there is no connection.
Autodesk, this problem has dragged on for many years. When you decide this simple problem? You are trying to do the job,
which have been implemented Microsoft. Do not need to count! Take only the value , which already considered other team!
Why communication is implemented only in the tables? I do not need the table. Fields - quite a handy tool with many features. Esport tables drawings useful thing, but calculations made by the party sotf, they least important for summary information on the drawing.
I do not need your Cloud, I need a reliable connection AutoCAD with other brands. You will not catch up with Excel. Every leader in its area.
Solved! Go to Solution.
Solved by JDMather. Go to Solution.
What field?
Architectural? Mechanical? Civil?
What specialty of work?
Architectural? Mechanical? Civil? Other?
Can you answer this direct question? (4 possible answers)
The ScreenShot is done in AutoCAD 2015. Student work.
@seregadushka wrote:
The ScreenShot is done in AutoCAD 2015. Student work.
This is not the case with some specialization.The proposal to Autodesk.to shift a bit their bearings .
Autodesk has many products - AutoCAD is a base product, a general purpose CAD product.
Perhaps one of the vertical upgrades has the functionality you are looking for.
For example, Autodesk Inventor product used in the manufacturing/mechanical field has very robust embedded or linked Excel functionality and enhanced with iFeatures, iParts and iLogic.
I propose that you might shift your bearings a bit and look at the Autodesk vertical products.
Students can download Autodesk products for free here http://www.autodesk.com/edcommunity , but these products are professional products that deserve (require?) a professional level of preparation. You would probably have to pick a specialized field of study (like mechanical, architectural or civil) because of the significant personal effor required to learn one of these tools.
Violation links to FIELD through MS driver
I noticed , that if you add =""& in the cell before formula Excel , the information is still transmitted from Excel to AutoCAD. But not always. Also one becomes unavailable formatting accuracy of the display in cell of Excel . It is necessary to introduce additional formula rounding precision. This is unnecessary and a serious obstacle.
Link 1 cell to the 1 fields. It is a necessity.
We do not need communication via the table with their huge styles. I do not need to bind large amounts of (all the same you do not pull the connection with the table of this size). I do not want your clouds that you give so much time and effort, and leaves unanswered the question "who will perform the calculation ???" Ten people from the cloud in front of web-cameras with a calculator in hands ???
I need shure the connection, with the new interface, between 1 cell Excel and 1 field DWG !!!
Look at how many people are looking for a solution to this poblemy! There are third-party applications (AutoField -- cadig.com) that do this . The interface presented in AutoCAD, stuck in the 90s. Your table is still not catch up once and Excel will not be able to repeat its functions. You can not make the whole planet to transfer all the calculations projects, consisting of dozens of sheets Excel , interconnected in Table AutoCAD. This is crazy!
1 cell of Excel -- link -- 1 fiels AutoCAD
This is simple of table Excel , in project 3 things like it
Do not think that AutoCAD in the near future can replace Excel
=IF(AND(INDIRECT(ISTOK&"!document")="DIPLOM";ROW()=Tekushaya);INDIRECT("["&ISTOK&"]5!"&IF(RIGHT(CELL("filename";$A$1);1)="P";"J";"K")&215);VLOOKUP(INDIRECT(IF(INDIRECT(mashina&ROW())="--";traktor;mashina)&ROW());INDIRECT(Variant.xls!Bbaza);16;FALSE)*podgon)
This is only 1 cell (N14) from the previous example
This page is in Russian. I have no strength to translate it. If Autodesk want to improve your AutoCAD, then translate themselves. There's a picture 🙂
http://rutracker.org/forum/viewtopic.php?p=68251314#68251314