Works: Formatting in Spreadsheet or Database List Creates Thousands of Rows/Records (115556)


The information in this article applies to:

  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q115556

SUMMARY

Selecting a field in list view of a Works database, and choosing Record Height from the Format menu adjusts the record height for all possible 32,000 records, increasing the size of the database to 32,000 records. Similarly, selecting a column in a Works spreadsheet and choosing Row Height from the Format menu adjusts the row height for all possible 16,384 rows, increasing the size of the spreadsheet to 16,384 rows.

MORE INFORMATION

Workaround

Select the records or rows for which you want to change the height, rather than selecting the entire field or column when changing row or record height.

To remove the extraneous rows or records, do the following:

  1. Highlight the first blank row at the bottom of your spreadsheet or list view in the database.
  2. Press SHIFT+CTRL+END together on the keyboard to select the extraneous rows or records.
  3. From the Insert menu, click Delete Record/Field (in the Database module) or Delete Row/Column (in the Spreadsheet module).
  4. If the Delete dialog box appears, click Record (database) or Row (spreadsheet). Click OK.

    NOTE: If Field (database) or Column (spreadsheet) is selected, all of the data will be deleted.
  5. If the error message
    Not enough memory to Undo: Continue?
    appears, click OK.
  6. From the File menu, click Save.
The extraneous rows or records will now be deleted.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbhowto kbinfo KB115556
©2004 Microsoft Corporation. All rights reserved.