found an office 2013 excel bug

[xorbe]

There's a function,

=cell("filename")

The description says, returns filename of the file containing the reference.

But it leaks data, it actually returns the filename that the user is currently editing! Make 2 spreadsheets, toggle between them with both on the screen, and hit F9.

 

[munkle]

Doesn't do anything

 

[michalrz]

Confirmed.
Reproduced like this:
- Create two files, one named 'aaaw' the other 'aaaf',
- Place the =cell("filename") formula in 'aaaw' and then in 'aaaf'.
- If you switch from 'aaaf' to 'aaaw' you will see that both sheets seem to share the =cell() formula's result

 

[Snowknight26]

Note that =CELL("filename") gives you the path to the last workbook/worksheet changed so if you have 2 workbooks open, abc and xyz and your formula is in abc, if you last changed a value in xyz the formula in abc will reflect that and return xyz.xlsx

For that reason it's usually preferable to include a cell reference (any cell reference), e.g.

=CELL("filename",A1)

Working as intended.

 

[xorbe]

Working as intended.

My help clearly stated that the result is the name of the file containing the reference. Yet it returns the name of the file the user has focused. I will try your fix. I don't doubt that there is conflicting documentation of an MS product!