Bonjour à tous. Je travaille sur un document Excel depuis deux mois. Hier, sans réfléchir, j'ai bêtement éteint le laptop sans enregistrer le fichier. Maintenant, quand j'essaie de l'ouvrir, une erreur survient, ###### erreur La version de Microsoft Office est 2013. LAPTOP LENOVO THINKPAD T440P I5 fonctionnant sous Windows 8.1. Merci de votre aide et merci pour votre temps et votre attention.

When Excel shows ##### because the cell has a negative date or time value, make sure that you: * Verify dates and times are positive values when you’re using the 1900 date system. * Use a formula to subtract dates or times correctly to avoid negative date or time value results. * Change negative formula results that are formatted as dates or times to a different number format. For any issues related excel recovery contact Microsoft Support or get help HERE.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Erreur Excel ######

GarryMcKenzie

<\/HEAD>

Bonjour à tous.
Je travaille sur un document Excel depuis deux mois. Hier, sans réfléchir, j'ai bêtement éteint le laptop sans enregistrer le fichier. Maintenant, quand j'essaie de l'ouvrir, une erreur survient, ###### erreur<\/STRONG>
La version de Microsoft Office est 2013.
LAPTOP LENOVO THINKPAD T440P I5 fonctionnant sous Windows 8.1.
Merci de votre aide et merci pour votre temps et votre attention.<\/P><\/BODY><\/HTML>

Trouver plus de publications taguées avec

Accepted answers

StanleyCarter

When Excel shows ##### because the cell has a negative date or time value, make sure that you:

Verify dates and times are positive values when you’re using the 1900 date system.
Use a formula to subtract dates or times correctly to avoid negative date or time value results.
Change negative formula results that are formatted as dates or times to a different number format.

For any issues related excel recovery contact Microsoft Support or get help HERE.

All comments

StanleyCarter

When Excel shows ##### because the cell has a negative date or time value, make sure that you:

Verify dates and times are positive values when you’re using the 1900 date system.
Use a formula to subtract dates or times correctly to avoid negative date or time value results.
Change negative formula results that are formatted as dates or times to a different number format.

For any issues related excel recovery contact Microsoft Support or get help HERE.

TedKowal

You got me there, I never took #### as an error, the fix still is to widen the cell column or heighten the row -- or shorten the value by rounding or formating ... etc. Live and Learn!

DanPatterson_Retired

Ted... that is an actual error message... ##### error ... nothing missing, it is bonafide error ... kind of like 'segmentation violation'

TedKowal

Like Dan I did not understand the question.... is the excel file corrupted and you cannot open it? If that is the case,

How to recover unsaved Excel files | Excel Exposure

Repairing a corrupted workbook - Excel

Is the error when you are trying to open the workbook, or does the workbook open and you see "#####" in a cell or cells? If you see "#####" in cells then simply make the column wider or row taller...if the workbook will not open or opens with an error --- in order to help we would need the error code being given like Error 1004 .....

DanPatterson_Retired

###### error That is the exact error message?

A quick Dr Google leads to

https://support.office.com/en-us/article/how-to-correct-a-error-bf801d0a-2a6e-44bd-a70e-0f780ae8f11e

perhaps others will appear on that vein

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.