When using Excel 2003 with AutoCAD Electrical 2010, I was able to successfully draw AutoCAD tables with the Data Link Manager.
However, I recently upgraded to MS Office 2007, and the Data Link Manager can't seem to link to any Excel table anymore.
Under Office 2007, I am able to create a new Excel Data Link inside the AutoCAD Data Link Manager. I am able to click on "OK" on the Insert Table pop-up window with my newly defined Data Link. However, it stops there: I click "OK" and nothing happens.
The preview window only shows an empty rectangle.
I've noticed that when opening old *.dwg files which I have successful Data Link Tables with Excel 2003, the same thing above occurs.
You have to save the file down to a earlier version.
When the save as dialog box appears, you should be able to select an earlier version of excel.
Using either Excel 2003 or Excel 2007 file formats makes no difference. I still can't insert the table or see a preview.
I believe somehow the new install of Office 2007 changed an OLE reference somewhere in the Windows Registry for AutoCAD.
I have a co-worker of mine who has the exact same computer as mine, but he installed AutoCAD 2010 after he installed Office 2007. He can do the Insert Table / Data Link with no problems.
The following steps appear to have fixed the problem:
1. Uninstall AutoCAD Elec 2010.
2. Use a software tool to clean the Windows Registry of AutoCAD
3. Reinstall AutoCAD Elec 2010.
4. Restart the computer.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register