PSS ID Number: 132284
Article Last Modified on 3/21/2001
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q132284
SYMPTOMS
In Microsoft Excel, when you use the Template Wizard to create a database linked to a Microsoft Excel template file, when you add a record to a database that already contains 16383 records, you do not receive an error message. However, the records that you add to a database that contains 16383 records are not added to the database file.
CAUSE
This behavior occurs because the limit for the number of rows that a Microsoft Excel worksheet can contain is 16383. You cannot add more than 16384 rows to a worksheet. However, when you use the Template Wizard to link data in a template file to a database, if the worksheet already contains 16383 records (plus one row for the field name), you do not receive an error message when you use the template file to add a record to the database. However, any records that you add beyond record 16383 using the template file are not saved to the database.
RESOLUTION
To avoid losing data that you save to a database using a template file (created by using the Template Wizard), do not add more than 16383 records to the database file. You must open the database file to check the number of records periodically to make sure you do not exceed this limit. Note that additionally, you can save records to multiple worksheets in the same Microsoft Excel database file.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
REFERENCES
For more information about how to create a template using the Template Wizard, click the Index tab in Microsoft Excel Help, type the following text
Template
double-click the selected text, and then double-click "Create a template to export worksheet data to a database" to go to the "Create A Template To Export Worksheet Data To A Database" topic.
Keywords: KB132284
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch
