Home

perte totale de données...?

%3CLINGO-SUB%20id%3D%22lingo-sub-951641%22%20slang%3D%22fr-FR%22%3Etotal%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-951641%22%20slang%3D%22fr-FR%22%3E%3CP%3EI%20just%20worked%20for%20over%204%20hours%20on%20an%20Excel%20document%20and%20wanting%20to%20record%20it%20I%20suddenly%20received%20a%20compatibility%20error%20message%20and%20now%20all%20the%20data%20on%20the%20sheet%20is%20lost%20and%20replaced%20by%20%3CSTRONG%3E'%23VALEUR!%3C%2FSTRONG%3E%20'%20...%3C%2FP%3E%3CP%3ECan%20I%20get%20my%20job%20back%3F%3C%2FP%3E%3CP%3EPLEASE!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-951641%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-952097%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-952097%22%20slang%3D%22fr-FR%22%3E%3CP%3E...%20here's%20what%20it%20looks%20like!...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20...%20THANK%20YOU%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F433257%22%20target%3D%22_blank%22%3E%40yvessr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-952135%22%20slang%3D%22en-US%22%3ERe%3A%20perte%20totale%20de%20donn%C3%A9es...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-952135%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F433257%22%20target%3D%22_blank%22%3E%40yvessr%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20inspect%20your%20formulas%20and%20refer%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fhow-to-fix-the-value-error%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fformula%2Fhow-to-fix-the-value-error%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957502%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957502%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20link%20you%20suggested%20me%20does%20NOT%20resolve%20my%20problem%20at%20all%20!...%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20in%20my%20previously%20added%20screen%20capture%20the%20WHOLE%20page%20of%20my%20sheet%20is%20filled%20with%20%3CSTRONG%3E'%23VALEUR!'%20%3C%2FSTRONG%3E%20....%20in%20the%20sheet%20there%20is%20nowhere%20any%20formula%20nor%20special%20function%3B%20%3CU%3Eit%20are%20all%20just%20values%20I%20entered!%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!%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-SUB%20id%3D%22lingo-sub-957510%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957510%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F433257%22%20target%3D%22_blank%22%3E%40yvessr%3C%2FA%3E%23VALEUR%20is%20a%20constant%20or%20the%20result%20of%20existing%20formulas%20in%20the%20binder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20formulas%20are%20still%20present%20can%20you%20make%20the%20file%20available%20after%20anonymizing%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957527%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957527%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434216%22%20target%3D%22_blank%22%3E%40edlm10%3C%2FA%3E%20no%20problems%3B%20here's%20attached%20the%20full%20file%3C%2FP%3E%3CP%3ELet's%20hope%20you%20can%20restore%20it%20to%20me!%3C%2FP%3E%3CP%3EIn%20advance%20a%20big%20THANK%20YOU.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957781%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957781%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F433257%22%20target%3D%22_blank%22%3E%40yvessr%3C%2FA%3E%20Unfortunately%20not%20because%20the%20file%20does%20not%20actually%20contain%20any%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20this%20point%20I%20have%20no%20more%20ideas.%20Sorry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-958278%22%20slang%3D%22fr-FR%22%3ERe%3A%20Total%20data%20loss...%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-958278%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434216%22%20target%3D%22_blank%22%3E%40edlm10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...%20it%20makes%20me%20very%20sad!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20had%20%3CSTRONG%3Eno%20formula%3C%2FSTRONG%3E%20!!!%20it%20was%20simply%20a%20table%20full%20of%20numerical%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20convinced%20that%20with%20Excel%20(2019)%20and%20its%20automatic%20recording%20mode%20every%2010%20minutes.%20it%20could%20not%20happen%20to%20me%20but%20now%20I%20realize%20that%20all%20this%20was%20an%20illusion%20!!!%20...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again%20for%20your%20attempts%20at%20recovery!%3C%2FP%3E%3C%2FLINGO-BODY%3E
yvessr
Occasional Contributor

Je viens de travailler pendant plus de 4 heures sur un document Excel et en voulant l'enrégistrer j' ai soudainement reçu un message d'erreur de compatibilité et maintenant toutes les données de la feuille sont perdues et remplacées par ' #VALEUR ! ' ...

Puis-je récupérer mon travail ?

AU SECOURS svp !

7 Replies

... voici à quoi cela ressemble !...

 

aidez-moi svp ... d'avance MERCI !

 

 

@yvessr 

Hello @yvessr,

 

Please inspect your formulas and refer to the following:

https://exceljet.net/formula/how-to-fix-the-value-error

@PReagan 

 

the link you suggested me does NOT resolve my problem at all !...

As you can see in my previously added screen capture the WHOLE page of my sheet is filled with ' #VALEUR! '.... in the sheet there is nowhere any formula nor special function; it are all just values I entered !

 

Thanks for your help !

 

 

 

@yvessr#VALEUR est une constante ou le résultat de formules existantes dans le classeur.

 

Si les formules sont toujours présentes pouvez vous mettre à disposition le fichier après l'avoir anonymisé ?

@edlm10    aucun problème; voici-joint le fichier complet

Espérons qu tu puisse me le restaurer !

D'avance un grand MERCI.

@yvessrHélas non car le fichier ne contient effectivement plus aucune formule.

 

À ce stade je n'ai pas plus d'idées. Désolé.

@edlm10 

... cela me rend bien triste !

 

le fichier ne comportait aucune formule !!! c'était simplement un tableau rempli de valeurs numériques.

 

j'étais persuadé qu'avec Excel (2019) et son mode d'enrégistrement automatique tous les 10 min. il ne pouvait rien m'arriver mais là je me rends bien compte que tout cela n'était qu'illusion !!!... 

 

Merci encore pour tes tentatives de récupération !

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies