Missing rows from inserted Excel object

[Anonymous]

I have a drawing with several tables that are inserted Excel objects.  In some cases, the tables are truncated after the tenth row (although some tables longer than ten rows are not truncated).  Has anyone seen this before?  I can't find any difference between the tables that would explain it.

[mcgyvr · Accepted solution]

yes..very common.. Its a Microsoft OLE limitation..

There are a few tricks that sometimes work..

1 is to simply reduce the font size used in your excel table.

Also sometimes copying from excel and using "paste special" in Inventor works better than using "insert object"

You can also break your table up into smaller bits (or just select smaller sections then copy) and then in Inventor paste special for each section/bit.

Oh and if your table is very generic you can use Inventors table command with the excel table as the data source.. But Autodesk table command is SOOOO basic it really doesn't support anything (merged cells/cell color,etc..)

[Anonymous]

Paste Special worked like a charm.  Thanks very much for the idea.