皆さん、こんにちは。私は2ヶ月間Excelドキュメントを使って作業しています。昨日、考えずに愚かにもファイルを保存せずにノートパソコンの電源を切ってしまいました。今、それを開こうとするとエラーが発生します。###### エラー Microsoft Officeのバージョンは2013です。 LENOVO THINKPAD T440P LAPTOP I5、Windows 8.1で動作しています。どうか助けてください。お時間とご注意に感謝します。

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; } } }

Excel ###### エラー

GarryMcKenzie

<\/HEAD>

皆さん、こんにちは。
私は2ヶ月間Excelドキュメントを使って作業しています。昨日、考えずに愚かにもファイルを保存せずにノートパソコンの電源を切ってしまいました。今、それを開こうとするとエラーが発生します。###### エラー<\/STRONG>
Microsoft Officeのバージョンは2013です。
LENOVO THINKPAD T440P LAPTOP I5、Windows 8.1で動作しています。
どうか助けてください。お時間とご注意に感謝します。<\/P><\/BODY><\/HTML>

タグ付けされた投稿をもっと見る

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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