×
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 Re-Insert an Excel Spreadsheet

How to Re-Insert an Excel Spreadsheet

How to Re-Insert an Excel Spreadsheet

(OP)
Dear Folks;

I am having a tough time editing a spreadsheet which is embedded in my AutoCad 2000 drawing.

I have corrected all the entries in the spreadsheet and added several more, which makes my spreadsheet overlap the drawing area. Unfortunately when I resize the new spreadsheet to fit within the drawing boundary the last few entries are cutoff.

It seems clear that I need to redefine the boundaries of the spreadsheet so my missing lines of data are displayed but I cannot figure out how to do that.

Any assistance would be most appreciated.

Regards Adrian

RE: How to Re-Insert an Excel Spreadsheet

Hi Adrian2,

I've had the same problem...I had to resize the print area on the spreadsheet before I inserted it...

Hope this helps...

GSkiver

RE: How to Re-Insert an Excel Spreadsheet

Adrian,

Have had that problem before. Appears AutoDesk has no solution. Only way I deal with excel is in the worksheet after you are done with the changes, select the entire spreadsheet and make the text size as small as possible. Re-size the columns, copy the area you want, paste in AutoCAD, as "paste special", "product enities". This should let you "grab" a lot more data. You will then need to list a piece of text, and knowing the size, scale the chart as needed to be the right text size.

Would hope someday ... Gates and AutoDesk get it together on this !

Ken

RE: How to Re-Insert an Excel Spreadsheet

Adrian,
If you are familiar with Paperspace and Modelspace the problem you describes isn't that hard at all.

Try this:
Paste your Excelsheet in modelspace, do not scaled it or what so ever.

Goto the paperspace tab and create a viewport with mview.

<command> mspace
<command> zoom extents
<command> pspace

If you did that you will see that the Excelsheet always fit, even when modified. But don't forgot to Zoom Extents the viewport again.

Enjoy  

Willem from the Netherlands

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