Adding
a File Name and Network Path to a Worksheet
Although you can add the workbook's name in the custom header or footer section,
that command will not add the network file path for you. To add the file name
and path to a worksheet, follow the instructions below.
Save your workbook.
Select a worksheet.
Click once in the cell where you want the file name and path to be located.
Type=CELL(“Filename”, A1) –
where A1 refers to the cell containing the File Name and Path
formula.
Click on the Enter Formula icon (the green checkmark) in
the Formula bar.
The network location, workbook name, and worksheet name will appear in the
cell.
You can repeat the process for each worksheet in the workbook.
