I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
If you linked the spreadsheet to the assembly, the parameters wont be available at the part level. You would have to link the spreadsheet in each part. A typical method for handling this type of data is to link your spreadsheet to a master part, then derive the parameters, as you need them, into any subsequent parts you create. Not only does it tend to be more stable but it also lends itself well to skeletal and multi-body modelling techniques.
Just in case, assuming you have linked the spreadsheet to the part, have you selected the arrow in the dimension dialogue and selected list parameters or just tried to type them directly?
Thanks, that tip on linking to the part does the trick. The HELP instruction did not specify this, and I got the impression that the spreadsheet could be linked to the top assembly. It seems to work now. Thanks Again. CM
No probs. You can still link to assemblies but that would control anything parametric in the assembly, such as assembly features and constraints, etc.
How do I actually link parts or assemblies to the parametric master part?
Might be a silly question but I am new to Inventor and parametric design.
Many thanks Stew, problem is solved.
Master part and linked parts/assemblies and some derived Parts are working fine from spreadsheet.
Only thing I can’t figure out is if there is a way to automatically update linked parameters in parts and assemblies to show new parameters when they are added to the spread sheet.
(Once I manually update the master part and open the Parameters window and tick the “Export Parameter” box for each, every single linked or derived part/assy also needs manual updating (Manage Tab/Parameters window --> right click on Master part location / ”Edit Folder” / Link parameters. I have to change manually the status of each parameter.
Same if it is a derived part [derived part/ right click on master part/ Edit Derived Part --> parameter status needs manual updating...])
Any suggestion woul be much appreciated.
Thanks a lot,
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.
Upgrading to a 2015 product? Make sure to check these out 1st!