×
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

SW/Excel link

SW/Excel link

SW/Excel link

(OP)
Has anyone know how to link cells in Excel to dimensions or numbers in SolidWorks
I created a calculation sheet in SW dwg.(req'dmt)and I have to do Cal. and fill in all results in to that sheet.
It's will be much faster if I can link from Excel

Thanks

Ben

RE: SW/Excel link

If your talking about linking Dims in parts to DT then yes. Insert a DT into your model and double click the dimension that you want in your DT, etc... This works for Assemblies as well. But you can't insert a DT into a Drawing. You can insert an Object (Spread Sheet) into a drawing though.

Regards,

Scott Baugh, CSWP
3DVision Technologies
http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
When in doubt, always check the help

RE: SW/Excel link

Have not tried this, but logically it should work.
If you do need both a Design Table driving the part and the same spreadsheet inserted into your drawing you should be able to use an external Excel file for the DT.  Then you can use it for both purposes.

Note also that since embedding or linking OLE objects in a drawing should follow standard OLE rules, you coulr have multiple sheets in the Execl spreadsheet.  The FIRST sheet will always have to be the DT (currently with SW2003), but you should be able to link any subsequent sheet into your drawing.  That would enable you to have different content or appearance to the two sheets and any cell calcs or links between the sheets.

Give it whirl and lets us know how it goes.

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