×
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

Inserted excel sheet size.

Inserted excel sheet size.

Inserted excel sheet size.

(OP)
Trying to insert a tabulated bom excel sheet into a
drawing. How do I increase the size of the excel sheet
horizontally to show more columns. Dragging it down
to show all the rows doesn't seem to be a problem.

RE: Inserted excel sheet size.

DBl-click the Excel BOM, drag the window size.

Chris
Systems Analyst, I.S.
SolidWorks 06 4.1/PDMWorks 06
AutoCAD 06
ctopher's home (updated 06-21-06)

RE: Inserted excel sheet size.

(OP)
Been tryin that...like I said, I can get all the rows to
show, but when I drag across, the window just "scales" and
doesn't show any additional columns. I admit I don't import
OLE's into drawings much...could it be a setting in the
excel file I'm missing...?

RE: Inserted excel sheet size.

Check the Help file for design tables > in drawings and follow the Related Topics for displaying and editing.

Basically you have to prepare the spreadsheet in Excel and then insert into the drawing.

cheers
Helpful SW websites  FAQ559-520
How to get answers to your SW questions  FAQ559-1091

RE: Inserted excel sheet size.

There is a limitation to the size of OLE you can have in SW. See the KBA at www.solidworks.com there you can find information that might help you fix the issue.

Regards,

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

RE: Inserted excel sheet size.

(OP)
Thanks, that doesn't seem to help this problem tho...
It's just a populated xcel file. Trying to get the max
number of colums on the drawing and see where I need
to split the file...

RE: Inserted excel sheet size.

(OP)
Thanks Scott...I'll have a gander over there...



tomorrow... ;o)

RE: Inserted excel sheet size.

if you don't need it linked to the orig, open the Excel spreadsheet, select cells you want, copy.
In SW, insert object/new Excel, paste, resize.

Chris
Systems Analyst, I.S.
SolidWorks 06 4.1/PDMWorks 06
AutoCAD 06
ctopher's home (updated 06-21-06)

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