XL98: Workbook File Size Increases While Editing Procedure (192369)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q192369 SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when you edit a Microsoft Visual
Basic for Applications procedure in a workbook and then save the workbook,
the workbook file size increases even if you delete code from the
procedure.
CAUSE
This behavior occurs because the variables that you use in a procedure are
stored in the module that contains the procedure. When you enter a variable
name in a Visual Basic module, whether you use the Dim statement to
dimension the variable or not, the name is stored in a name table. The disk
space used for the variable in the name table is not freed until the module
that contains the procedure is deleted. Because of this behavior, a
workbook increases in file size when you add new variables to a procedure
in the workbook, and does not decrease in file size when you delete
variables from a procedure in the workbook.
A workbook also increases in file size when a procedure contained in the
workbook is compiled.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB192369 |
|---|
|