Jump to content

Can you link excel cells to dimensions?


Recommended Posts

Currently i have an excel spread sheet that automatically generates pipe details (length's etc) and a separate drawing with a general code illustrating which dimension links to what part.

 

I want to combine the two so they cant be misread but not have to manually duplicate text. Does anyone know a way?

 

Thanks

 

Kelly

Link to post
Share on other sites

If i am understanding your issue correctly, then you would want to utilize DATALINK, TABLE, and FIELD...

the datalilnk and table are pretty self explanitory, but using fields to display dimensions from your table will take some explanation...

 

Once you make your TABLE from your datalink, creat your dimension, invoke FIELD, choose formula, then choose the cell option. Click on the cell that holds your dimension data and copy the field expression into the text override of the dimension and you should be set

Link to post
Share on other sites
chelsea1307

just a question for you, what happens when you close out of the drawing and re-open it do either of your fields work? Ive tried the copying of field expression before and it would not work after a dwg was close and openned again

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...