PPT,WORD,EXCEl忘記存檔或是當機處理方式

PPT,WORD,EXCEl忘記存檔或是當機處理方式

很多時候會有人打一打文書檔案打到一半當機了、或是忘記存檔…..會非常的火大!!有些可是打了好幾個小時之類的檔案,但是又沒有開啟OFFICE的自動存檔或是定時的給他按下CRTL+S那怎麼辦呢?

那就去電腦找尋TEMP的資料夾吧~~
C:\Documents and Settings\Administrator\Local Settings\Temp
C:\Documents and Settings\Administrator\Local Settings\Temp
C:\Documents and Settings\user\Local Settings\Temp

上面的紅字就是你的帳號登入名稱,到裡面去找尋最靠近你當機時間的 *.tmp檔案。

先看看你所編輯的檔案是哪種,
PPT的話 後面就是 *.ppt <2003版本的> *.pptx <2007版本的>
EXCEL 後面就是 *.xls <2003版本的> *.xlsx <2007版本的>
WORD 後面就是 *.doc <2003版本的> *.docx <2007版本的>

之後再去打開你改過的檔案,看看是不是就可以把你的原本辛苦的結晶都拯救回來嚕!


打了一天的 excel 都沒有存檔,是因為那個檔案是另一個系統開出來的,所以必須全結束才可以整個一起存..

Excel
工具→選項→儲存檔案→自動回復儲存位置 分頁裡面
EXCEL的自動存檔的位置

預設是這個位置
C:\Documents and Settings\Robert\Application Data\Microsoft\Excel\

不過裡面沒有提到,要記得開啟可以看到所有的系統隱藏檔,然後就可以看到一堆像這樣子的檔案 [~ar2D4F.xar] or [~ar41CA.xar] 依時間排序之後就可找到。


A copy of open excel file is stored in TEMP folder which is ‘documents and settings\user\local settings\temp’ folder.
The name of file is something like ~DF39CF.TMP
When I close excel sheet, this file disappears.

Please let me know
(1) Does this .tmp file contain all the data of the open excel sheet ?
(2) Is it possible to recover data from this file ?


Finding and using the temporary and auto save files

Excel doesn’t have the AutoSave feature enabled as default, you have to add it. This is because it isn’t always practical to have this functionality enabled. If you have it enabled and want to experiment with a spreadsheet, you should create a copy then open that so that the AutoSave doesn’t overwrite the original.

To enable the AutoSave feature, you have to use an Add In. Go to “Tools" “Add ins" and choose “AutoSave".
With Office XP, AutoSave has been moved out from Add Ins to Options, in a similar way to Word. You will find the settings under “Save" where you can also disable the Auto Recover feature for that particular work book.

Excel automatically saves every 10 minutes to the default location of “C:\ Documents and Settings\<username>\Local Settings\Temp" or “C:\Users\<username>\AppData\Local\Temp" on Windows 7/Vista. The files are identifiable as they are saved as a number .tmp e.g. “28.tmp". This means that they look different from word or any other temporary files that are being saved there by other applications.

The temp file for excel can also look like ~dfxxxx.tmp .

Office 2010 and Higher

In Office 2010 and higher, you have an additional option, built in to the product, called Recover Unsaved Spreadsheets

Click on File tab in the upper left corner.
Choose Recent
In the bottom left corner is Recover Unsaved Spreadsheets
The Saved Drafts folder will open. Find your file and double click on it to open. Then save the file.

These files can also be found in the following locations:

Windows 8/Windows 7/Windows Vista
C:\Users\<username>\AppData\Local\Microsoft\Office\UnsavedFiles

Windows XP
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Office\UnsavedFiles