filename formula

  • Thread starter Thread starter Chris Hill
  • Start date Start date
C

Chris Hill

Is there a formula to enter the filename on the worksheet?

The filename can be shown on the page setup header/footer
section, but I need it to show on the worksheet itself.

Thanks
 
Try =cell("filename")

This will give you the entire path all the way to the
sheet name. To remove path details and sheet name details
you can use existing functions to manipulate text.

If the file is a "new file" and not yet saved, then it
will return a blank value.
 
Hi,

It is better to use the second argument, otherwise this
formula will return these details for the ACTIVE workbook
and sheet (and give unexpected results after a full recalc
while another workbook is active!!!):

=cell("filename",A1)


Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Back
Top