Inventor - Controlling Bolted Connections by Editing the Excel Hole Tables

Learn how to adjust your bolted connections in Autodesk Inventor with this step-by-step guide. Discover how to customize hole configurations by editing the Excel spreadsheet embedded within your Inventor software. By editing the tables in these spreadsheets, you can fine-tune clearance, tapped, and taper-tapped hole settings with ease. We hope you find this tutorial useful, and let us know if you have any questions below!
Link to blog post: go.d3tech.net/inventor-blog/c...

[@jdsalinger73]

Pete Strycharske! Hey, not sure if you monitor the comment section, but this is Brian Chute. I found this channel while searching for Inventor tutorials. Good to see you, old friend!

[@edouardstringer3601]

Pete,
I know that there is a .preset file for the custom presets, do you know if there is a way to make that into an Excel based system? Or maybe it already exists somewhere?

[@Team-D3]

@edouardstringer3601, thanks for reaching out! I'm not aware of a way to control the .Preset file via Excel. However, it looks like XML files can be imported into Excel, manipulated and then exported back to XML format. I'll have to do some testing to see how efficient that is. Initially it doesn't look good, as Excel isn't reading the .Preset as an XML file...
It may be more efficient to edit the file with some sort of XML editor. Let me know if you have any further questions and I'd be happy to dig into things further. Thanks for your patience, hope all is well and have a most blessed day!
- Pete