Thanks for your reply Bob. I know about the anchoring reference, and the need
for the Workbook is saved, but this still doesn't work. If I create a file
with the filename formula on my computer and save the file it works fine.
When I then open the same Workbook on any other computer the formula does not
work and returns the #Value. If I create the formula on any other computer
and save the Workbook, it returns the #Value, but then if I open on my
computer it works again???

"Bob Phillips" wrote:

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!