12:58 Excel don't read/handle measurement units. Money, time, date, fractions it understand someway. So, "5 in" is invalid value. Change value to "5" will fix calculation 13:31 - 13:32 Also I see more invalid cells, (C3, C4, C5) cell type is "Text". Those need to set "General" or "Number" (You see drop down input line middle of excel on top) *remember convert "text to number", after you change cell type
@@Hagerman Final solution (my opinion) is, continue using only either: excel program (sheet) to add/edit parts (you can do this on background, Inventor updates when sheet saved) or continue using only Inventor iPart table. - Try to avoid using both in turns if possible, Inventor itself is creating "Text" cell types which gives you headache later in formulas in excel program. Just keep that in you mind.
Hi When opening a Member iAssembly There is an option to break the link with the Master. It does not give me the same options to edit the assembly... any sygestions ?
I have an iAssembly with an "ISubassembly" where I make a Table Replace, almost exactly like your SmartPhone, just other parts. but when I look at Bill of Materials, on the iAssembly, it shows both the part from the "iSubAssembly" I have active, and the part I not have active. Is there a way to fix this, so it only shows the active parts?
Great video and I appreciate it. But I can't help but shake my head how bad the Inventor usability is. It was literally tragicomic when you were determining what features are suppressed and needed to type "Suppress". Very frustrated after forced to change from SolidWorks to Inventor.
12:58 Excel don't read/handle measurement units. Money, time, date, fractions it understand someway.
So, "5 in" is invalid value. Change value to "5" will fix calculation
13:31 - 13:32 Also I see more invalid cells, (C3, C4, C5) cell type is "Text". Those need to set "General" or "Number" (You see drop down input line middle of excel on top)
*remember convert "text to number", after you change cell type
Thank you for mentioning this!
@@Hagerman 4:28 I guess problems start from here when creating new rows, I think Inventor create excel cells as "Text" by default... (bug) :P
@@Hagerman Final solution (my opinion) is, continue using only either:
excel program (sheet) to add/edit parts (you can do this on background, Inventor updates when sheet saved)
or continue using only Inventor iPart table.
- Try to avoid using both in turns if possible, Inventor itself is creating "Text" cell types which gives you headache later in formulas in excel program. Just keep that in you mind.
Hi When opening a Member iAssembly There is an option to break the link with the Master. It does not give me the same options to edit the assembly... any sygestions ?
I have an iAssembly with an "ISubassembly" where I make a Table Replace, almost exactly like your SmartPhone, just other parts. but when I look at Bill of Materials, on the iAssembly, it shows both the part from the "iSubAssembly" I have active, and the part I not have active.
Is there a way to fix this, so it only shows the active parts?
Great video and I appreciate it. But I can't help but shake my head how bad the Inventor usability is. It was literally tragicomic when you were determining what features are suppressed and needed to type "Suppress". Very frustrated after forced to change from SolidWorks to Inventor.