ziemerd Posted November 13, 2008 Share Posted November 13, 2008 This is really frustrating. I have an Excel spreadsheet that I have linked to my drawing. The problem is the top two lines are being duplicated in the table. I go back to my spreadsheet and all is well. In the drawing I have not found anything that lets me delete rows. Can anyone tell me what is happening and how I can remedy this problem? Thanks. Dawn Quote Link to comment Share on other sites More sharing options...
dbroada Posted November 13, 2008 Share Posted November 13, 2008 how have you got the table into your drawing? I have been looking at using a data link and the AutoCAD table with reasonable success - certainly more than I ever did with OLE. Whatever you answer, I can't assist as I don't have ACAD here but I am nosey. Quote Link to comment Share on other sites More sharing options...
BOB'27T Posted November 13, 2008 Share Posted November 13, 2008 In the table editor, the third icon from the left will let you delete rows. Quote Link to comment Share on other sites More sharing options...
ziemerd Posted November 13, 2008 Author Share Posted November 13, 2008 Thanks BOB'27T. I found the icon for deleting rows but I cannot seem to select a row. It only wants to select one cell at a time. If I select a cell and drag to other cells it just enlarges the cell I selected. Dave, I opened Excel and made my table (this can be done automatically through extracting data from blocks and such in your drawing just so you know). I then went to my layout where I want my table to show up since I really don't want it in Model Space. Then I click on Draw -> Table and follow the instructions for creating a new data link. Then it lets you insert it where you want. You can modify some things in properties. The table in the drawing is a royal pain to move around since it's not quite like Excel so it's quirky at best. You'll have to unlock the cell or the table to edit. Good luck. :-P Quote Link to comment Share on other sites More sharing options...
ziemerd Posted November 13, 2008 Author Share Posted November 13, 2008 Ok...I re linked the data to update the table from the spreadsheet it and it's fine now. I think something happened when I was resizing the table in the layout or something. I have found some really quirky things in 2008 so maybe it's apart of that. I never did figure out how to select a row. It kept jumping from cell to cell in the row instead of selecting the whole row. Thanks for the help. Quote Link to comment Share on other sites More sharing options...
dbroada Posted November 13, 2008 Share Posted November 13, 2008 Dawn, FYI, I couldn't delete a row earlier today either . I had to reconstruct the data link. I was going to suggest that or if that failed checking the setting in your table format but since you are sorted now, I won't. Had you used OLE I would have walked away. and in mine I could select a row by mouse clicking to the left of the table to get the excel style row numbers. Quote Link to comment Share on other sites More sharing options...
ziemerd Posted November 13, 2008 Author Share Posted November 13, 2008 Hey Dave, maybe you were holding your tongue just right or something. :-) I was clicking on the row numbers like you would in Excel but it would just move the cell selection around instead of selecting the row. I was able to drag a window across and select more than one cell but not the row. But now I have ANOTHER problem. I created a new data link in a new drawing and it's inserting the wrong sheet in the spreadsheet. I insert it anyway and double click on a cell, right click, data links, and clicked on open data link file. It opens up the the correct tab in the spreadsheet but not when I select it to insert it in the drawing. I think I'm going to have to move on to something else before my head explodes. Quote Link to comment Share on other sites More sharing options...
dbroada Posted November 13, 2008 Share Posted November 13, 2008 I don't have to modify the table now but next time I do I'll get a mirror and check my tongue. I think I'm glad I don't have AutoCAD at home and I can let you get on with preventing your head from exploding. Quote Link to comment Share on other sites More sharing options...
ziemerd Posted November 13, 2008 Author Share Posted November 13, 2008 Ok...get this. I decided to work on a different table and as I was mucking around with it I realized I was able to select the row by clicking on the row number. Why I could do it in the new table and not the other is beyond me. Thank goodness I'll be going home soon. I won't have to think about this again until Monday. Well...until Monday...have a good one! Quote Link to comment Share on other sites More sharing options...
ziemerd Posted November 17, 2008 Author Share Posted November 17, 2008 Update: I redid the link to the table I wanted since it was selecting the wrong sheet. I got the correct table in the drawing and noticed something interesting. I could not select the rows again just like before so I went back to the spreadsheet and saved it. I hadn't made any changes but I saved it anyway. I went back to the drawing and presto chango I was able to select entire rows. Go figure. Thanks for all the help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.