It only works after a workbook is saved, a workbook does not have a filename
until it is saved.

You should also anchor it to the sheet using a cell reference, any cell
reference, such =CELL("filename",A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DR Hall" wrote in message
...
Our office is running Office / Excel 2003. When I enter the formula
=CELL("filename") into a cell on my computer and then save the file the
cell
displays the filename correctly. But out of all the computers in our
office
mine is the only one that this formula works on, we all have the same
version
of Excel. Why is this?? All the ohter computers display #Value when this
formula is entered and the workbook saved!
Please help!