=CELL("filename")

You should add a cell reference to this function.

=CELL("filename",A1)

Otherwise, the result will be the active workbook when a
calculation is made, which may not be the same workbook that
contains the formula. Including a cell reference -- any cell will
do -- will prevent this error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"David Billigmeier" wrote in message
...
You can display it in a cell by typing the following (verbatim)

=CELL("filename")
--
Regards,
Dave


"Rick3789" wrote:

Is there a way to show the complete filepath of the current
Excel file in a
toolbar line?