Tuesday, August 9, 2011

Using and Understanding Linked Parameter in Autodesk Inventor

Platform: Autodesk Inventor Professional

Level of difficulty: Beginners

Author: Ndianabasi Udonkang

Follow me on Twitter | Facebook

This is the second lesson in our series about using and understanding parameters in Autodesk Inventor Professional. In the first lesson, we got ourselves familiarized with the general concepts on parameters. In case you missed the first lesson, read it here: Using and Understanding Parameters in Autodesk Inventor - Part 1.


At the end of this lesson, you should be able to:

  1. Create user-defined parameters using Microsoft Office Excel.
  2. Link the Excel spreadsheet document to a part or assembly file inside Autodesk Inventor.
  3. Update an Inventor part or assembly file when changes have been made to the source spreadsheet file.


In Autodesk Inventor, a Microsoft Office Excel spreadsheet file can be used to create user-defined parameters which then can be linked to a part or assembly file. This way, a single Excel spreadsheet file can be reused across many Inventor files as the source for user-defined parameters. Excel spreadsheet files have the file extensions ".xls" for Excel 2003 documents, and ".xlsx" for Excel 2007 and 2010 documents. For you to understand this topic, it is required that you have a basic understanding of how equations are created in Microsoft Office Excel.

Linking parameters has an obvious advantage since you do not need to create the same parameters in each Inventor file you create. This is also the principle behind many features and standard parts including Thread features, Bolted Connections, gears, etc.

There is a major drawback in using external spreadsheet files as sources of user-defined parameters. Now imagine losing the spreadsheet files in unfortunate circumstances; this means you have also lost all the parameters that were stored in them, and your Inventor files will become useless! This is often the situation with people who play with their thread.xls file and find themselves unable to create thread features and bolted connections. So be careful and make sure that you backup your spreadsheet files.

So let us get started! The process of creating and using linked parameters in Autodesk Inventor will be divided into the following steps:


In creating an Excel spreadsheet file that will be linked to an Inventor file, a format must be followed. Just as the Parameters dialog box in Inventor, the parameters are arranged in rows and the parameter variables are arranged in columns. For such an Excel spreadsheet file, four variables are basically sufficient. They are:

  1. The parameter name;
  2. The parameter value;
  3. The parameter units; and
  4. The parameter comment.

For more about the different variables, check out this first lesson about parameters, Using and Understanding Parameters in Autodesk Inventor - Part 1. However, I will mention that you are not required to fill the Units column if the units of the parameters are the same as that of the template used in creating the Inventor file.


  1. Launch Microsoft Office Excel 2003, 2007 or 2010 through any means known to you. For Windows 7 and Vista users, go to Start Menu > All Programs > Microsoft Office > Microsoft Office Excel 200x.
  2. In the Excel environment, create the spreadsheet shown below.
  3. Figure 1
  4. Save the file with the name "Linked_Parameters" in the project folder of the project you wish to use. For example, mine is saved in the Training folder – which is the folder for my active Inventor project (C:\Users\Ndianabasi\Documents\Inventor\Training).


Here you are going to create a new Autodesk Inventor part file.


  1. In Autodesk Inventor, create a new part file using the Standard (mm).ipt template. Pressing CTRL+N is a fast way of achieving this. The Standard (mm).ipt template is found on the Metric tab of the New File dialog box.
  2. Use the Rectangle tool to create a rectangle over the center of the sketch.
  3. Constrain the rectangle to be centered around the center of the sketch using the Vertical and Horizontal constraints. Finish the sketch and save the file as Linked_Parameters.ipt.
  4. Figure 2


Here we are going to learn how to link the previously created spreadsheet file to the just created Inventor Part file.

  1. On the Ribbon, go the Manage tab > Parameters panel > Parameters tool. Click on the Link button at the bottom of the Parameters dialog box.
  2. Figure 3
  3. On the Open dialog box, scroll down the project folder and select the Excel spreadsheet file Linked_Parameters.xlsx or Linked_Parameters.xls depending on the Excel version that was used.
  4. At the bottom of the Open dialog box, change the Start Cell from A1 to A2. This value is changed because the actual parameter data starts from cell A2; the first row was used to define the column headers. Click the Open button.
  5. Figure 4
  6. The Excel parameters are now linked to the Parameters dialog box as shown below.
  7. Figure 5
  8. Click Done to close the dialog box.


In this section we are going to learn how to use the linked parameters inside the Inventor part file.

  1. Double click Sketch1 on the Model Browser of Linked_Parameters.ipt.
  2. On the Sketch tab > Constrain panel, click on the Dimension tool (Shortcut = D).
  3. Click one of the horizontal lines and click below the line to place the dimension. The Edit Dimension box should be displayed to allow you edit the size of the dimension. If it does not come up, right click on the graphics area immediately and activate Edit Dimension on the context menu.
  4. On the Edit Dimension box, while the dimensions to be edited are highlighted, click on the arrow pointing towards the right of the screen or right click the input area. Click List Parameters on the context menu.
  5. Figure 6
  6. The Parameters list box pops up with the three linked parameters. Click on Box_Length.
  7. Figure 7
  8. Click the green tick at the end of the Edit Dimension box to return the parameter.
  9. Repeat step 2 to 7 and dimension the vertical line using the Box_Width parameter.
  10. Click Finish Sketch on the Exit panel. Your unconsumed sketch should appear as shown below.
  11. Figure 8
  12. On the Model tab > Create panel, click on the Extrude tool (Shortcut = E). On the Extrude dialog box, highlight the Distance1 parameter and click the arrow pointing to the right of the screen. On the context menu, click List Parameters. On the Parameters list box, click Box_Height. Click OK to create the Extrude feature.
  13. Figure 9
  14. Save the file (CTRL+S).


Here we are going to learn how to changes to the values of parameters in the Excel spreadsheet file are reflected on the part file.

  1. Using Windows Explorer, navigate and open the Linked_Parameters.xlsx file saved in your project folder e.g. C:\Users\Ndianabasi\Documents\Inventor\Training\Linked_Parameters.xlsx.
  2. Change the value of Box_Height parameter to 20.
  3. Save and close the Excel file.
  4. Return to the part file and glance up at the Quick Access Toolbar at the top of the application just by the left of the title bar and by the right of the Menu Browser. Inventor has detected the changes make to the Excel spreadsheet file and indicates that an update is necessary.
  5. Click on the Local Update button on the Quick Access Toolbar as shown below.
  6. Figure 10
  7. The part updates accordingly.


I hope that the tutorial was beneficial. Drop a comment or contact me. Thanks for stopping by.


  1. Hi this tutorial was very useful. However, I am trying to link parameters of a part file to an assembly that contains the part. I am trying to make a torsional spring (made with a spiral coil) adaptive. coils are not adaptive, however if I can update the pitch to be :
    pitch = (spring Diameter / revolutions) and Revolutions = (no of active coils)+(angle/360)
    Angle = angle of a drive constraint
    all from within the assembly and make the coil sketch adaptive so the coil profile can turn, I think it should work. Any idea how to do that??
    Thanks alot

  2. Hello. I wrote an article as a response to your question. Please check it out by clicking the link below. Autodesk Inventor Tutorials: Linking Parameters Between Parts and Assemblies in Autodesk Inventor

  3. sir,can i know why my inventor(2011 version) will came out a dialog column about(the file into which you are placing this component has not been saved,this may cause problem in resolving links between the files).
    but i save the excel file already.

    1. Hi Tony,

      What the dialog box means is that you should save the part file or assembly file (with a name) first, before trying to link the Excel file into the part or assembly. Save the part file or assembly first with a name!!! Thanks for reading.

  4. Hello, congrats on the lessons. Good work. Let´s see if you can help me please.

    I've placed an assembly constrain that uses a parameter from linked file. But when I modify the parameter in the part it doesn't update autmatically in the assembly (even though it is marked as update automatically in the parameters of the assembly.) I have to manually, right click on the linked parameter > edit folder > remove it and it again for it to update. Any idea what I might be doing wrong.?

    1. Hello Eric,

      You said you had a parameter in a file (whether an excel or part file) that was linked into an assembly file, but whenever you modify the parameter the assembly file doesn't update automatically.

      Now, I will assume that you did everything correctly. Sometimes, Inventor does not automatically update a file especially when the trigger (in your case, a modification to an external parameter) is external to the file. Rather, Inventor would indicate on the Quick Access Toolbar that "Local or Global Update" are available. By not forcing the file to refresh and update, you can continue working with the current state until you really need the update to reflect on the file. Then, you click Update on the Quick Access Toolbar.

      *Note: The Quick Access Toolbar is the topmost toolbar on top of the User Interface, usually above the Panels.

      Let me know if this answered your question. Cheers.


Please drop a comment. Thank you.