Inventor General Discussion

Active Member
Posts: 7
Registered: ‎04-04-2011
Message 1 of 2 (378 Views)

Frustration with the Excel / Inventor relationship

378 Views, 1 Replies
07-27-2011 09:00 AM

We recently upgraded to Inventor 2011 (now 2012) from R11.  We have a few hundred iparts and assemblies we've made over the years, and we had become accustomed to being able edit a spreadsheet driven part easily and reliably.


However, starting with 2011 (and continuing with 2012), whenever I need to edit an iPart via spreadsheet, I get a dialog informing me that changes will not be reflected in the part until the Excel process closes.


I don't know about the rest of you, but I often have 2 or 3 spreadsheets open at any given time.  If I need to jump into an ipart to make a change, not only do I have to close that spreadsheet, but the others that I had open in order to close the excel process.


Previously in R11, all I had to do was close that particular workbook associated with the iPart.  Now, I have to close all workbooks, including those with no connection to the ipart, and exit Excel in order for the part to change.


It seems particularly shortsighted for Autodesk to expect the only time I would have an excel process running would be to edit an ipart, which is the impression I get from how this relationship is structured.  


Is there a workaround, script, registry hack that I can use that will allow an ipart to update when its workbook closes, rather than having to exit the entire excel process?


Workstation: Win7 64-bit, Office 2010, Inventor 2012.

Posts: 19
Registered: ‎08-26-2009
Message 2 of 2 (332 Views)

Re: Frustration with the Excel / Inventor relationship

07-28-2011 06:06 AM in reply to: jharris

Excel 2010 open multi excel files in the same process.

Although the workbook associated with the iPart is closed, the excel process is not terminated.


Could you please firstly open all your excel files before edit the ipart table via excel?

The workbook associated with the iPart will be opened in a solo process.




You are not logged in.

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

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

Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor