Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Turn on suggestions
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: 

Spread Sheet Parameters

17 REPLIES 17
Back to Inventor Category
Back to Topic Listing
Reply
Message 1 of 18
Anonymous
376 Views, 17 Replies
‎11-11-2003 04:52 AM
‎11-11-2003 04:52 AM

Spread Sheet Parameters

I have an assembly where the parts are being driven by Parameters using a
Linked Spread Sheet. I have updated some of the parameters, 5 parts updated
correctly but 2 are being stubborn and refuse to update to any of the new
dimensions. One of the parts was started in 5.3 with parameters, but
completely redone in 6 using the Spread Sheet the other was done in 7 using
the Spread Sheet from the start. Any ideas on how to fix this problem,
would be greatly appreciated.

msk
Report
0 Likes
Reply
17 REPLIES 17
Message 2 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 05:07 AM
‎11-11-2003 05:07 AM

Without seeing the part/excel sheet...

Are any of the parameter cells yellow in the part file?
Are the units messed up in the Excel sheet?

Post the part/excel sheet and we'll have a look.

--
Sean Dotson, PE
http://www.sdotson.com
Check the Inventor FAQ for most common questions
www.sdotson.com/faq.html
-----------------------------------------------------------------------
"Mark S. Klein" wrote in message
news:5399702042317A07EFF658A4A89313F2@in.WebX.maYIadrTaRb...
> I have an assembly where the parts are being driven by Parameters using a
> Linked Spread Sheet. I have updated some of the parameters, 5 parts
updated
> correctly but 2 are being stubborn and refuse to update to any of the new
> dimensions. One of the parts was started in 5.3 with parameters, but
> completely redone in 6 using the Spread Sheet the other was done in 7
using
> the Spread Sheet from the start. Any ideas on how to fix this problem,
> would be greatly appreciated.
>
> msk
>
>
Report
0 Likes
Reply
Message 3 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 07:18 AM
‎11-11-2003 07:18 AM

Sean I just sent it in thanks for all your help. right now I'm debating
making the top half removable. Need to start cutting wood around Christmas

msk
Report
0 Likes
Reply
Message 4 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 07:58 AM
‎11-11-2003 07:58 AM

You posted in customization instead of iCF but I got them anyway.

Updated correctly for me. A few things I noticed. You should use units in
all parameters, most of them are missing.

What version and SP are you using?


--
Sean Dotson, PE
http://www.sdotson.com
Check the Inventor FAQ for most common questions
www.sdotson.com/faq.html
----------------------------------------------------------------------------
------
"Mark S. Klein" wrote in message
news:D807F24F11084D2FF384A516D000B0AC@in.WebX.maYIadrTaRb...
> Sean I just sent it in thanks for all your help. right now I'm debating
> making the top half removable. Need to start cutting wood around Christmas
>
> msk
>
>
Report
0 Likes
Reply
Message 5 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 08:27 AM
‎11-11-2003 08:27 AM

They are now in IVCF

--
Kent
Assistant Moderator
Autodesk Discussion Forum Moderator Program


"Sean Dotson" wrote in message
news:8EF268F0D4707AF0C2525870B8992C03@in.WebX.maYIadrTaRb...
> You posted in customization instead of iCF but I got them anyway.
Report
0 Likes
Reply
Message 6 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 09:10 AM
‎11-11-2003 09:10 AM

Sorry about that wrong posting , iv7 sp1, OS W2000 sp3. I didn't even
notice that I hadn't added the units on most lines. What good is putting in
the column if you don't fill it out. I filled in all the units and opened
the file again, still have both sides wrong height and depth.

msk
Report
0 Likes
Reply
Message 7 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 10:28 AM
‎11-11-2003 10:28 AM

What version and SP? Like I said I opened it up, hit update and all was
well.

--
Sean Dotson, PE
http://www.sdotson.com
Check the Inventor FAQ for most common questions
www.sdotson.com/faq.html
----------------------------------------------------------------------------
------
"Mark S. Klein" wrote in message
news:5EF0C01BA400F745C3F189653049E54C@in.WebX.maYIadrTaRb...
> Sorry about that wrong posting , iv7 sp1, OS W2000 sp3. I didn't even
> notice that I hadn't added the units on most lines. What good is putting
in
> the column if you don't fill it out. I filled in all the units and opened
> the file again, still have both sides wrong height and depth.
>
> msk
>
>
Report
0 Likes
Reply
Message 8 of 18
Anonymous
in reply to: Anonymous
‎11-11-2003 08:52 PM
‎11-11-2003 08:52 PM

Another thought. Try Rebuild All from the tools menu. That sometimes
relinks everything.

Also if you have a very slow network you will see parts not updating. When
I get lazy and work off my USB drive I sometimes see parts that are linked
not updating. Move it to my local and all work well.

Hope this helps.

--
Sean Dotson, PE
http://www.sdotson.com
Check the Inventor FAQ for most common questions
www.sdotson.com/faq.html
-----------------------------------------------------------------------
"Sean Dotson" wrote in message
news:A1550DDB50A3A9C6FE99052B467D6FA2@in.WebX.maYIadrTaRb...
> What version and SP? Like I said I opened it up, hit update and all was
> well.
>
> --
> Sean Dotson, PE
> http://www.sdotson.com
> Check the Inventor FAQ for most common questions
> www.sdotson.com/faq.html
> --------------------------------------------------------------------------
--
> ------
> "Mark S. Klein" wrote in message
> news:5EF0C01BA400F745C3F189653049E54C@in.WebX.maYIadrTaRb...
> > Sorry about that wrong posting , iv7 sp1, OS W2000 sp3. I didn't even
> > notice that I hadn't added the units on most lines. What good is putting
> in
> > the column if you don't fill it out. I filled in all the units and
opened
> > the file again, still have both sides wrong height and depth.
> >
> > msk
> >
> >
>
>
Report
0 Likes
Reply
Message 9 of 18
Anonymous
in reply to: Anonymous
‎11-13-2003 03:45 PM
‎11-13-2003 03:45 PM

I have mentioned this before but be sure to check the version of excel you are using is for Win2k and not XP. I was doing this and found the same problem occuring on non specific files, or at least I could find no common relationships. Let me know if you find anthing tho.
Report
0 Likes
Reply
Message 10 of 18
Anonymous
in reply to: Anonymous
‎11-13-2003 03:47 PM
‎11-13-2003 03:47 PM

hmm...
When I was having problems I was most likely working on USB drive, as I usually do and never considered that might be the problem. Hoever it was never a problem after reinstalling an older Office 2000 version of excell rather then the Office XP that came on the machine.
Report
0 Likes
Reply
Message 11 of 18
xavierl
Advocate
in reply to: Anonymous
‎11-13-2003 05:14 PM
‎11-13-2003 05:14 PM

I run Office 2000 and iv runs fine.

When will I have to update MSOffice?This is one program I dont want to update in a hurry.

Frans X Liebenberg
Report
0 Likes
Reply
Message 12 of 18
Anonymous
in reply to: Anonymous
‎11-13-2003 05:29 PM
‎11-13-2003 05:29 PM

Running Excel 97 here fine, so I guess you probably won't have to upgrade
too soon!

--
Cheers

Rob Singlehurst
"fxlxd" wrote in message
news:f19bd8f.9@WebX.maYIadrTaRb...
> I run Office 2000 and iv runs fine.
> When will I have to update MSOffice?This is one program I dont want to
update in a hurry.
> Frans X Liebenberg
Report
0 Likes
Reply
Message 13 of 18
xavierl
Advocate
in reply to: Anonymous
‎11-13-2003 05:44 PM
‎11-13-2003 05:44 PM

thanks. fxl
Report
0 Likes
Reply
Message 14 of 18
Anonymous
in reply to: Anonymous
‎11-13-2003 10:11 PM
‎11-13-2003 10:11 PM

The older versions work fine its the XP version, Office XP 2003 or 2002, that I had problems with.
Report
0 Likes
Reply
Message 15 of 18
xavierl
Advocate
in reply to: Anonymous
‎11-13-2003 11:05 PM
‎11-13-2003 11:05 PM

Is it correct that Excell needs to be installed before Inventor is installed.?
I checked for documentation about Excell and there is nothing. The only info is on the web site under system requiements


Additional Requirements

Internet connection for web downloads
Microsoft® Internet Explorer 6 or later
Microsoft® Excel 97 (2000 or XP preferred) for iparts, ifeatures, threads, and spreadsheet driven designs



It would be practical for this info to be on the box or on the first page of the user manual. There have been a few occasions on this forum where people did not even know they had to have Excell installed.

my 2 cents...

Frans X Liebenberg
Report
0 Likes
Reply
Message 16 of 18
Anonymous
in reply to: Anonymous
‎11-13-2003 11:55 PM
‎11-13-2003 11:55 PM

See this page

 


 

at the bottom it says you need Excel (and
MSIE)


--
Sean Dotson, PE

href="http://www.sdotson.com">http://www.sdotson.com
Check the Inventor
FAQ for most common questions

href="http://www.sdotson.com/faq.html">www.sdotson.com/faq.html
-----------------------------------------------------------------------


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Is
it correct that Excell needs to be installed before Inventor is installed.?

I checked for documentation about Excell and there is nothing. The only
info is on the web site under system requiements

Additional Requirements

Internet connection for web downloads
Microsoft® Internet Explorer 6 or
later
Microsoft® Excel 97 (2000 or XP preferred) for iparts, ifeatures,
threads, and spreadsheet driven designs

It would be practical for this
info to be on the box or on the first page of the user manual. There have been
a few occasions on this forum where people did not even know they had to have
Excell installed.
my 2 cents...
Frans X
Liebenberg

Report
0 Likes
Reply
Message 17 of 18
xavierl
Advocate
in reply to: Anonymous
‎11-14-2003 12:32 AM
‎11-14-2003 12:32 AM

I still maintain there should be a message in bold print on the box saying that MSIE and Excell are needed to run Inventor. The real cost of Inventor is then us$5000 plus whatever MSOffice costs. To save costs some design offices are not running msoffice on every single computer.

I just checked the other SW also requires Excell xp, so I guess this would only really be for someone new to the field of solid modelling.

regards, Frans X Liebenberg and its Friday...
Report
0 Likes
Reply
Message 18 of 18
Anonymous
in reply to: Anonymous
‎11-14-2003 03:35 AM
‎11-14-2003 03:35 AM

Not having that problem as it is loaded
locally, so I should not have network lag. Also drives are all scsii, so speed
should be ok, cpu a bit slow P3 800, mem at 512k. Also I'm using office 200 not
XP.

 

    I was having this problem with
only one part that has 2 instances in the assy all others updated fine. Also I
had updated this assy before with no problems, all parts had new
dimensions.  I did finely get it to update the part, I replaced the three
dimensions on part with numbers.  Then I deleted the spreadsheet saved the
file then relinked the spreadsheet. Finley I went back in and replaced the hard
dim's with the equations again now all updates correctly. All I can think off is
got a glitch maybe when I brought it into IV7.

       
               
               
               
               
        msk
Report
0 Likes
Reply
Reply

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

Report a website issue