Item Limitation for Custom Data Forms

• Microsoft Excel for Windows, versions 2.1 and 3.0

SUMMARY

When creating a custom data form, if the number of rows or items in the definition table exceed 64, you will receive a "Data Form Not Correct" error message when you try to use the Data menu's Form command. The only workaround in this case is to reduce the number of rows in the custom data form definition table to 64 or less.

MORE INFORMATION

A single custom data form can contain:

1. 64 items

2. 32 items that can take or return arguments

3. 1,024 text characters

Additional causes of the "Data_Form Not Correct" error message can include:

1. Invalid numbers in the cells for item numbers, field coordinates, height, or width.

2. Data form definition is less than seven columns wide.

3. The cell range in the Refers To box (available by choosing Define Name from the Formula menu) may be incorrect.

REFERENCES

"Microsoft Excel User's Guide," version 3.00, page 631

"Microsoft Excel for Windows Functions and Macros," version 2.1x, page 217