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

@llbean62 

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

 

Patrick2788_0-1657652006487.png

 

CELL function (microsoft.com)

@Patrick2788 

 

So there is nothing I can do?

@llbean62 

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:

=CELL("filename")

It may return a #VALUE! error.