Cell Value same as Tab

New Contributor

I have used the formula


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) to have my tab equal name the same as a cell in each sheet.  It works on my home computer but on my IPAD it shows #Value!


I have searched and can not  find a fix.  




3 Replies


It appears "filename" is not supported on mobile versions of Excel.




CELL function (microsoft.com)



So there is nothing I can do?


I believe the issue is Excel is not familiar with the file system on a mobile device. You could run the CELL function by itself to confirm:


It may return a #VALUE! error.