XL97: CELL Function with "filename" No Longer Volatile

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97 for Windows, the CELL worksheet function may not update automatically.

NOTE: This is different behavior from earlier versions of Microsoft Excel.

CAUSE

This problem occurs when you do the following:

• You use the CELL function with "filename" for the info_type argument.


-and-


• You click Save As on the File menu and change the file name, file type, or file location so that the complete path and file name changes.

WORKAROUND

Use either one of the following methods to work around this problem:

1. On the Tools menu, click Options.



2. Click the Calculation tab.



3. Click the Calc Now button.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

MORE INFORMATION

REFERENCES

For more information about the CELL worksheet function, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

CELL worksheet function

Additional query words: XL97

Keywords : kbdta xlformula
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug