Your thread and threaded hole options are no longer working in Inventor.
If you try to use the Thread command in the Ribbon, you see the dialog box briefly flash on screen as if trying to open but it doesn't.
Also when in the Hole command, you try to use any of the clearance or tapped holes but you're unable to select those options.
The first thing to verify is that the Thread.xls file is in the project's Design Data folder.
Go to the Get Started Ribbon and choose Projects. In the Folder Options section at the bottom, get the Design Data path.
If the Excel file is located in the Design Data folder, it'll be located in the subfolder XLS\en-US\Thread.xls for Inventor 2013. In older versions it'll be located at the root in ...\Design Data\Thread.xls
If it is there, obtain a Thread.xls from a system where the command works and replace the existing file.
If you don't have access to a system with a Thread.xls that works, search on the Inventor 2013 media for this file name. The Thread.xls can be copied from this location to the Design Data folder you're using.
Restart Inventor to get the thread command to work again.
If the thread command still doesn't work, try editing the following setting in the Registry Editor. This forces it to use Microsoft Excel.
Go to the Windows Start menu, type in Run in the Search.
In the Run dialog box type in regedit, then select OK.
Warning:Problems caused by improperly editing the Windows registry could render your computer operating system unusable. Microsoft provides a wealth of critical information that you need to know about the registry in the Microsoft Knowledge Base at http://support.microsoft.com/support.
Browse to the following folder in the registry:
Where x will depends on the version of Inventor you need to edit.
x=7 for Inventor 2013
x=6 for Inventor 2012
x=5 for Inventor 2011 etc.
In the Part folder edit the UseExcelToReadThreadFile entry. Change the default Value data from 0 to 1.