Microsoft KB Archive/211370

= XL: CELL Function with "filename" No Longer Volatile =

Article ID: 211370

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q211370



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.



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.



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:
 * On the Tools menu, click Options.
 * Click the Calculation tab.
 * Click Calc Now (F9).



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

