tag:blogger.com,1999:blog-831653633714681277.post2645437323530330733..comments2023-10-25T05:28:25.615-05:00Comments on Tony's Civil 3D World: How to Insert Excel Tables With Data LinkTonyhttp://www.blogger.com/profile/06340737993858354721noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-831653633714681277.post-78932425396082159362011-04-14T19:56:48.315-05:002011-04-14T19:56:48.315-05:00yes type datalink, and a smallpull down will appea...yes type datalink, and a smallpull down will appear. right click on the table you want delete and select delete.Tonyhttps://www.blogger.com/profile/06340737993858354721noreply@blogger.comtag:blogger.com,1999:blog-831653633714681277.post-6934893372160607552011-04-07T08:17:17.526-05:002011-04-07T08:17:17.526-05:00IS THERE A WAY TO DETACH THE ONES I NO LONGER WANT...IS THERE A WAY TO DETACH THE ONES I NO LONGER WANT?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-831653633714681277.post-81573205867397627692010-07-01T19:51:38.452-05:002010-07-01T19:51:38.452-05:00hmm wow i didn't know that the ole object woul...hmm wow i didn't know that the ole object would update. I also learned something new. Oh yeah one of the reason I do tables or datalinks was because we were having problems printing plans that had ole options in them.Tonyhttps://www.blogger.com/profile/06340737993858354721noreply@blogger.comtag:blogger.com,1999:blog-831653633714681277.post-27296474935511638822010-07-01T11:33:17.789-05:002010-07-01T11:33:17.789-05:00I use the OLE option and when I update my Excel fi...I use the OLE option and when I update my Excel file, the OLE object is updated in my dwg. Since my excel files have formulas, I prefer to update Excel. I do like the ability to change the link range with your option, I'll keep it in mind. Thanks for posting the reply. I learned something today, yea!Lisa Pohlmeyerhttps://www.blogger.com/profile/06505046687395176912noreply@blogger.comtag:blogger.com,1999:blog-831653633714681277.post-3380390392902219202010-06-30T20:46:48.274-05:002010-06-30T20:46:48.274-05:00The paste special/link works great if you pick the...The paste special/link works great if you pick the autocad entities option but if you pick the Microsoft worksheet it will add your data as an ole object which, if i remember right, does not allow you to update the data. If you pick autocad entities your data is added as a table which has an update link option. With datalink you will not have to re-insert your table or data if you had made changes to excel sheet. You can simply just type the command datalink, and select your file, right click and pick Edit and change the link range and your table will update. This comes in handy when your tables keeps getting larger. One thing you need to do is create a table style that works for what you are doing such as drainage area or storm calculation table. If you don't, your table could come in pretty messed up. Anyways i hope this clears some things up. This is only just another alternative to added excel tables. Thank you for our comment and reading my post.:)Tonyhttps://www.blogger.com/profile/06340737993858354721noreply@blogger.comtag:blogger.com,1999:blog-831653633714681277.post-61545759281720621082010-06-30T09:42:45.875-05:002010-06-30T09:42:45.875-05:00This seems to be more complex than paste special/l...This seems to be more complex than paste special/link. Does it provide any more benefit?Lisa Pohlmeyerhttps://www.blogger.com/profile/06505046687395176912noreply@blogger.com