Displaying file name in a workbook

P

Premier Geoff

Is there any way that the filename of a workbook can be displayed in a cell.

A bit like the "TODAY" function displays the current date, is there a
function to display the current file name of the workbook
 
D

Dave Peterson

I think:

=cell("filename",a1)
will be better.

If a range reference isn't included, then the formula will evaluate to whatever
workbook is active at the time of the last calculation.
 
E

Earl Kiosterud

Dave,

Thanks. That one's not in the help for the CELL() function, so I think this
is officially another Excel gotcha!
 
Top