SOLVED

CELL("FILENAME") not working in EXCEL Android

%3CLINGO-SUB%20id%3D%22lingo-sub-217349%22%20slang%3D%22en-US%22%3ECELL(%22FILENAME%22)%20not%20working%20in%20EXCEL%20Android%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217349%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20someone%20to%20verify%20this%20issue.%3CBR%20%2F%3EI%20created%20a%20new%20excel%20file%20named%20%22Book%22%20and%20save%20locally%2C%20then%20entered%20the%20formula%20%3DCELL(%22FILENAME%22)%20but%20the%20value%20returned%20invalid%20(%23VALUE).%3CBR%20%2F%3EAnyone%20else%20having%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-217349%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-217358%22%20slang%3D%22en-US%22%3ERe%3A%20CELL(%22FILENAME%22)%20not%20working%20in%20EXCEL%20Android%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217358%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20all%20info%20types%20of%20this%20function%20are%20supported%20in%20Excel%20Mobile%20as%20illustrated%20in%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcell-function-51bd39a5-f338-4dbe-a33f-955d67c2b2cf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%20support%20article%3C%2FA%3E%20about%20the%20CELL%20function.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CELL%20function.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37966i18EA7A2E96B11BAD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22CELL%20function.png%22%20alt%3D%22CELL%20function.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Need someone to verify this issue.
I created a new excel file named "Book" and save locally, then entered the formula =CELL("FILENAME") but the value returned invalid (#VALUE).
Anyone else having this issue?

1 Reply
best response confirmed by LIAN CHAU PING null (Occasional Visitor)
Solution

Hi,

 

Not all info types of this function are supported in Excel Mobile as illustrated in this support article about the CELL function.

CELL function.png

 

Regards