Inventor General Discussion

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

Edit Excel

285 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,928
Registered: ‎12-01-2004
Message 2 of 6 (278 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.

-------------------------------------------------------------------------------------
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 (257 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,928
Registered: ‎12-01-2004
Message 4 of 6 (240 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.

-------------------------------------------------------------------------------------
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: 155
Registered: ‎04-12-2005
Message 5 of 6 (222 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 (205 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.)

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 or visit the Installation and Licensing Forum to get help installing your software.