Article ID: 211370 - Last Review: January 23, 2007 - Revision: 2.1

XL: CELL Function with "filename" No Longer Volatile

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q211370

Expand all | Collapse all

SYMPTOMS

In the versions of Microsoft Excel listed at the beginning of this article, the CELL worksheet function may not update automatically.

NOTE: This behavior differs from that in Microsoft Excel for Windows 95, version 7.0 and earlier.

Back to the top

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 path or file name changes.

Back to the top

WORKAROUND

To work around this problem, use either of the following methods:

Press F9 to update the CELL worksheet function.

-or-
Recalculate the worksheet. To do this, follow these steps:
1. On the Tools menu, click Options.
2. Click the Calculation tab.
3. Click Calc Now (F9).

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

REFERENCES

For more information about the CELL worksheet function, click Microsoft Excel Help on the Help menu, type cell worksheet function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Back to the top