Path and filename displayed in Excel

F

falcios

How do you configure Excel to display the full path and filename of the
worksheet.
Thanks in advance.
 
C

Chip Pearson

=CELL(A1,"filename")
or maybe
=CELL("filename",A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
F

falcios

Sorry I forgot to mention that I would like it to the default when I open
every worksheet.
 
Top