Non-Excel Worksheets Recalculate When Opened

ID: Q79627

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
Microsoft Excel for OS/2, versions 2.x, 3.0

SUMMARY

Opening a file that is not in Excel's native format causes all open sheets, including the sheet that is opened, to recalculate. There is no way to disable this recalculation.

MORE INFORMATION

File formats that generate this effect include:

DBF 2
DBF 3
DBF 4
SYLK
Text
CSV
WKS
WK1
WK3
DIF
PRN
WQ1

REFERENCES

"Microsoft Excel Reference Guide," version 2.0, page 282

"Microsoft Excel User's Guide," version 3.0, pages 338-340

Additional query words: recalc

Keywords :
Version :
Platform :
Issue type :