I am going through the tutorial for Inventor 2014 and having trouble with the Parameters tutorial where I link an Excel file. In the "Link Your External Table" section, I select my .xls file and click "Open". Instead of showing me a list of the data in the .xls file, I get a single line in the Paramters form that says "Embedding 1". This line can't be expanded, so I can't see if anything was imported.
When I try to do the "Modify Your Sketch Dimensions" section and try to change d3 from 10 to base I get "The expression cannot be evaluated."
What am I doing wrong? .xls attached.
Solved! Go to Solution.
Attach your ipt file here.
Do you have MS Excel installed on this machine and have you run it at least once?
Did you have cell A1 set as the start cell? (should have been by default - so nothing really to change)
Have you installed Update 1 & 2 for Inventor 2014?
I just installed Inventor 2014 last week in trial mode. Do I still need to install the updates? I am running Build 170, Release 2014RTM - Date Thu 02/28/2013. How do I install updates?
Yes, I am using cell A1 and have run Excel before. .ipt attached.
Download zip file from here
Right click on the filename and Extract.
Double click the exe file.
This will install Updates 1 & 2.
Not sure if the problem is addressed in the Updates, but this should be working (it worked on my machine).
If it still doesn't work you should go to Control Panel and right click on Inventor and try a Repair Install.
Thanks for the Response JDMather. Unfortunately installing the updates and repairing the install had no effect. I still just get an unexpandable "Embedded" line in the parameters and can't use the variables in Sketch dimensions.
I don't know where to go from here - hopefully someone from Autodesk will respond.
I have done successfully several times using the files you attached in trying to figure out if there is something you might be doing wrong.
I suspect it might be a bad install of Inventor, but if I you did a Clean Uninstall and then reinstall I am afraid that would automatically void your 30-day trial.
Is there anything else not working?
Does Environments>Inventor Studio work?
Did you install with anti-virus and UAC temporarily turned off during the install?
Ah ha, I think I know what's going on. Am I required to have Excel installed on the same computer as AI in order to use an excel file (.xls) for Parameters? I'm running AI on a Mac via Parallels and I don't have MS Office for Windows. I created my .xls file using the Mac spreadsheet application "Numbers" and saving as .xls.
The clue was trying to open Studio and getting "Microsoft Excel is required to animate Positional Representations."
Didn't know I was also going to have to buy MS Office in order to use all the features of AI :-/
... I'm running AI on a Mac via Parallels and I don't have MS Office for Windows. I created my .xls file using the Mac spreadsheet application "Numbers" and saving as .xls.
Why would you leave information like this out of your original problem description?
Yes, sorry about that. I had no idea it was relevant. I see now that the tutorial even says "Note: You must have Microsoft Excel installed on your computer to complete this tutorial.", but I didn't grasp that they really meant "...on the computer where you are running AI" and not simply as a source for the .xls file.
Thanks for the help JDMather!
I just purchased and installed MS Office 2013 and now when I launch AI I get "Serious Error: VBA failed to initialize properly - please restart Inventor." I found a solution at:
Close Inventor session and manually install VBA7 from Inventor source media:
Install VBA7 from "3rdParty\x64\VBA\Vba7.MSI" .
but since I downloaded the trial of Inventor from the Autodesk website I have no media (and I can't find a Vba7.MSI anywhere on my hard disk). I now can't open any AI files at all.
What do I do now? If I uninstall and reinstall AI I suspect I kill my 30 day trial period, right?
Start with some of our most frequented solutions to get help installing your software.