Map excel file entry error

%3CLINGO-SUB%20id%3D%22lingo-sub-1317164%22%20slang%3D%22es-ES%22%3EMap%20excel%20file%20entry%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317164%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%3A%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20file%20in%20MAP%20format%20that%20throws%20me%20the%20following%20error%20messages%20when%20opening%20it%3A%3C%2FP%3E%3CP%3E-%20Type%20mismatch.%20%3CBR%20%2F%3E-%20An%20_xlfn.%20prefix%20is%20displayed%20in%20front%20of%20a%20formula%3C%2FP%3E%3CP%3EThe%20file%20contains%20a%20macro%20that%20is%20linked%20to%20the%20spreadsheets.%20I%20am%20very%20grateful%20if%20you%20can%20give%20us%20any%20indication%20to%20find%20the%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDavid%20Esteban%20Forero%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22firma_corporativa.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F185100i042D5930417265BE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22firma_corporativa.jpg%22%20alt%3D%22firma_corporativa.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1317164%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317569%22%20slang%3D%22en-US%22%3ERe%3A%20Map%20excel%20file%20entry%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626930%22%20target%3D%22_blank%22%3E%40davidforero%3C%2FA%3E%26nbsp%3BThe%20_xlfn%20pre-fix%20indicates%20that%20the%20formula%20contains%20a%20function%20that%20is%20not%20supported%20by%20your%20version%20of%20Excel.%20Read%20more%20about%20it%20here.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fissue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fissue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello:

I have an excel file in MAP format that throws me the following error messages when opening it:

- Type mismatch.
- An _xlfn. prefix is ​​displayed in front of a formula

The file contains a macro that is linked to the spreadsheets. I am very grateful if you can give us any indication to find the error.

 

Sincerely,

 

David Esteban Forero

 

firma_corporativa.jpg

 

1 Reply
Highlighted

@davidforero The _xlfn pre-fix indicates that the formula contains a function that is not supported by your version of Excel. Read more about it here.

https://support.microsoft.com/en-us/office/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-8...