I have recently been starting to use the new datalink command in Autocad 2008. It has been working fine with abut 50 different drawings so far. Lately there are 3 drawings that when excel is changed, autocad does not update. It shows a blank rectanglular box instead. Any help would be appreciated.
> I have recently been starting to use the new datalink command in Autocad
> 2008. It has been working fine with abut 50 different drawings so far.
> Lately there are 3 drawings that when excel is changed, autocad does not
> update. It shows a blank rectanglular box instead. Any help would be
You will have better progress if you past the Excel worksheet instead of
1. Highlight the area to be used as a table in AutoCAD.
2. Copy to the clipboard.
3. In AutoCAD, under Edit, pick Paste Special.
4. The Excel Worksheet will now be listed in a dialog box. Pick OK.
5. The Excel Worksheet will now be in the AutoCAD dwg where it can be
scaled and/or edited. When the table is double picked, the Excel
Worksheet will be available where it can be edited and the table in the
AutoCAD dwg will be appropriately updated.
I have templates all set up with the datlinks already and I have thousands to do that all pull from the same sections of the excel sheet. So, I don't think copy and pasting them is the most efficient way for me.
Edited by: BJTERRY1977 on Mar 12, 2009 1:26 PM
Okay, so I haven't got much help here so I tried to figure it out for myself. Here is what I came up with: When I get a blank rectangle in the preview window of a data link, I open up the data link manager, right click on my link, and click edit, I open up the excel sheet I am linking see what the range says, I make the range match my excel sheet (it seems to be thrown off by merged cells and/or row heights being changed), if I do a print preview it gives me the dashed line of where my cut off is and that is the new range I use (I set my links up to be an 8 1/2 x 11 page). The only time I have trouble with this is when I have linked more than two data links. Once I do that, I then draw my tables again and erase the old ones to make sure it all shows up correctly. It seems like a pain in the butt, but it is way better than retyping it.