See the top rated post in this thread. Click here

Results 1 to 4 of 4

Thread: Excel Spreadsheet wrong size insert & Linking

  1. #1
    100 Club
    Join Date
    2000-11
    Posts
    138
    Login to Give a bone
    0

    Default Excel Spreadsheet wrong size insert & Linking

    I have a simple two column Excel spreadsheet that I need to Link into a dwg that will update as the equipment index changes. When I OLE it into my drawing I only get 10 rows out of 40 rows. I can go to the computer next to me and it imports perfectly. Gave up and had my co-worker OLE it for me. I opened the drawing and it was perfect. Scaled it to fit and saved and still okay. Got out of the drawing and came back into it a bit later. Now I am back to displaying only 10 rows out of the 40. Went to a blank drawing and imported the same spreadsheet and it came in fine on my machine. Opened up the drawing containing the messed up spreadsheet and it now displays correctly. Does anyone know of a variable or setting that would cause this strange behavior. I have spent almost 1 hour reading all of the info in the HELP section and I could not find anything specific that might be causing this. Really need to know what might be causing this as I need to be able to reliably open the drawing and plot it. Thanks a bunch for your help, Jack Foster.

  2. #2
    Mod / Salary / SM Wanderer's Avatar
    Join Date
    2001-12
    Location
    St. Louis
    Posts
    5,347
    Login to Give a bone
    0

    Talking Re: Excel Spreadsheet wrong size insert & Linking

    Quote Originally Posted by jack.foster
    I have a simple two column Excel spreadsheet that I need to Link into a dwg that will update as the equipment index changes. When I OLE it into my drawing I only get 10 rows out of 40 rows. I can go to the computer next to me and it imports perfectly. Gave up and had my co-worker OLE it for me. I opened the drawing and it was perfect. Scaled it to fit and saved and still okay. Got out of the drawing and came back into it a bit later. Now I am back to displaying only 10 rows out of the 40. Went to a blank drawing and imported the same spreadsheet and it came in fine on my machine. Opened up the drawing containing the messed up spreadsheet and it now displays correctly. Does anyone know of a variable or setting that would cause this strange behavior. I have spent almost 1 hour reading all of the info in the HELP section and I could not find anything specific that might be causing this. Really need to know what might be causing this as I need to be able to reliably open the drawing and plot it. Thanks a bunch for your help, Jack Foster.
    hmm, this is a limitation from some earlier releases... which version are you using?

    also, check out the similar threads links at the bottom of this page to find threads like Linking Excel Files in dwg (ole)
    good luck!
    Melanie Stone
    @MistresDorkness

    ARCHIBUS, FMS/FMInteract and AutoCAD Expert (I use BricsCAD, Revit, & Tririga, too)
    Technical Editor
    not all those who wander are lost

  3. #3
    100 Club
    Join Date
    2000-11
    Posts
    138
    Login to Give a bone
    1

    Default Re: Excel Spreadsheet wrong size insert & Linking

    Thanks for the reply and I will check out the additional threads. Currently my crazy system finally allowed me to bring in the file linked okay. However, then I could not print it as it reverted back to the few lines of original insertion problem. Now when I open the drawing it may open and be fine and the next time I open it I only see 8 or 9 rows instead. I have no idea what is causing the fluctuation from time to time when I open the drawing. My co-workers computer displays it correctly and prints it correctly which is at least a nice workaround. Almost forgot I am running windows xp pro and xecel 2003 and acad 2005. Thanks, Jack.

  4. #4
    The Silent Type Mike.Perry's Avatar
    Join Date
    2000-11
    Posts
    13,656
    Login to Give a bone
    0

    Default Re: Excel Spreadsheet wrong size insert & Linking

    Hi

    Have a browse of the following thread in the AutoCAD FAQ forum -

    Working with OLE (eg Excel) Objects within a drawing file

    Have a good one, Mike

Similar Threads

  1. Excel spreadsheet linking problem
    By tlepird2925761 in forum Inventor - General
    Replies: 15
    Last Post: 2019-03-12, 10:18 AM
  2. Linking object in a drawing to an external Excel Spreadsheet
    By bethelcad370537 in forum Facilities Management In Practice
    Replies: 7
    Last Post: 2013-04-16, 01:34 PM
  3. Linking Excel spreadsheet to AutoCAD
    By dmcdonald.156724 in forum AutoCAD General
    Replies: 6
    Last Post: 2008-01-09, 11:37 PM
  4. Linking of Specific Tolerances to a Spreadsheet
    By inventor.wishlist1738 in forum Inventor Wish List
    Replies: 0
    Last Post: 2007-09-19, 02:54 AM
  5. Insert Excel spreadsheet only half shows up
    By dcochrane757156 in forum AutoCAD General
    Replies: 4
    Last Post: 2006-03-22, 11:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •