Inventor General Discussion

Reply
Distinguished Contributor
cadcamm99
Posts: 152
Registered: ‎04-12-2005
Message 1 of 6 (274 Views)

Edit Excel

274 Views, 5 Replies
12-02-2011 11:46 AM

I am using Inventor 2011.  I have an embedded Excel file with 7 rows.  If I edit the the excel object and add two more rows then go back to inventor, it only displays 7 rows instead of 9.  Any ideas to display all rows?

*Expert Elite*
mcgyvr
Posts: 6,720
Registered: ‎12-01-2004
Message 2 of 6 (267 Views)

Re: Edit Excel

12-02-2011 01:20 PM in reply to: cadcamm99

cadcamm99 wrote:

I am using Inventor 2011.  I have an embedded Excel file with 7 rows.  If I edit the the excel object and add two more rows then go back to inventor, it only displays 7 rows instead of 9.  Any ideas to display all rows?


yep.. Delete the table and reinsert it.. (I always use paste special for what its worth)

Changes to existing rows/columns update no problem.. But add a row and you need to delete/reinsert..

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

Down with IDW/DWG files..... Long live 3D PMI... Hurry it up already..
-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


Contributor
s.mutschler
Posts: 20
Registered: ‎07-24-2011
Message 3 of 6 (246 Views)

Re: Edit Excel

12-04-2011 09:38 AM in reply to: cadcamm99

This behavior is intentional relative to "embedded" Excel parameter tables.  If you use the "link" option instead of "embed", the table is maintained "external" to your part and any edits or extensions to that table will appear in your part (without having to delete and re-embed the table).

 

*Expert Elite*
mcgyvr
Posts: 6,720
Registered: ‎12-01-2004
Message 4 of 6 (229 Views)

Re: Edit Excel

12-05-2011 05:33 AM in reply to: s.mutschler

s.mutschler wrote:

This behavior is intentional relative to "embedded" Excel parameter tables.  If you use the "link" option instead of "embed", the table is maintained "external" to your part and any edits or extensions to that table will appear in your part (without having to delete and re-embed the table).

 


You make it sound so simple/foolproof.

Clearly you've never actually tried it in Inventor before.You will learn.

 

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

Down with IDW/DWG files..... Long live 3D PMI... Hurry it up already..
-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


Distinguished Contributor
cadcamm99
Posts: 152
Registered: ‎04-12-2005
Message 5 of 6 (211 Views)

Re: Edit Excel

12-06-2011 07:34 AM in reply to: s.mutschler

I was trying to avoid linking it because I have many drawings that use this table format and I didn't want to have to checkin all the excel files into Vault.  I wanted to use the table command in Inventor but I cannot format it the I want to so that is why I am using excel.

Contributor
s.mutschler
Posts: 20
Registered: ‎07-24-2011
Message 6 of 6 (194 Views)

Re: Edit Excel

12-06-2011 11:36 AM in reply to: cadcamm99

Ahhh.  Understood.  I missed the Vault management requirement and was referring only to the use of an Excel table to hold part parameters, not embedded OLE objects in part sketches.  In our case, the Link option is convenient when we want to attach the same Excel parameters table to multiple sub-parts.  (Files must be in the same work path as the related parts to avoid unwanted re-linkage prompts.)

 

We also often insert and display external Excel tables in Inventor (2012) drawings, in their entirety. Such tables automatically reflect current Excel file content (when the drawing is next opened).

 

(P.S. We do not use Vault.  We are using MS Exhange for storage and check-out control of collaboration project files, including Excel parameter tables, albeit we are a small team with few collisions.)

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