Inventor General Discussion

Inventor General Discussion

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

Edit Excel

296 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: 7,248
Registered: ‎12-01-2004
Message 2 of 6 (289 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 (268 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: 7,248
Registered: ‎12-01-2004
Message 4 of 6 (251 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: 161
Registered: ‎04-12-2005
Message 5 of 6 (233 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 (216 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.)

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.