topic Re: Can't select threads (Threads.xls) Inventor 2017 in Inventor Forum

Can't select threads (Threads.xls) Inventor 2017

nicholas_provo — Wed, 03 Aug 2016 21:20:52 GMT

Hello all

I have a problem with creating threaded holes in inventor. Seems it can't open the Thread.xls file.

The thing is that I can place clearence holes. (so it opens the clearence.xls file)

So after looking; people in the past had the same problem:

http://www.inventortales.com/2014/03/cant-select-threads-in-autodesk.html

Looking in the register for inventor 2017 I cant find the register: UseExcelToReadThreadFile

This is very annoying and has to be fixed, can't place any threads at the moment!

Any ideas?

grt
NP

Re: Can't select threads (Threads.xls) Inventor 2017

Mark.Lancaster — Thu, 04 Aug 2016 00:24:51 GMT

@nicholas_provo

Welcome to the community...

When you create a thread is there any messages? What happens when you try to do it?

Do you have excel loaded on your machine? What version of Excel and has it been launched at least once?

Also try this:

Exit Inventor
Go to Control Panel > System> Advanced System Settings> System Properties, Advanced Tab.
Create a new Environmental variable called "UseLibXL" with a variable value of 1
Launch Inventor again and see what happens

Re: Can't select threads (Threads.xls) Inventor 2017

nicholas_provo — Thu, 04 Aug 2016 09:10:06 GMT

Hello

Thank you!

I already have an account on the community, its just i bought inventor for myself now 😉 that's why the new account!

There is no message, you can't select the radio button (it deselects immediately). I have excel 2010 and it has always been on my machine from the start 4 years ago. That's why I find it strange that there is no UseExcelToReadThreadFile in my register.

I will try the solution below tonight after work.

Thanks in advance!

Grt
NP

Re: Can't select threads (Threads.xls) Inventor 2017

nicholas_provo — Thu, 04 Aug 2016 16:34:11 GMT

Marc Lancaster

You are a hero!

This worked out for me:

Exit Inventor
Go to Control Panel > System> Advanced System Settings> System Properties, Advanced Tab.
Create a new Environmental variable called "UseLibXL" with a variable value of 1
Launch Inventor again and see what happens

Grt
NP

Re: Can't select threads (Threads.xls) Inventor 2017

Anonymous — Thu, 03 Jun 2021 18:37:57 GMT

muito obrigada mesmo, o problema foi resolvido seguindo direitinho todas as orientaçoes