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
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
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
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.