#UNKNOWN! error

%3CLINGO-SUB%20id%3D%22lingo-sub-2751702%22%20slang%3D%22en-US%22%3E%23UNKNOWN!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751702%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20receiving%20the%20aforementioned%20error%20in%20the%20subject%20line.%20I%20have%20a%20spreadsheet%20with%20the%20below%20fields%20(attached).%20Some%20of%20the%20fields%20are%20working%20correctly%20but%20it%20seems%20the%20data%20in%20others%20isn't.%20Does%20anyone%20know%20why%20this%20would%20be%20the%20case%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20use%20the%20excel%20in-built%20help%20tool.%20I%20get%20the%20following%20message%3C%2FP%3E%3CP%3E%22%3CSPAN%3EThe%20%23UNKNOWN!%20error%20indicates%20a%20unknown%20data%20type%20that%20is%20not%20currently%20supported%20in%20this%20version%20of%20Excel.%20If%20you%20need%20to%20work%20with%20this%20data%20type%2C%20consider%20upgrading%20to%20a%20newer%20version%20of%20office.%3C%2FSPAN%3E%3CSPAN%3E%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20the%20latest%20and%20most%20current%20version%20of%20the%20app%2Fsoftware.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20assistance%20would%20be%20greatly%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2751702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2751967%22%20slang%3D%22en-US%22%3ERe%3A%20%23UNKNOWN!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1156297%22%20target%3D%22_blank%22%3E%40VivianeE43%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20image%20cannot%20tell%20which%20formula%20it%20is%2C%20which%20excel%20version%20and%20operating%20system.%3C%2FP%3E%3CP%3EThis%20information%20with%20the%20insertion%20of%20the%20file%20(please%2C%20without%20sensitive%20data)%3C%2FP%3E%3CP%3Ecould%20lead%20to%20a%20proposed%20solution%20much%20faster%20and%20more%20precisely.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am receiving the aforementioned error in the subject line. I have a spreadsheet with the below fields (attached). Some of the fields are working correctly but it seems the data in others isn't. Does anyone know why this would be the case?

 

When I use the excel in-built help tool. I get the following message

"The #UNKNOWN! error indicates a unknown data type that is not currently supported in this version of Excel. If you need to work with this data type, consider upgrading to a newer version of office."

 

I have the latest and most current version of the app/software. 

 

Any assistance would be greatly appreciated.

 

 

 

1 Reply

@VivianeE43 

The image cannot tell which formula it is, which excel version and operating system.

This information with the insertion of the file (please, without sensitive data)

could lead to a proposed solution much faster and more precisely.

 

Thank you for your patience and time.

 

NikolinoDE

I know I don't know anything (Socrates)