johnv Posted March 22, 2009 Posted March 22, 2009 I am trying to link a table to an Excel table and it does not seem to work. I have tried this several ways. The thought just occured to me that this is probably not supported in the version of the software I have. AutoCAD LT 2009. Purchased about a month ago. Am I correct that this is not done in LT? If not is this some known bug? I tried saving the Excel file as xls instead of xlsx and also as csv but nothing seems to work. -JV Quote
Cad64 Posted March 22, 2009 Posted March 22, 2009 See if this helps: http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=11752914&linkID=9240815 Quote
johnv Posted March 22, 2009 Author Posted March 22, 2009 This works but I cannot paste as an AutoCAD LT object only as an Excel picture. This makes printing kind of a challenge. Also, no editing can be done in AutoCAD. -John Quote
Geoffers Posted March 23, 2009 Posted March 23, 2009 I am trying to link a table to an Excel table and it does not seem to work. I have tried this several ways. The thought just occured to me that this is probably not supported in the version of the software I have. AutoCAD LT 2009. Purchased about a month ago. Am I correct that this is not done in LT? If not is this some known bug? I tried saving the Excel file as xls instead of xlsx and also as csv but nothing seems to work. -JV last week i posted a somewhat similar question but i am using ADT 09 and excel 2007 so whether the problem is common to LT i dont know. after many hours i did get it to work by 'pasting special' an excel table. however i think that it should be possible to edit the table in a drawing and get it to update the excel file - but it will not. there are several sites with advice if you type in something like 'acad tables and excel' including the one mentioned above. this probably does not help you as LT user but my question still is - should datalinking be bidirectional? Quote
MaxwellEdison Posted March 23, 2009 Posted March 23, 2009 Datalink's will allow you to change the excel file, provided you have set them up that way. When creating the datalink, click the button to expand the advanced settings (A). To allow updating the source file, the proper box (B) must be checked. They will not update automatically, but if you select the table (crossing window: Write Data Links to External Source; Active cells: Datalinks -> Upload User Changes to Source File) will change it. Quote
Geoffers Posted March 23, 2009 Posted March 23, 2009 Maxwell yes , ...done that but i did not use 'range'; maybe that's the prob... Quote
MaxwellEdison Posted March 23, 2009 Posted March 23, 2009 Hmm, that really shouldn't have an effect. Can you post a screenshot of one of your datalinks? Quote
Geoffers Posted March 23, 2009 Posted March 23, 2009 Hmm, that really shouldn't have an effect. Can you post a screenshot of one of your datalinks? will do - when i start again. Having given up for the time i cleared all my attempts (files, links etc) out... give me a few days... thanks. Geoffers Quote
MaxwellEdison Posted March 23, 2009 Posted March 23, 2009 No problem, I'm more than willing to help someone get out from under the yoke of OLE's:thumbsup: Quote
johnv Posted March 23, 2009 Author Posted March 23, 2009 Please see attached screen shots. Obviously there is something wrong. So how could we find out if this is supossed to work in ACAD LT 2009? -john ACAD EXCEL BUG.pdf Quote
MaxwellEdison Posted March 23, 2009 Posted March 23, 2009 The PDF you posted does not show the necessary options. In the first PDF the window with the title "New Excel Data Link: test data link" click the button to expand the window (labeled A in my screenshot above). This is where you will find the check box to control writing to the source file. Expand that window out, and post that screen shot (Protip: You can use Ctrl+PrntScrn to copy just the active window to the clipboard, you can then open it in paint and save it as a JPEG to attach to your post) Quote
johnv Posted March 23, 2009 Author Posted March 23, 2009 Thank-you for the suggestion. I expanded the box as suggested. This did not change the failyure to preview the table as shown in your example. Nor was I able to insert the table. I played around with the options and pretty much tried all combinations. Nothing allows this to work. Did you do this with AutoCAD LT 2009? Does anyone else have this software that could try this? -john Quote
johnv Posted March 23, 2009 Author Posted March 23, 2009 Also - I tried linking to a range, a whole sheet a different sheet and range. etc. Quote
MaxwellEdison Posted March 23, 2009 Posted March 23, 2009 According to this [Autodesk.com], it should certainly be be possible. Try the steps outlined on page 19 of the PDF. Quote
Geoffers Posted March 24, 2009 Posted March 24, 2009 johnv are you using metric or imperial version of acad lt? Quote
florin Posted July 22, 2009 Posted July 22, 2009 You inserted the file as "AutoCAD table". Try to select the cells in Excel. Then "paste special" in AutoCAD (with link or without link - embedded). Quote
Geoffers Posted July 22, 2009 Posted July 22, 2009 ...just been brought back to this thread again by latest posting - and cannot understand why I posted the previous message.?? Hopefully there was some reason behind the question but I can't see it at the moment. I'll go into a darkened room...:oops::oops: Quote
CrustyFur Posted July 30, 2009 Posted July 30, 2009 Try this. It works with Excel 2007. Regards, Chris tbl2xl.zip Quote
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.