MS Excel 2.x/3.x/4.x Worksheets Take a Long Time to Open/Save

 Last reviewed: February 2, 1998
Article ID: Q104310
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SUMMARY

Microsoft Excel versions 5.0 and later use the "shared formulas" method for storing repeated formulas. If your worksheet contains many similar formulas, this storage method may decrease the size of your file. As a result, these files take less room on your disk and require less memory when they are open. In addition, it may take less time for a file to open, for a sheet to be recalculated, or for cell references to be adjusted (for example, when you insert a row or column). Note that these file size improvements and performance enhancements may be imperceptible if your sheet does not contain many formulas or does not contain formulas with repeated information.

When you open files created in versions of Microsoft Excel earlier than 5.0, or files that are in external file formats, the formulas in these files are converted to shared formulas. This conversion process results in a slight increase (5-percent to 15-percent) in the amount of time that it takes to open the file. However, once you save the file in the Microsoft Excel 5.0 file format (in the Save As dialog box, choose Microsoft Excel Workbook under Save File As Type), the file will load and save faster and will require less disk space.

Example of Performance Enhancement

Following is an example of the performance enhancement provided by this new feature. Note that the time it takes to load and save a file will vary depending on the way your computer is configured.

If cells A1:CZ100 of a Microsoft Excel 4.0 worksheet contain the following formula 

   =IF(B125>0.5,B124/B125,B124)
when you save this file, it requires 681,790 bytes of disk space. When you close and reopen this file in Microsoft Excel 4.0, it takes 16 seconds to open. When you load this file in Microsoft Excel 5.0, it takes 22 seconds to load. However, when you save this file as a Microsoft Excel 5.0 Workbook, the file size shrinks to 345,600 bytes. When you close and reopen this file, it takes 6 seconds to load.

Additional query words: 5.00 7.00 8.00 97 98 XL98 XL97 XL7 XL5
Keywords : xlloadsave
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a;98
Platform : MACINTOSH WINDOWS
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.