AutoCAD 2013/2014/2015

AutoCAD 2013/2014/2015

Reply
Active Contributor
chrishutchinson6900
Posts: 30
Registered: ‎02-09-2011
Message 1 of 23 (6,507 Views)
Accepted Solution

Editing Excel 2007 Embedded Autocad Drawing Problem

6507 Views, 22 Replies
05-09-2012 06:17 AM

I've created data sheets for componet rebuilds in Excel 2007 using previous versions of Autocad (currently using 2013) to create cross-section drawings with labeled data points.  When I open these older excel spreadsheets and try to edit the embedded autocad drawing I get a message stating the source application for this object cannot be started.  How can I edit the embedded object to use the currently installed version of Autocad 2013 to open the object?  Is a registry edit required for this?

 

Thanks,

Chris Hutchinson

Duke Energy

Charlotte, NC

Product Support
zalant
Posts: 303
Registered: ‎11-01-2005
Message 2 of 23 (6,484 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-11-2012 05:40 PM in reply to: chrishutchinson6900

Indeed, with OLE objects like a DWG in an Office document, there is an embedded class ID tag that calls to the version of AutoCAD which was current at the time of that original copy/paste operation.  Whenever you come back and try to edit that OLE object, that class ID string will be called.  If it is not found in the Windows registry, you'll get the message you're currently getting.  

 

In theory, if you had upgraded from one version of AutoCAD to the next (on the same computer), starting with the one that was current when you copied/pasted the DWG into the Excel document, the chronological list of class ID forwarding "pointers" would be already on your system.  But, if you have only ever had AutoCAD 2013 on this machine, then the previous class IDs required to forward the request from the OLE object to the current version of AutoCAD are not going to be present.  

 

I can get you the necessary class ID registry keys to perform that forwarding operation.  It would be very helpful to know specifically which version of AutoCAD was current when the DWG content was placed into the Excel documents.  That way, I'll know which registry key(s) you'll need.  Please update this thread with that information, to the best of your recollection.



Zac Travis
Active Contributor
chrishutchinson6900
Posts: 30
Registered: ‎02-09-2011
Message 3 of 23 (6,472 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-12-2012 02:03 PM in reply to: zalant

Hi Zac, the OLE DWG in the Excel file was created using AutoCAD 2011.

 

This laptop has only had AutoCAD 2012 (now uninstalleld) and 2013 installed on it.

 

I also have even older Excel  files with oldler versions of OLE DWG embedded in them.  Could you also post information for Autodad drawings embedded to at least the Autocad 2009 version?

 

Thanks you for the help.  I've searched the these discussion groups and couldn't find anything of use for fixing this.  Without a fix I'd have to redraw the OLE DWG files.

 

Chris Hutchinson

Active Contributor
chrishutchinson6900
Posts: 30
Registered: ‎02-09-2011
Message 4 of 23 (6,464 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-12-2012 03:08 PM in reply to: zalant

Zac, I found a Excel file with the OLE DWG created usining Autocad 2012 a version that was on my laptop before uninstalling and upgrading to Autocad 2013.  I cannot edit the embedded OLE DWG.

 

I have no problem creating a new OLE DWG using Autocad 2013 in a Excel spreadsheet.

 

I'm actually using the Autodesk Product Design Preminum suite.

 

Thanks,

Chris Hutchinson

*Expert Elite*
pendean
Posts: 22,187
Registered: ‎11-06-2003
Message 5 of 23 (6,449 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-14-2012 05:49 AM in reply to: chrishutchinson6900

The incorrect 'tag' issue is embedded in the actual Excel file, your system changes are totall ignored. Sorry, Microsoft designed it that way and AFAIK you cannot fix it outside of the program.

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Product Support
zalant
Posts: 303
Registered: ‎11-01-2005
Message 6 of 23 (6,436 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-14-2012 05:02 PM in reply to: chrishutchinson6900

I've got a bunch of registry files rounded up to attach here, but I'm not sure they'll do you any good yet.  I'm currently installing AutoCAD 2013 on a system (virtual machine) which didn't have any previous version of AutoCAD, for testing.  I'll try to open a Word doc made on another machine by copying/pasting out of AutoCAD 2012, to best duplicate your environment.  The thing that worries me is that on my system with multiple versions of AutoCAD, I cannot locate a newer CLSID key for the 2013 product.  There's got to be one, but I have yet to find it.  I'll check it out tomorrow, once I have 2013 installed on the new system and I'll know more.



Zac Travis
Product Support
zalant
Posts: 303
Registered: ‎11-01-2005
Message 7 of 23 (6,422 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-15-2012 09:55 AM in reply to: chrishutchinson6900

OK, so I opened a Word document with OLE DWG content from AutoCAD 2012 on my new virtual machine this morning, and when I right-clicked it, there was only "Unknown Object" and no option to edit it.  Upon double-clicking it, I got the message you're getting about the correct application not being present.

 

I then noticed that AutoCAD 2013 had put in the CSLID pointers for AutoCAD 2000-2002, 2004-2006, and 2007-2009, and all of those pointed to the CSLID key for 2010-2012.  The kicker, however, was that there WAS NO KEY present for 2010-2012 to accept those redirections.  Further, if you have OLE content created with 2010-2012, there's no key present to handle or forward them to the CSLID key for 2013.  Therefore, on a system with only 2013 installed, only OLE content copied from 2013 into Word/Excel would be editable.  

 

I did, however, locate the CSLID key for AutoCAD 2013.  I added the key for 2010-2012 and put a pointer in it to go to the 2013 key, and now I'm in business.  I have attached to this post a ZIP file containing the registry keys which should handle OLE objects made with AutoCAD versions 2000-2012.  Extract the REG files from the ZIP file and then double-click them to add the content to the system registry.  Do this with both AutoCAD and Excel (or Word, if in use) closed.

 

I want to add a BIG REMINDER here that you should be sure to back up the system registry before adding this content to it, just to be on the safe side.

For Windows 7

http://windows.microsoft.com/en-US/windows7/Back-up-the-registry

For Windows XP

http://support.microsoft.com/kb/322756

 

Once that's all done, please let me know if you're able to edit the DWG content from within the Office programs (Excel, Word, etc.).



Zac Travis
Active Contributor
chrishutchinson6900
Posts: 30
Registered: ‎02-09-2011
Message 8 of 23 (6,407 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

05-15-2012 05:37 PM in reply to: zalant

Zac, you are a windows registry genius.

 

These registry keys work perfectly and I'm now able to edit OLE DWG files embedded in my Excel 2007 spreadsheets created with previous versions of Autocad using the 2013 version loaded on my laptop.

 

I would think this fix should be included in any future service packs of Autocad 2013.

 

Thanks again.  This fix has saved me many hours of work.  I can now edit the embedded OLE DWG files instead of redrawing them.

 

Chris Hutchinson

Duke Energy

Charlotte, NC

Member
sharonk
Posts: 5
Registered: ‎01-03-2007
Message 9 of 23 (5,337 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

11-07-2012 10:01 AM in reply to: zalant

Zac -

Thanks so much for this resolution. It works perfect!

 

Sharon

 

Product Support
zalant
Posts: 303
Registered: ‎11-01-2005
Message 10 of 23 (5,335 Views)

Re: Editing Excel 2007 Embedded Autocad Drawing Problem

11-07-2012 10:05 AM in reply to: sharonk

I'm very glad to hear that!  This workflow with DWG content embedded in other programs' documents isn't exactly commonplace.  For those who do use it, though, there are typically many such documents over the years, so getting newer versions of AutoCAD to open them is important.



Zac Travis
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 or visit the Installation and Licensing Forum to get help installing your software.