Written by Allen Wyatt (last updated October 10, 2024)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
Many people use the CELL worksheet function to return the name of the current Excel workbook. A common way to use the function is as follows:
=CELL("filename")
Using the CELL function in this manner is fine, provided you only have one workbook open at a time. If you open more than one, then this usage can cause problems. Why? Because when used this way, CELL returns the name of the currently active workbook, not the workbook in which the formula is used.
To always return the name of the workbook in which CELL is used (sometimes called the "parent workbook"), you must alter the formula just a bit:
=CELL("filename", A1)
By adding a cell reference as the second parameter in the function, you are telling Excel that you want the name of the file containing that cell reference. In other words, CELL will return the name of the file in which cell A1 of the current worksheet is located. (You can also provide any other cell reference in place of A1, if more appropriate.)
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10771) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Excel here: Getting the Name of the Parent Workbook.
Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!
You can use the IF worksheet function to test for a number of different conditions or values. You can't use it to check ...
Discover MoreThe UNIQUE function can be used to evaluate a range and return the unique values in that range. Understanding how the ...
Discover MoreGrading in schools is often done using numeric values. However, you may want to change those numeric values into letter ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-01-06 08:52:12
Ed
It is observed that blanks are returned if the work book is new and has not been saved.
2021-01-02 10:53:26
J. Woolley
The problem with CELL("filename",A1) is that it returns something like
C:\Users\MyName\Documents\[MyBook.xlsx]MySheet
when all you wanted was MyBook.xlsx. You might consider the freely available NameOf function in My Excel Toolbox, which is perhaps more useful than Excel's CELL and INFO functions. See https://sites.google.com/view/MyExcelToolbox/
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments