Microsoft KB Archive/20782

Multiplan: Formatting Cells Uses Memory PSS ID Number: Q20782 Article last modified on 10-17-1990 PSS database name: D_MPlan

1.x 2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Formatting a cell uses memory. Two to four bytes are used for each cell formatted for anything other than default. A blank worksheet with all the cells formatted could reflect 98-99 percent memory free.

Continuous formatting is especially expensive in terms of memory and should be used only when it is absolutely necessary (that is, for headers, etc.) across multiple rows or columns.

Resetting column widths also requires memory.

Copyright Microsoft Corporation 1990.