Hello Experts,
What would be the workaround so that each tab in the workbook containing the
formula =cell("filename") would have the correct tab name including full
file name? It seems that this formula's limitation is that it can appear
only once in the workbook. Even then, it doesn't update the tab name
automatically.

I've tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) but it,
too, has the wrong tab name if this formula appears in multiple sheets.

Thanks in advance,
Ricky