CELL("filename")

Try this -

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1)))

And I am not sure why you need the Right Function..

This will give you the same result wont it?

=CELL("filename",A1)

Not a bug. That's just how it works.

If you don't include a cell reference (it can be to ANY cell), the formula will return the file name of the last file that generated a calculation.

Thank you for the Rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

P.S. Bugs in Excel aren't so easy to find..

@ Tony

Trying to understand the behaviour.

According to this MS Website (https://support.office.com/en-ca/art...f-955d67c2b2cf)

It says -

Reference Optional. The cell that you want information about. If omitted, the information specified in the Info_type argument is returned for the last cell that was changed. If the reference argument is a range of cells, the CELL function returns the information for only the upper left cell of the range.

So when an Excel file is opened, does it generate some sort of a calculation? Is it Excel's default behavior?

Try this...

Create 2 files. Save them and give them names.

File1
File2

With both files open...

Enter this formula in cell A1 of File2:

=CELL("filename")

Note the result of the formula.

Now, switch to File1 and enter this formula in cell A1:

=RAND()

Now, switch to File2 and note the entry in cell A1.

If you include a cell reference in the formula:

=CELL("filename",A1)

The above scenario will not happen.

You're welcome. We appreciate the feedback!

And to answer your specific question, yes, when Excel opens a file, it performs the calculations by default