Jul 12 2022 10:32 AM
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.
Jul 12 2022 11:53 AM
It appears "filename" is not supported on mobile versions of Excel.
Jul 12 2022 12:28 PM
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.