×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Using Excel Files

Using Excel Files

Using Excel Files

(OP)
Is it possible to have SW read a specific excel cell? For instance, if I want my pipe thickness to read excel cell A25 and the pipe diameter to read cell J43.
In other words I would like to use one externally linked excel summary sheet to drive multiple part drawings and assembly drawings.

Thanks!  

RE: Using Excel Files

Make a Design table to control your dimensions... works like that, but is much more straight forward. (see help)

Regards,

Scott Baugh, CSWP pc2
www.scottjbaugh.com
FAQ731-376

RE: Using Excel Files

Can you explain what you mean by "excel summary sheet"?

You cannot drive part or assy drawings with an excel file. You can however, drive part or assy models with Design Tables which in turn will drive the drawings.

A Design Table can be linked to an external Excel spreadsheet, and the data used to drive the properties, dimensions, etc of a part or assembly model.

cheers

RE: Using Excel Files

(OP)
OK.. so this is what I did:

1.) I linked my external excel spreadsheet file to my part. The excel file has values which I would like to use to drive my part on random cells. (ex. B2, C18, A4 etc..)

2.) Next, I tried to link a specific dimension in my model to a specific cell in the design table. The procedure I used was:
    a.) selected the SW part to activate the dimension.
    b.) once the dimension was activated, I double clicked
        on it so that I can link it to the cell of my
        choice in the design table.

Here is the error that pops up:

"Server Busy:
This action cannot be completed because the other program is bust. Choose 'switch to' to activate the busy program and correct the problem"

The interesting thing is that SW is the only program I have open. I closed the excel file after I linked it.

Can anyone tell me what I am doing wrong??

Thanks

RE: Using Excel Files

It sounds to me like you may want to read up on Design Tables in the help.  You can't link a dimension to a specific cell.  Design tables are formatted and set up in a specific way.  You can link the correct cell of a properly-formatted design table to a random cell of an external spreadsheet.

RE: Using Excel Files

(OP)
It did not appear you could do it according to "help" section but I just wanted to make sure.

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources