Problem With Parametric Part and use Excel file in Inventor 2011?

[bms953]

in Inventor 2011, i use a Excel File (*.xls) for a part then after link in the parametric dialog box, i change many of number for test, but dos not happen for part, and after reopen diloag box, in user parameters i have many box with yellow color, i don't no why? i try any way to fix this but i can't

Please Help me

[JarFu]

Hi, I tried and also saw yellow cells (seems mean invalid). "Update" and "Change Source" don't work to discard them. The only way is to open the Parameters table, right-click the row which indicates the excel file, chose "Delete Folder", then "Link" this excel again.

[bms953]

i know, but it is not good, because i work on lot of file ( Assembly,Part,Weldment) in Inventor 2010, and now when i open that file , it does'nt work,
i create local library for my project with the parametric part link to excel, and i don't know what to do with this file, and relink excel file can''t fix all of them,

[bms953]

i forget this, after change excel file and save in inventor update icon is still turn off

[bobvdd]

This is a known problem.
We are working on a hotfix for this.

Best worarounds are to
a) relink to the same spreadsheet
b) edit the start cell and pick the exact same cell.

Sorry for the inconvenience.
Bob
Autodesk Inventor Product Support

[nickmartin]

I am doing a very large iPart now. After editing my excel spreadsheet and getting my changes made... In order to get them back to Inventor I have been first closing the file in Excel and then closing the Excel program. When exiting Excel it seems to apply my changes back to my Inventor table. It has been working for me...give it a try.

[bobvdd]

The hotfix is now available at http://usa.autodesk.com/getdoc/id=DL14965008

Bob

[kperic777]

This hot fix does not fix the problem.  See the attached.  That spread sheet is used on multiple parts (obviously), and it used to work, now it doesn't.  all yellow boxes, except the first three.  I tried making it all one sheet and all kinds of stuff.  

WINDOWS 7

INVENTOR SIMULATION 2011

EXCEL 2010

Please let me know your thoughts...

[kperic777]

i should let everyone know that i just figured out a very effective work around for this, that automatically fixes it.  I saved Copy As my formula-heavy excel spread sheet as a different name.  then i overwrote the old one as the attached.  the attached are my parameters and values column pasted into a blank spread sheet as TEXT ONLY.  this seamed to clear things up.  Now, i edit the calculation (formula-heavy) spreadsheet, paste the resulting valvues into the attached as TEXT ONLY, and it works.  no need to "delete folder" or "rename parameters" or anything too combursome. 

Now, i want to understand:  WHAT WENT WRONG??

the problem with these work arounds are that i now need to tell all the engineers in our company this process, and make sure everyone is on board...and i still question the stability of the spreadsheets.  which is a shame, because driving multiple parts with one sheet would be ideal for us.