×
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

How to Crop Linked Excel Worksheets?

How to Crop Linked Excel Worksheets?

How to Crop Linked Excel Worksheets?

(OP)
When I insert an excel file unlinked I can crop the object showing only the portion I want in SW.  I can't seem to find out how to crop a linked excel file in SW.

RE: How to Crop Linked Excel Worksheets?

(OP)
You can't control what worksheet or how much of that sheet shows?  So linking excel files is useless?

RE: How to Crop Linked Excel Worksheets?

I was thinking of cropping like you do in SW... You can't crop an excel sheet like that.

You can adjust it by dragging the bottom right corner (black square) of the Excel sheet when it's active.

1) Double click the Sheet
2) Takes you into Excel within SW
3) Drag the black square in the bottom corners to adjust sheet size

You are only allowed so many rows and columns (dependent upon size of both) or the excel sheet will be cut off. This is an OLE limitation and it’s not a SW issue. It’s an Excel or MS issue.

Regards,

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

RE: How to Crop Linked Excel Worksheets?

(OP)
When I insert an excel sheet "unlinked" I can double click the object and "crop" it the way you describe.  I geuss you are right it is not cropping; sorry for the confusion.

The problem is when I double click a "linked" excel file, it opens excel and the file (not within SW, but just as if I had opened the file normally) and there is no way to adjust what shows or what is hidden.

RE: How to Crop Linked Excel Worksheets?

When you say "linked" - Are you talking about inserting a Design table into a Drawing?

If so, then you have to set the size at the Part/assembly level then it is transformed to the drawing itself. See help I believe this in there.

Regards,

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

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