Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Data from a large table may be lost when you paste the data in an InfoPath 2007 form or in an InfoPath 2003 form

View products that this article applies to.


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.

↑ Back to the top


Tables in InfoPath forms are limited to 999 rows and 63 columns.

↑ Back to the top


This behavior is by design.

↑ Back to the top

More information

Steps to reproduce the problem

  1. In Microsoft Office Excel, create a new workbook.
  2. Select cells A1:A1000.
  3. Type the formula =ROW(), and then press CTRL+ENTER to fill all 1000 cells with this formula.
  4. On the Edit menu, click Copy.
  5. Start InfoPath. Design a new blank form.
  6. On the Edit menu, click Paste.

    The table of data is pasted in the form.
  7. 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.
  8. 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.

↑ Back to the top

Keywords: KB822026, kbprb

↑ Back to the top

Article Info
Article ID : 822026
Revision : 4
Created on : 11/8/2006
Published on : 11/8/2006
Exists online : False
Views : 360