This is the first in a number of guest posts on the Autodesk MFG Blog from users with some great tips & tricks to share. If you want to share your tips & tricks, click here.....
Today UK based Autodesk Inventor user Paul Munford shares his tip on configuring Autodesk Inventors hole and thread data. Take it away Paul.....
Autodesk Inventor provides great support for many local, national and international drawing standards. How can you put your standard at the top of the Threads and Clearance lists?
If you are living and working in Northern Europe, it is likely that you are using the ISO standard, or your own National or Local standard. If you have installed multiple standards with Autodesk Inventor, you may find that the ANSI standard is at the top of the list!
You can easily put the ISO (or your own) standard at the top of the list used by the Hole tool and the Thread tool and save yourself countless picks and clicks.
There are five steps:
- You will need to close Inventor down.
- You will need to find which copy of the Thread.xls and Clearance.xls your current project is using.
- You will need to create a back up copy of these files.
- You will need to edit these files.
- You will need to start Inventor up to test your changes.
Finding your Thread and clearance file path:
Inventor uses two Excel spreadsheet files to contain all the data required by the Hole tool and the Thread tool.
The Thread.xls file contains all the data for internal and external threads, and the Clearance.xls file contains all the data for unthreaded holes.
You can find both of these files in the Design Data folder, usually within your documents path:
C:\Users\Public\Documents\Autodesk\Inventor 2011\Design Data
Tip: If you don't find your thread and clearance xls files in this folder, check the Libraries path in your project filefor the location.
Edit the Thread file
Make sure that Inventor is shut down and that you have backed up the thread.xls file before you go tinkering!
Open the Thread.xls file in Excel and check out the value of the cell ‘D1’ on any tab. As you can see, cell D1 contains a value for ‘Sort order’. By changing this value you can re-sort the order in which Inventor will display the information in the Hole and thread tools.
In the screen shot below, you can see that I have set the value of cell D1 to ‘sort order - 1’ on the ISO metric profile tab to bring this to the top of the list.
I then edited the value of D1 on the ANSI tab to make sure that there was no conflict in values.
Tip: Make sure that Excel saves the file as an XLS file – not the newer XLSx format.
Tip: Don’t forget to make sure that the cell D1 on each sheet contains a unique value!
Edit the Clearance file
Make sure that Inventor is shut down and that you have backed up the clerance.xls file before you go tinkering!
Editing the Clerance.xls file is very similar, but this time we need to edit the value of cell B1. Once again I have edited the values in the ISO sheet and the ANSI sheet to make sure that there is no conflict.
Tip: Make sure that Excel saves the file as an XLS file – not the newer XLSx format.
Tip: Don’t forget to make sure that the cell B1 on each sheet contains a unique value!
Restart Inventor and check it out!
Start up Inventor, try out a hole or thread and check it out!
The updated hole tool:
The updated thread tool:

Job Done!
Making this quick edit to your Threads and Clearances data files will save you having to select your preferred standard every time you use the Hole and Thread tools
About the CAD Setter Out.
Paul Munford is a Joinery draughtsman (a ‘Setter Out’) for Beck Interiors; a UK based international Interior Fit out contactor which specializes in Museum Interiors.
Paul uses AutoCAD and Autodesk Inventor to create manufacturing ‘Workshop’ drawings day in – day out.
In his spare time Paul writes the ‘CAD Setter Out’ Blog and wishes he got out more.