Excel use file name

Type or paste the following formula in the cell in which you want to display the current file name with its full path and the name of the current worksheet:. Type or paste the following formula as an array formula to display the current file name and active worksheet name:. The formula returns the name of the worksheet as long as the worksheet has been saved at least once. If you use this formula on an unsaved worksheet, the formula cell will remain blank until you save the worksheet.

When you save the worksheet, the error is replaced by the file name. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Need more help? With the following formulas, you can quickly insert file name or path or sheetname in a speicfied cell. Copy any above formula that you need to a specified cell, and you will get the result you need.

There will be three editing box in the Header or Footer section, click left , center or ringht box that you want to insert the filename or path. See screenshot:.

Then click any cell, and you can see the file path or name or sheet name has been inserted into the header ot footer. See screenshots:. In the Insert Workbook Information dialog box, choose the workbook information you want to insert from left pane, and then select the place where you want to insert the information at.

Then click OK. If you insert the wotkbook information into a cell, you will get the result as follows:. If you insert the workbook information into the header or footer, you can choose the location where you want to insert the information into, Left , Right or Center.

To know more about this feature, please visit Insert Workbook Information. Note: The other languages of the website are Google-translated. Read More Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished.

It was giving me an error, until I added a 2nd tab. Thank you so much. Made my work simple. That works well BUT on a Mac you have to replace every , by a ;. The formula above seems inactive if converted into a. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. It will only work if the other workbook is open, if it is closed you'll get REF!

Tom Melosi. I need to link a workbook using the filename listed in a cell as part of the formula.