I can drill a hole as needed, but can't thread a hole at all. Not with the Tapped Hole function when drilling the hole, or after drilling the hole then using the Thread Tool. Inventor will just not let me create threads this way outside of cutting a coil.
If anyone knows why this is happening, what I'm doing wrong, and could help me out, it would be greatly appreciated.
Thanks!
Do you have Microsoft Excell 2003 or 2007 on your system? Has it been run once?
Excel is required for many portions of Inventor to work properly.
What version of Inventor are you running?
I'm running Inventor Pro 2011.
I don't have any Microsoft Office products as I use OpenOffice.org.
I went through my registry and made a change that tells Inventor to use Excel or some other Windows program.
Changed it to use Excel, and everything works fine now, even though I don't have Excel.
Appreciate you getting back with me though. Hopefully I don't have to make another post for this.
Even though, OpenOffice can read and write Excel files, there are slight changes to the file handling characteristics. The easiest solution to this would be to install Microsoft Excel as listed in the Autodesk Inventor system requirements.
I have the same problem with thread holes, would you mind telling me how you changed your registry to make Inventor use Excel? Thank you in anticipation for your early reply.
Marco Bellante
See attached.
When I encountered this problem I found that the project I was working with had the "Design Data" project folder option changed.
Some time back, I used the Style Library Manger to create an empty Style Library in a new folder. I then used that empty Style Library as the "Design Data" folder for my project. What I did not realize was that I would lose the
thread functionality when I created the empty style library.
If the "Design Data" folder is not the default folder, the "thread.xls" may be missing. Or as in my case, the "thread.xls" was there, but that it was an empty Excel file.
Since Inventor fails to find any thread data in the "thread.xls" Excel file, it does not allow for the tread option to be selected.
Lesson learned: Never create an empty style library. Always copy the default style library and then modify that copy.
Hello,
i have the same problem.The real problem is that my computer are two users.me and adminsitrator.For my account the thread doesn'n work but for administrator user yes. How could i fix that? There is a solution for my problem?
Best regards,
Olivian
If it can find the folder when you are logged in as Administrator, I would look at increasing your user level to a minimum of Power-User (as recommended by Autodesk).
You could have a problem with your User Profile on the system (may need to recreate), but I would look at sercurity levels first.
Ok, but how to go to registry ,and in which folder can i make this change? I have Libre office, should i turn it into ms office?
This thread concerns OpenOffice and Inventor. The Word Document posted in this thread explains how to go about editing the Windows Registry.
Never heard of Libre Office before, I have no idea how it interfaces. Best suggestion would be to install OpenOffice, you might be able to use the current version of OpenOffice without having to edit the Windows Registry.
Hi!
I have the same issue but I have Inventor professional 2017. So in the regedit the registryVersion is 21.0. There is no file called "UseExcelToReadThreadFile" under the part folder. I tried to add new DWORD and name it "UseExcelToReadThreadFile" and change value 0 to 1 but it didn'd work.
@Anonymous wrote:
Hi!
I have the same issue but I have Inventor professional 2017. So in the regedit the registryVersion is 21.0. There is no file called "UseExcelToReadThreadFile" under the part folder. I tried to add new DWORD and name it "UseExcelToReadThreadFile" and change value 0 to 1 but it didn'd work.
@Anonymous Thats really old/outdated information now..
Do you have Excel installed?
Do you want to use iparts/ifeatures,etc...?
If not try this..
you can create the following Environmental variable:
This will attempt to use the 3rd party component in Windows instead of Excel. It doesn't support all aspects of what Excel provides but it should work for holes.
If you work with other features like iPart, iFeature which require Excel, please use the full Version of Excel. This is specified as system requirement for Inventor:
Hi!
I have Excel and I don't try to use iparts or ifeatures. I'm just trying to make threads on the shaft and in the holes..
Can you post the offending IPT file(s) that are showing this behavior.
Hi! Is the Excel the one with Excel.exe on your machine? Inventor needs Excel.exe installed on the machine to enable certain Excel dependent workflows.
Many thanks!
Can't find what you're looking for? Ask the community or share your knowledge.