Inventor Training - Change Inventor Clearance Hole and Thread Type

Change Inventor Clearance Hole and Thread Type

One of the frustrations for many users applying clearance holes and threads is that it defaults to ANSI. For many users in the UK & areas of Europe they may want ISO, DIN or their custom standard as the default.

With this handy Inventor training tip you can easily do this by making a simple modification to two Inventor spread sheets, and from then on your default will be whatever you want it to be.

Simply follow the steps detailed below:

1. Close Inventor
2. Go to the following location on your machine: C:\Users\Public\Documents\Autodesk\Inventor 2013\Design Data\xls\enus (NOTE: If the design data your project references is on the servers you will need to navigate to this location)
3. Create a backup copy of spread sheets Thread.xls & Clearence.xls
4. Edit Thread.xls


Each tab in the spread sheet represents a thread type available. On each tab the cell D1 contains a 'sort order' with a value.

The sort order value represents where on the thread/hole list the standard will appear. If I change the value of the cell D1 on the ISO tab to 'sort order -1' ISO will appear at the top of the list.

Make sure the sort order on each tab is unique.

In this example I simply changed the sort order for ANSI Metric M Profile to 'sort order -3' this will switch the two standards around on the thread list.

5. Close and save Thread.xls ensuring retains the file extension .xls and not .xlsx (NOTE: A simple save as can fix this if the file type has changed)
6. Edit Clearence.xls


The procedure for this is very much the same as step 4, the only difference is we are changing the value in the cell B1.




 7. Close and save Thread.xls ensuring retains the file extension .xls and not .xlsx (NOTE: A simple save as can fix this if the file type has changed)

8. Restart Inventor and try hole or thread tool


If you wanted to remove standards from the threads and clearances all you need to do is delete the tabs from the spread sheets.

Once again you must ensure the sort order number for each tab is unique and they increment correctly i.e. three tabs with sort orders -1,-2,-3 not -1,-4,-7.

Hopefully this handy tip will help take away any frustrations you may have and help you define your standards.

If you need any further help or would like to attend any of our scheduled Cad courses or attend Inventor advance or intermediate training please give us a call. If you have any other enquiries, please send us a message:

Request More Information

Usain Bolt Vs HP Officejet Pro X Series
Inventor Vault 2013 Update

Related Posts

By accepting you will be accessing a service provided by a third-party external to

Autodesk reseller uk logo2
qms microsoft logo