Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 822026 - Last Review: November 8, 2006 - Revision: 2.2
Data from a large table may be lost when you paste the data in an InfoPath 2007 form or in an InfoPath 2003 form
When you paste a large table of data in a Microsoft Office InfoPath 2007 form or in a Microsoft Office InfoPath 2003 form, rows or columns of data may be dropped without warning.
Tables in InfoPath forms are limited to 999 rows and 63 columns.
This behavior is by design.
Steps to reproduce the problem
- In Microsoft Office Excel, create a new workbook.
- Select cells A1:A1000.
- Type the formula =ROW(), and then press CTRL+ENTER to fill all 1000 cells with this formula.
- On the Edit menu, click Copy.
- Start InfoPath. Design a new blank form.
- On the Edit menu, click Paste.
The table of data is pasted in the form. - Locate the end of the table.
Notice that although you copied 1000 rows, only 999 rows were actually pasted. The last row was truncated without warning. - Right-click inside the table, point to Insert, and then click Rows Above.
You receive the following error message:This exceeds the maximum number of rows.
APPLIES TO
- Microsoft Office InfoPath 2007
- Microsoft Office InfoPath 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate