Nws pib sau cov hlwb hauv Microsoft Excel

Yog hais tias Excel autosave enabled, ces qhov kev pab cuam no tsis tu ncua tseg nws cov ntaub ntawv ib ntus rau ib cov directory. Yog hais tias tsis tshwm sim los sis qhov teeb meem tsis zoo, lawv tuaj yeem raug txum tim rov qab. Yog vim li cas, autosave yog enabled ntawm kev ua ntawm 10 feeb, tab sis koj tuaj yeem hloov lub sijhawm no lossis lov tes taw tau cov haujlwm no.

Raws li ib txoj cai, tom qab kev tsis sib haum, Excel los ntawm nws cov lus cog lus rau tus neeg siv los ua kom rov qab kho dua. Tab sis qee kis nws yuav tsum tau ua hauj lwm nrog cov ntaub ntawv ntus ncaj qha. Tom qab ntawd nws yog qhov tsim nyog yuav tau paub qhov lawv nyob qhov twg. Cia peb kho qhov teeb meem no.

Qhov chaw ntawm cov ntaub ntawv ib ntus

Tam sim ntawd kuv yuav tsum hais tias cov ntaub ntawv ntu nyob hauv Excel tau muab faib ua ob hom:

  • Cov ntsiab lus ntawm autosave;
  • Cov ntawv tsis zoo.

Yog li, txawm tias koj tsis tau tso cai rau qhov kev pabcuam, koj tseem muaj qhov option los kho phau ntawv. Muaj tseeb, cov ntaub ntawv ntawm ob hom no muaj nyob hauv ntau hom kev tshawb fawb. Cia peb kawm seb lawv nyob qhov twg.

Placing Autosave Cov Ntaub Ntawv

Qhov nyuaj ntawm specifying ib qhov chaw nyob yog tias nyob rau hauv ntau zaus muaj yuav tsis tsuas yog ib tug txawv version ntawm lub operating system, tab sis kuj lub npe ntawm tus account neeg siv. Thiab qhov kawg yuav los txiav txim qhov twg daim nplaub tshev nrog lub ntsiab peb xav tau nyob. Qhov zoo ces, muaj txoj hauv kev rau txhua tus kom paub cov ntaub ntawv no. Ua li no, ua raws li cov theem no.

  1. Mus rau lub tab "Cov Ntaub Ntawv" Excel. Nias ntawm seem lus "Kev xaiv".
  2. Lub qhov rais Excel opens. Mus rau subsection "Txuag". Nyob rau sab xis ntawm lub qhov rais hauv pawg koom haum "Txuag Phau Ntawv" yuav tsum tau nrhiav tus parameter "Cov ntaub ntawv qhia txog kev kho tsheb pib". Qhov chaw nyob hauv daim teb no qhia tias tus neeg muaj npe nyob rau qhov twg.

Piv txwv, rau cov neeg siv ntawm lub qhov rais 7 operating system, qhov chaw nyob txawv raws li nram no:

C: Cov neeg siv username AppData Roaming Microsoft Excel

Lawm, tsis muaj nqis "username" Koj yuav tsum qhia lub npe ntawm koj tus as khauj nyob rau hauv qhov teeb meem ntawm qhov rais. Txawm li cas los xij, yog tias koj ua txhua yam raws li tau piav saum toj no, ces koj tsis tas yuav hloov dab tsi ntxiv, txij thaum tag nrho txoj kev mus rau qhov directory yuav muab tso rau hauv qhov chaw uas tsim nyog. Los ntawm muaj koj tuaj yeem luam thiab muab tshuaj rau hauv Explorer los yog ua lwm yam yeeb yam uas koj xav tias tsim nyog.

Mloog zoo! Qhov chaw ntawm autosave cov ntaub ntawv ntawm lub Excel interface kuj yog qhov tseem ceeb los saib vim hais tias nws yuav tau manually hloov nyob rau hauv "Cov ntaub ntawv rov qab pib rov", thiab yog li ntawd tej zaum yuav tsis phim lub template uas tau teev saum toj no.

Tshooj: Yuav ua li cas teev autosave hauv Excel

Muab cov ntawv tsis tau txais kev cawmdim

Ib qho nyuab dua me ntsis yog cov ntaub ntawv nrog cov phau ntawv uas tsis muaj teebmeem autosave. Qhov chaw nyob ntawm qhov chaw khaws cia ntawm cov ntaub ntawv xws li hauv Excel interface tuaj yeem pom los ntawm simulating txoj kev rov ua haujlwm. Lawv tsis nyob rau hauv Excel cais dua, xws li hauv cov ntaub ntawv dhau los, tab sis nyob rau hauv ib qho kev rau khaws cia cov ntaub ntawv tsis tau txais kev cawmdim ntawm tag nrho Microsoft Office software khoom. Cov ntawv tsis zoo yuav nyob hauv phau ntawv teev npe nyob hauv cov qauv hauv qab no:

C: Cov neeg siv username AppData Local Microsoft Office UnsavedFiles

Tsis muaj nqis "Lub npe", xws li hauv lub sijhawm dhau los, koj yuav tsum tau hloov lub npe ntawm tus as khauj. Tab sis yog hais txog qhov chaw ntawm cov ntaub ntawv hauv autosave peb tsis thab nrog ascertaining lub npe ntawm tus account, raws li peb yuav tau txais qhov chaw nyob ntawm tus directory, ces qhov no koj yuav tsum paub txog nws.

Nrhiav lub npe ntawm koj tus account yog yooj yim heev. Ua li no, nias qhov khawm "Pib" nyob rau sab qis sab laug ntawm qhov screen. Nyob rau sab saum toj ntawm lub vaj huam sib luag uas tshwm sim, koj tus account yuav tau teev tseg.

Cia li hloov nws nyob rau hauv tus qauv es tsis txhob qhia tawm. "username".

Lub chaw nyob ua tau, piv txwv li, muab tso rau hauv Explorermus rau qhov chaw xav tau.

Yog tias koj xav tau qhib qhov chaw khaws cia rau cov phau ntawv uas tau txais kev cawmdim uas tsim nyob rau hauv lub tshuab computer no, koj tuaj yeem nrhiav cov npe ntawm cov neeg siv npe raws li cov lus qhia nram qab no.

  1. Qhib cov zaub mov "Pib". Mus dhau qhov khoom "Tswj Vaj Huam Sib Luag".
  2. Hauv qhov rais qhib, txav mus rau seem "Ntxiv thiab rho tawm cov neeg siv cov ntaub ntawv".
  3. Hauv qhov rais tshiab, tsis tas ua ntxiv lawm. Muaj koj tuaj yeem pom dab tsi usernames nyob rau hauv lub PC no muaj thiab xaiv ib qho tsim nyog kom siv mus rau qhov chaw khaws cov phau ntawv khaws tseg ntawm Excel uas tau txais kev cawmdim los ntawm kev hloov cov kev qhia nyob hauv qhov chaw nyob template "username".

Raws li hais saum toj no, qhov chaw cia cov phau ntawv tau txais kev cawmdim tuaj yeem pom los ntawm kev simulating txoj haujlwm rov ua haujlwm.

  1. Mus rau Excel program hauv lub tab "Cov Ntaub Ntawv". Tom qab, txav mus rau seem "Cov ntsiab lus". Nyob rau sab xis ntawm lub qhov rais nyem rau ntawm lub pob. Version Control. Hauv daim ntawv qhia tawm, xaiv qhov khoom "Restore unsaved books".
  2. Lub qhov rais rov qab opens. Thiab nws qhib raws nraim nyob rau hauv phau ntawv nyob qhov twg cov ntaub ntawv ntawm cov tau txais kev cawmdim cov ntawv. Peb tsuas tuaj yeem xaiv qhov chaw nyob ntawm qhov rai no. Nws cov ntsiab lus yuav yog qhov chaw nyob ntawm phau ntawv cov phau ntawv uas tau txais kev cawmdim nyob rau hauv.

Tom qab ntawd peb tuaj yeem ua tus txheej txheem zoo rov los nyob hauv tib qhov rais los yog siv cov ntaub ntawv tau txais los ntawm qhov chaw nyob rau lwm cov laj thawj. Tab sis koj yuav tsum xav txog qhov kev xaiv no yog tsim nyog thiaj li yuav nrhiav tau qhov chaw nyob ntawm qhov chaw ntawm cov phau ntawv uas tau txais kev cawmdim uas tau tsim nyob rau hauv cov as khauj uas koj tau ua hauv. Yog tias koj xav paub qhov chaw nyob hauv lwm tus account, ces siv txoj kev uas tau piav qhia me ntsis ua ntej.

Tshooj: Rov qab tau cov ntawv uas tsis tau txais kev cawmdim

Raws li koj tau pom, qhov chaw nyob ntawm qhov chaw nyob ntawm ntu Excel cov ntaub ntawv muaj peev xwm nrhiav tau los ntawm qhov kev pab cuam hauv lub program. Rau cov ntaub ntawv autosave, qhov no yog ua los ntawm qhov chaw zov me nyuam cov teeb tsa, thiab rau cov phau ntawv uas tau txais kev cawmdim los ntawm txoj cai rov qab. Yog tias koj xav paub qhov chaw nyob ntawm ib ntus cov ntaub ntawv uas tau tsim nyob rau hauv ib tus account sib txawv, ces qhov no koj yuav tsum paub thiab qhia lub npe ntawm ib tus neeg siv lub npe.