AutoCAD 2010/2011/2012

Reply
Member
bob312312312
Posts: 3
Registered: ‎01-02-2013
Message 1 of 4 (741 Views)

Upgraded to MS Excel 2007 and can't create Data Link Tables anymore

741 Views, 3 Replies
01-02-2013 03:34 PM

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.

Mentor
DSM_dude
Posts: 183
Registered: ‎03-08-2011
Message 2 of 4 (702 Views)

Re: Upgraded to MS Excel 2007 and can't create Data Link Tables anymore

01-03-2013 11:23 AM in reply to: bob312312312

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.

Cad Blog:
http://geauxcad.wordpress.com/
Member
bob312312312
Posts: 3
Registered: ‎01-02-2013
Message 3 of 4 (664 Views)

Re: Upgraded to MS Excel 2007 and can't create Data Link Tables anymore

01-08-2013 10:53 AM in reply to: DSM_dude

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.

Member
bob312312312
Posts: 3
Registered: ‎01-02-2013
Message 4 of 4 (583 Views)

Re: Upgraded to MS Excel 2007 and can't create Data Link Tables anymore

02-08-2013 11:31 AM in reply to: bob312312312

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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community




Connect with AutoCAD

Twitter

Facebook

Blogs

Pinterest

Youtube