Data from a large table may be lost when the data is pasted in an InfoPath 2003 form (822026)


The information in this article applies to:

  • Microsoft Office InfoPath 2003

SYMPTOMS

When you paste a large table of data in your InfoPath form, rows or columns of data may be dropped without warning.

CAUSE

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

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce the Problem

  1. In Microsoft 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.
Modification Type:MinorLast Reviewed:5/28/2004
Keywords:kbprb KB822026 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.