Excel Spreadsheets on a drawing
Excel Spreadsheets on a drawing
(OP)
I am having issues pasting an Excel spreadsheet on a drawing. The spreadsheet is a list of about 100 bill of materials items. When I paste it on the drawing, the list gets cut off at about Item 45. When I double click on the list in the drawing, the Excel sheet still shows all 100 items. Why would only 45 items show up on the drawing?






RE: Excel Spreadsheets on a drawing
RE: Excel Spreadsheets on a drawing
RE: Excel Spreadsheets on a drawing
Save yourself a load of time and hassle and try the SW BOM. I'm betting you will be pleasantly surprised. And I'm willing to bet that the (ex-ACAD ?) person who told you to stay away from it will also (begrudgingly) be surprised.
IMO, using a manual BOM is a ludicrous waste of time with todays MCAD software.
RE: Excel Spreadsheets on a drawing
To echo CBL, 100 items isn't a large assembly. And I would be more afraid of a manual Excel object with 100 entries than I would be afraid of a SW generated BOM with 10000 entries.
Just my two cents. :)
Matt
CAD Engineer/ECN Analyst
Silicon Valley, CA
sw.fcsuper.com
Co-moderator of Solidworks Yahoo! Group
RE: Excel Spreadsheets on a drawing
Ever since we switched from AutoCAD to SW I've LOVED the BOM feature. Probably saves us 4-5 hours a week that used to be spend updating BOMs. Had a few drawings with well over 100 line items. No issues at all, especially in 2006 when they gave you a lot more control over the formatting.
RE: Excel Spreadsheets on a drawing
Cole M
CSWP, CSWST, CSWI, CPDM
SW06
SW07
HP XW4300, 3.4g proc, 2.5g RAM, ATI Fire GL 3100
RE: Excel Spreadsheets on a drawing
Chris
SolidWorks 07 3.0/PDMWorks 07
AutoCAD 06
ctopher's home (updated 04-21-07)
RE: Excel Spreadsheets on a drawing