Inventor General

Reply
Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 1 of 12 (333 Views)
Accepted Solution

Trouble with Parameters tutorial

333 Views, 11 Replies
07-30-2013 12:36 PM

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.

 

 

 

*Expert Elite*
JDMather
Posts: 26,186
Registered: ‎04-20-2006
Message 2 of 12 (324 Views)

Re: Trouble with Parameters tutorial

07-30-2013 01:04 PM in reply to: jeffcarson

 

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?

Please mark this response as "Accept as Solution" if it answers your question.
-----------------------------------------------------------------------------------------
Autodesk Inventor 2014 Certified Professional
Autodesk AutoCAD 2013 Certified Professional
Certified SolidWorks Professional
Inventor Professional 2015 64-bit
http://www.autodesk.com/edcommunity
http://home.pct.edu/~jmather/content/DSG322/inventor_surface_tutorials.htm
Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 3 of 12 (295 Views)

Re: Trouble with Parameters tutorial

07-31-2013 02:32 AM in reply to: JDMather

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.

 

- Jeff

*Expert Elite*
JDMather
Posts: 26,186
Registered: ‎04-20-2006
Message 4 of 12 (291 Views)

Re: Trouble with Parameters tutorial

07-31-2013 03:48 AM in reply to: jeffcarson

Download zip file from here

http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=21901957&linkID=9242019#

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.

 

Please mark this response as "Accept as Solution" if it answers your question.
-----------------------------------------------------------------------------------------
Autodesk Inventor 2014 Certified Professional
Autodesk AutoCAD 2013 Certified Professional
Certified SolidWorks Professional
Inventor Professional 2015 64-bit
http://www.autodesk.com/edcommunity
http://home.pct.edu/~jmather/content/DSG322/inventor_surface_tutorials.htm
Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 5 of 12 (280 Views)

Re: Trouble with Parameters tutorial

07-31-2013 06:02 AM in reply to: JDMather

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.

 

:-/

*Expert Elite*
JDMather
Posts: 26,186
Registered: ‎04-20-2006
Message 6 of 12 (276 Views)

Re: Trouble with Parameters tutorial

07-31-2013 06:17 AM in reply to: jeffcarson

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?

Please mark this response as "Accept as Solution" if it answers your question.
-----------------------------------------------------------------------------------------
Autodesk Inventor 2014 Certified Professional
Autodesk AutoCAD 2013 Certified Professional
Certified SolidWorks Professional
Inventor Professional 2015 64-bit
http://www.autodesk.com/edcommunity
http://home.pct.edu/~jmather/content/DSG322/inventor_surface_tutorials.htm
Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 7 of 12 (252 Views)

Re: Trouble with Parameters tutorial

07-31-2013 01:02 PM in reply to: JDMather

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 :-/

 

Thanks JDMather!!

 

*Expert Elite*
JDMather
Posts: 26,186
Registered: ‎04-20-2006
Message 8 of 12 (245 Views)

Re: Trouble with Parameters tutorial

07-31-2013 02:12 PM in reply to: jeffcarson

jeffcarson wrote:

...  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?

Please mark this response as "Accept as Solution" if it answers your question.
-----------------------------------------------------------------------------------------
Autodesk Inventor 2014 Certified Professional
Autodesk AutoCAD 2013 Certified Professional
Certified SolidWorks Professional
Inventor Professional 2015 64-bit
http://www.autodesk.com/edcommunity
http://home.pct.edu/~jmather/content/DSG322/inventor_surface_tutorials.htm
Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 9 of 12 (224 Views)

Re: Trouble with Parameters tutorial

08-01-2013 12:57 AM in reply to: JDMather

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.

 

My bad.

 

Thanks for the help JDMather!

 

Contributor
jeffcarson
Posts: 25
Registered: ‎07-16-2013
Message 10 of 12 (212 Views)

Re: Trouble with Parameters tutorial

08-01-2013 04:35 AM in reply to: jeffcarson

Wonderful.

 

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:

 

http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=21910314&linkID=9242018

 

Which says:

 

Close Inventor session and manually install VBA7 from Inventor source media:

64-bit 

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?

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube