Microsoft KB Archive/45191

Maximum Number of Fields in an Excel Data Form PSS ID Number: Q45191 Article last modified on 08-06-1993 PSS database name: W_eXceL

2.00 2.01 2.10 2.10c 2.10d 3.00

WINDOWS

Summary:

The number of fields that can be seen on a data form is dependent upon the graphics card, its graphics resolution, and the system fonts installed during the Microsoft Windows setup. The option to install system fonts (that is, fonts for Windows applications) and terminal fonts (fonts for DOS applications) is available only when “Other” is chosen for the graphics card selection. Normally, these fonts are chosen by the Setup program.

The maximum number of fields that can be viewed on a data form in Microsoft Excel, however, is 32 fields. If you try to select more than 32 fields to define a database, the Data Form command gives the following message:

Too many fields in data form

If you get this message, you must redefine your database, limiting it to 32 fields (or columns). Only then is the data form displayed.

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.1c 2.10c 2.1d 2.10d 3.0 3.00 dataform

Copyright Microsoft Corporation 1993.