[Solved] =CELL("FILENAME";A1) no autoupdate

[morphingstar]

When I change the file name using Save As the result in cell containing =CELL("FILENAME";A1) does not change.
If the cell is in EDIT and then ENTER the content does not change.
Content only changes if cell content is deleted and the formula entered again.
What is preventing correct operation - meaning show correct actual file name?
Tks.

[Zizi64]

Try to force the recalculation of the whole spreadsheet or only that cell. (F9, Ctrl-Shift-F9)

[Lupp]

Did you try Ctrl+Shift+F9 (calculate all)?

CELL() is a rather obscure function. But anyway spreadsheets aren't recalculated when a SaveAs is performed.
If you want to force this, you need to create a little "macro" and to bind it to the document event 'Document has been saved as'. (Save the setting to the document.)

The macro may look like:

Code: Select all

Sub forceCalculation()
ThisComponent.CalculateAll
End Sub

[Villeroy]

Like any other function, =CELL(x1;y1) updates whenever x1 or y1 changes either by modifying anyy of the referenced cells or by editing the formula or by reloading the document or by hitting ctrl+shift+F9