Cell Value same as Tab

Question

I have used the formula&nbsp;=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) to have my tab equal name the same as a cell in each sheet.&nbsp; It works on my home computer but on my IPAD it shows #Value!&nbsp;I have searched and can not&nbsp; find a fix.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

patrick2788 · Answer

llbean62&nbsp;It appears "filename" is not supported on mobile versions of Excel.&nbsp;&nbsp;CELL function (microsoft.com)

llbean62 · Answer

Patrick2788&nbsp;&nbsp;So there is nothing I can do?

patrick2788 · Answer

llbean62&nbsp;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.&nbsp;

Forum Discussion

Cell Value same as Tab

3 Replies

Resources