×
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

OLE document in a CATDrawing

OLE document in a CATDrawing

OLE document in a CATDrawing

(OP)
Hello all,

I wonder if somebody have  any clue about how to set the visible area of an Excel Document inserted in a CATDrawing.

Thanks

Eric N.
indocti discant et ament meminisse periti

RE: OLE document in a CATDrawing

Under the pulldown Edit>Links select the Pointed Documents tab and click the OLE Links... button. The Microsoft Office Compatability add-on may need to be installed. At that point, the Change Source option had the range stated after the file path/name.xls

RE: OLE document in a CATDrawing

(OP)
weavedreamer

Thanks for your Tips but I could not change the visible area of the Excel sheet.

Say I see in the CATDrawing cells (A1-C5) and I would like to see (B12-G20).

How you do this?

Eric N.
indocti discant et ament meminisse periti

RE: OLE document in a CATDrawing

Select the section you wish to copy.
Paste w/link into CATDrawing.
-
Or in the edit OLE section from earlier, in the Item Name:
Worksheet Name!R33C2:R35C17
(i.e.: Worksheet Name!Row33Column'B':Row35Column'Q')
 

RE: OLE document in a CATDrawing

To clarify further:
Highlight the Row/Column:Row/Column from Excel and copy.
Paste Special using Link Source.

At that point you will see in the OLE section from earlier, in the Item Name: . . .

While this is modifiable from the Change Source area, it does not modify the size of the CATDrawing viewing area and does not update the aspect ratio of the pasted selection, thus possibly distorting the view the linked excel document.

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