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.
When was the last time you drove down the highway without seeing a commercial truck hauling goods?
Download nowINTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
How to Crop Linked Excel Worksheets?
|
RE: How to Crop Linked Excel Worksheets?
Regards,
Scott Baugh, CSWP
www.scottjbaugh.com
FAQ731-376
RE: How to Crop Linked Excel Worksheets?
RE: How to Crop Linked Excel Worksheets?
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?
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?
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