You are currently offline, waiting for your internet to reconnect

XL: CELL Function with "filename" No Longer Volatile

This article was previously published under Q211370
This article has been archived. It is offered "as is" and will no longer be updated.
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.
This problem occurs when you do the following:
  • You use the CELL function with "filename" for the info_type argument.

  • 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.
To work around this problem, use either of the following methods:
  • Press F9 to update the CELL worksheet function.

  • 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).
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
XL2002 XL2000 XL97
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 211370 - Last Review: 10/24/2013 06:32:00 - Revision: 2.0

Microsoft Excel 2000 Standard Edition, Microsoft Excel 2002 Standard Edition, Microsoft Excel 97 Standard Edition

  • kbnosurvey kbarchive kbpending kbprb KB211370