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?
Solved! Go to Solution.
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.
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.
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.
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.
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
For Windows XP
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, 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.
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.