I love this board! ExcelBanter is awesome.

I had the same issue where I moved my data to an external spreadsheet (so I wasn't pasting the same data 12 times) and was using a sorter in one of my sheets that referred to a defined name in my data worksheet.

When I stuck the path in the formula and pressed enter - Excel (2010) removed the path and just kept the workbook filename (i.e. file.xlsx!Name) instead of the whole path. If I open the "child" workbook without opening the data ("parent") workbook, then the path will show in the formula.

As long as the workbook that I am referring to is open, the path will not show but if I close the source workbook, then it shows up.

Thank you for the help, once again!!