Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
Using Excel INDIRECT function and linking to inventor not working
Using Excel INDIRECT function and linking to inventor not working
Hi, I am using a spreadsheet to drive an automation in inventor. In my spreadsheet I have many named ranges and I found it useful to use the INDIRECT function in some of my sheets. The problem I am having is that Inventor craps out whenever I try to link it to a cell using the indirect function. Also it seems to stop all other variables from being linked even though they are not using the indirect function.
We are using excel automation dll's in order to do certain calculation functions in excel and I don't think they would be compatible in 2003. Everything in our spreadsheet worked fine until we used the INDIRECT function which is built into excel. Is there no other way of getting this to work?
![Autodesk Design & Make Report](https://forums.autodesk.com/t5/image/serverpage/image-id/1350519iCB55845EBFC43016/image-size/large?v=v2&px=999" "Autodesk Design & Make Report")