Inventor 2016 - Hole feature bug

[marcusfriesl]

I have started using Invnetor 2016, and have found that the Hole feature brings up error windows.  I have checked to insure that both the thread.xls and clearance.xls are in the correct directory, and that inventor is pointing to the correct directory.

When I switch to anything other than a simple hole, I get two error windows, attached as images.  After those error windows, it looks like the options are just peaking up at the bottom of the dialogue box, but the box can not be expanded and I can't get to these options.  This is only a problem with the Hole feature.

The error messages are CLSIDFromProfID() failed and NULL IDispatch passed to AutoWrapper()

I have no Idea how to fix this, and any help would be greatly appreciated.

[ChrisMitchell01]

Yes, using LibXL won't give you all the functionality as compared to Excel; that's mentioned in the original posting from a long time ago when libXL was proposed for those who don't have Excel. If you have Excel installed then I would not use LibXL & suffer the delay when creating holes.

What specific Inventor version are you using ? There were some BOM export issues introduced in 2016 SP2 which sound familiar to what you mention. They should now have been addressed in the most recent 2016 update which was just released yesterday.

Thanks,
Chris

[Anonymous]

---

@ChrisMitchell01 wrote:

I've been doing some more investigations around this & there may be an unsupported workaround for those of you who don't have full install of Excel.

If you go to Control Panel, System, System Properties & then Advanced, you will be able to set an Environment variable. Create a new one called UseLibXL with a variable value of 1

Then retry your clearance/threaded hole creation in Inventor.

This will attempt to use a 3rd party component instead of Excel.

It doesn't support all aspects of what Excel provides but it should certainly work for holes.

Hope this helps,

Chris

---

This solve my issue, i have no idea why i was getting that error when i already have installed Excel 2016 but thank you!

[Anonymous]

---

@Anonymous wrote:

This solve my issue, i have no idea why i was getting that error when i already have installed Excel 2016 but thank you!

---

False alarm. I thought it was solved but i'm realizing that i'm able to create just some sizes of nuts, others are still getting error

[Anonymous]

Works perfectly! Thanks very much for the workaround.

[gilsonDN2G6]

Thanks Bro!