Knowledge Base

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

Article ID: 115556

Article Last Modified on 11/15/2004

APPLIES TO

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.

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto WDB WKS 3.0 Slow Too Big Empty 32000 16384

Keywords: kbhowto kbinfo KB115556


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.