Thaum ua hauj lwm hauv Excel, tus neeg siv rau ntau yam laj thawj yuav tsis muaj sij hawm los khaws cov ntaub ntawv. Ua ntej tshaj plaws, nws tuaj yeem ua rau lub zog faiv fab, kev lag luam thiab kho vajtse fais fab. Kuj muaj qee zaum thaum tus neeg tsis paub uas siv nws lub khawm qhib lub khawm thaum kaw cov ntaub ntawv hauv lub thawv ntawv tsis txhob txuag ib phau ntawv. Tsis txhob txuag. Nyob rau hauv tag nrho cov no, qhov teeb meem ntawm kev muab cov ntaub ntawv rov qab ua tsis tiav Excel yuav hloov ceev.
Cov ntaub ntawv rov qab
Nws yuav tsum raug sau tseg tam sim ntawd hais tias koj tuaj yeem tsuas yog rov qab tau txais cov ntaub ntawv tsis tau txais kev pab yog tias qhov kev zov me nyuam muaj autosave enabled. Txwv tsis pub, yuav luag tag nrho cov kev ua hauv kev ua hauv RAM thiab kev rov qab los yog tsis yooj yim sua. Autosave yog enabled los ntawm lub neej, txawm li cas los, nws yog qhov zoo dua yog tias koj kos nws cov xwm txheej nyob rau hauv cov chaw thiaj li yuav tiv thaiv koj tus kheej los ntawm tej yam tsis kaj siab. Muaj koj tuaj yeem ua tau, yog tias koj xav tau, ua qhov tsis so ntawm daim ntawv sau tseg ntau tshaj (yog tias tsis yog, 1 lub sij hawm 10 feeb).
Tshooj: Yuav ua li cas teev autosave hauv Excel
Txoj kev cai 1: Rov muab ib daim ntawv tsis tau txais rov tom qab tsis ua haujlwm
Yog thaum muaj teebmeem lossis software tsis ua haujlwm ntawm lub computer, lossis thaum muaj lub hwjchim tsis ua haujlwm, qee zaum, tus neeg siv yuav tsis txuag tau phau Excel workbook uas nws tau ua haujlwm. Yuav ua li cas?
- Tom qab lub kaw lus tas rov qab, qhib Excel. Nyob rau sab laug ntawm lub qhov rais tam sim ntawd tom qab tso tawm, daim ntawv rov ua kom tiav yuav qhib cia. Tsuas xaiv cov ntaub ntawv ntawm daim ntawv tso cai autosave uas koj xav kom rov qab (yog tias muaj ntau qhov kev xaiv). Nias rau ntawm nws lub npe.
- Tom qab ntawd, daim ntawv yuav qhia cov ntaub ntawv tawm ntawm cov ntaub ntawv tsis tau txais kev cawmdim. Yuav kom ua tiav txoj haujlwm txheej txheem, nyem rau ntawm daim duab nyob rau hauv daim ntawv ntawm lub tshuab floppy nyob rau sab qaum sab laug ntawm qhov kev pab cuam qhov rai.
- Qhov qhib phau ntawv qhib qhov rai. Xaiv qhov chaw ntawm cov ntaub ntawv, yog tias tsim nyog, hloov nws lub npe thiab hom ntawv. Peb nias lub khawm "Txuag".
Thaum kho qhov txheej txheem no rov tuaj yeem xav tau.
Txoj kev 2: Rov ua haujlwm ib phau ntawv uas tsis tau txais kev cawmdim thaum kaw cov ntaub ntawv
Yog hais tias tus neeg siv tsis txuag tau phau ntawv, tsis yog vim lub cev tsis zoo, tab sis tsuas yog vim nws tau nias khawm thaum kaw Tsis txhob txuagces restore qhov saum toj no txoj kev tsis ua haujlwm. Tab sis, pib nrog 2010 version, Excel kuj muaj lwm qhov sib npaug zos cov ntaub ntawv rov qab cuab tam.
- Khiav Excel. Nias lub tab "Cov Ntaub Ntawv". Nias ntawm yam khoom "Tsis ntev los no". Muaj, nyem rau ntawm lub pob "Rov qab Cov Ntaub Ntawv Tsis Txhaj Tshuaj". Nws nyob ntawm qhov kawg ntawm sab laug ntawm lub qhov rais.
Muaj lwm txoj hauv kev. Nyob hauv tab "Cov Ntaub Ntawv" mus rau qhov subsection "Cov ntsiab lus". Hauv qab nruab nrab ntawm lub hauv paus ntawm lub qhov rais hauv qhov kev txwv parameter "Versions" nias lub khawm Version Control. Hauv daim ntawv uas tshwm sim, xaiv qhov khoom "Restore unsaved books".
- Qhov twg ntawm cov paths koj xaiv, ib daim ntawv teev cov phau ntawv tsis tau txais kev cawmdim nyuam qhuav qhib tom qab cov kev ua no. Lawm, lub npe muab rau lawv tau txais. Yog li ntawd, phau ntawv koj yuav tsum tau rov qab, tus neeg siv yuav tsum xam lub sij hawm, uas yog nyob hauv kem Hnub Hloov Kho. Tom qab xaiv cov ntaub ntawv, xaiv rau ntawm lub pob "Qhib".
- Tom qab ntawd, phau ntawv xaiv tau qhib hauv Excel. Tab sis, txawm tias qhov tseeb hais tias nws qhib, cov ntaub ntawv tseem tsis tau txais kev cawmdim. Yuav kom txuag nws, nias ntawm lub pob. "Tseg Rau"uas yog nyob rau ntawm daim kab xev ntxiv.
- Tus txheem ntaub ntawv tseg cia qhib qhov chaw uas koj tuaj yeem xaiv nws qhov chaw thiab hom ntawv, thiab hloov nws lub npe. Tom qab xaiv ua, nyem rau ntawm lub pob. "Txuag".
Phau ntawv no yuav raug cawm nyob rau hauv qhov kev qhia teev. Qhov no yuav rov qab muab dua.
Txoj kev 3: Manually qhib phau ntawv uas tau txais kev cawmdim
Tseem muaj kev xaiv qhib cov ntaub ntawv ntawm cov ntaub ntawv tsis tau txais kev cawm siav. Tau kawg, qhov kev xaiv no tsis yog yooj yim raws li yav dhau los, tab sis, txawm li ntawd los, qee zaum, piv txwv li, yog tias qhov kev ua haujlwm ntawm qhov kev pab cuam puas tsuaj, nws tsuas yog ib qho ua tau rau cov ntaub ntawv rov qab.
- Tua tawm Excel. Mus rau lub tab "Cov Ntaub Ntawv". Nias ntawm seem "Qhib".
- Lub qhov rais qhib ib daim ntawv yog pib. Hauv qhov rai no, mus rau qhov chaw nyob nrog cov qauv hauv qab no:
C: Cov neeg siv username AppData Local Microsoft Office UnsavedFilesNyob rau hauv qhov chaw nyob, tsis yog tus nqi "tus neeg siv lub npe" koj yuav tsum tau hloov lub npe ntawm koj tus account hauv Windows, uas yog, lub npe ntawm daim nplaub tshev ntawm lub computer nrog cov neeg siv xov xwm. Tom qab koj mus rau qhov directory, xaiv cov cua ntsawj ntshab ntawv uas koj xav kom rov qab. Peb nias lub khawm "Qhib".
- Tom qab phau ntawv tau qhib, peb txuag nws rau hauv ib lub disk rau tib txoj kev uas peb twb tau hais los saum no.
Koj tseem tuaj yeem nkag mus rau hauv phau ntawv khaws cia ntawm cov ntaub ntawv sau cia los ntawm Windows Explorer. Qhov no yog hu ua ib daim nplaub tshev Unsavedfiles. Txoj kev rau nws yog qhia saum toj no. Tom qab ntawd, xaiv qhov yam ntaub ntawv kom rov qab thiab nias rau ntawm sab laug nas khawm.
Cov ntaub ntawv yog launched. Peb ua nws txoj hauv kev li niaj zaus.
Raws li koj tau pom, txawm tias koj tsis muaj sij hawm los khaws phau ntawv ntawm Excel thaum lub computer yuam kev, los yog ua yuam kev tau txuag nws thaum kaw, tseem muaj ntau txoj kev los mus rov qab tau cov ntaub ntawv. Qhov loj tshaj rau kev rov qab los yog qhov xam nrog ntawm qhov kev zov me nyuam.
