Display File Name in Cell

[Corey]

Is there a formula to display the File Name in a cell (Say O49) ?

 

[Sheeloo]

=CELL("filename")

Go to http://office.microsoft.com/en-us/excel/HA010346271033.aspx

 

[Corey]

Thanks

Tried that origianlly but only displayed the 'CELL("filename")' as text.,
Is Ok now

Thank You


Corey....

 

[Dave Peterson]

=cell("filename")
will evaluate to the workbook name that was active when excel recalculated.

=cell("filename",a1) will return that workbook/worksheet for the cell with the
formula.

You can visit Chip Pearson's site for a bunch of formulas:
http://www.cpearson.com/excel/excelF.htm#FileName

ps. The workbook has to be saved at least once.