Yuav ua li cas rov qab tau cov ntaub ntawv excel unsaved. Yuav ua li cas yog tias koj tsis khaws cov ntaub ntawv Excel

Thaum ua haujlwm nrog Excel, ntau qhov xwm txheej tuaj yeem tshwm sim, xws li hluav taws xob, kev ua yuam kev. Tag nrho cov no tuaj yeem ua rau cov ntaub ntawv tsis tau khaws cia tseg. Tsis tas li, tus neeg siv nws tus kheej, uas tau nyem rau ntawm lub pob "Tsis txhob txuag" thaum kaw cov ntaub ntawv, kuj yuav yog qhov ua rau muaj teeb meem.

Tej zaum lub computer freezes. Nyob rau hauv rooj plaub no, tsis muaj lwm txoj kev xaiv tab sis yuav pib qhov kev kub ceev reboot. Lawm, lub rooj yuav tsis tau txais kev cawmdim nyob rau hauv cov ntaub ntawv no yog hais tias tus neeg tsis nyob rau hauv tus cwj pwm ntawm tsis tu ncua khaws cov ntaub ntawv. Qhov zoo ntawm no yog tias feem ntau, rov qab tau cov ntaub ntawv Excel uas tsis tau khaws cia yog ua tau vim tias qhov program nws tus kheej tsim cov ntsiab lus rov qab yog tias qhov chaw tsim nyog tau qhib.

3 Txoj Kev Yuav Rov Qab Unsaved Excel Spreadsheet

Ib qho txiaj ntsig loj ntawm Excel yog tias muaj ntau li peb txoj hauv kev los rov qab cov ntaub ntawv ploj. Tib yam mob raws li qhov no ua tau, raws li tau hais los saum toj no, yog lub tshuab ua haujlwm autosave. Txwv tsis pub, koj yuav tsis muaj peev xwm rov qab tau cov ntaub ntawv, txawm ntau npaum li cas koj xav tau. Nws tsuas yog hais tias tag nrho cov ntaub ntawv yuav muab khaws cia rau hauv RAM, thiab nws yuav tsis tuaj rau txuag ntawm lub hard disk.

Yog li ntawd, nws raug pom zoo kom tsis txhob nkag mus rau hauv cov xwm txheej zoo li no. Yog tias koj ua haujlwm nrog Microsoft Excel thiab tsis yog Google Spreadsheets, qhov twg txuag tau ib txwm ua tiav, koj yuav tsum txuag tsis tu ncua.

Nws yuav siv sij hawm me ntsis xyaum, thiab ces nws yuav dhau los ua tus cwj pwm. General ntaub ntawv rov qab mechanism yog raws li nram no:

1. Qhib "Kev xaiv" ntu, uas nyob hauv "Cov Ntaub Ntawv" ntawv qhia zaub mov. Lub pob nws tus kheej mus rau cov ntawv qhia zaub mov nyob ze ntawm "Tsev" tab.
2. Tom ntej no, nyob rau hauv lub dialog box uas tshwm sim, peb nrhiav tau cov "Txuag" seem thiab qhib qhov chaw rau qeb no. Yuav luag thaum pib ntawm cov npe ntawm sab xis muaj qhov teeb tsa autosave. Ntawm no koj tuaj yeem teeb tsa qhov zaus uas Excel yuav cia li khaws cov ntaub ntawv. Lub neej ntawd tus nqi yog 10 feeb, tab sis yog tias koj xav ua cov txheej txheem no ntau zaus (piv txwv li, yog tias koj nquag ua haujlwm ntawm ib daim ntawv thiab muaj sijhawm los ua kom tiav cov haujlwm loj hauv 10 feeb), ces koj tuaj yeem xaiv qhov me dua. lub sijhawm. Nyob rau hauv lem, koj yuav tsum to taub tias nquag autosave yuav tsum, txawm tias me me, tab sis cov kev pab hauv computer. Yog li ntawd, yog tias koj ua haujlwm ntawm lub laptop tsis muaj zog, autosaving ntau dhau tuaj yeem cuam tshuam kev ua haujlwm tsis zoo.
3. Koj kuj yuav tsum tau ua kom paub tseeb tias qhov kev xaiv "Kua qhov tseeb rov qab kho dua tshiab thaum kaw yam tsis txuag" tau qhib. Qhov no yog qhov kev xaiv ua pov thawj rau peb tiv thaiv lub khoos phis tawj tam sim ntawd, kev ua haujlwm tsis ua haujlwm lossis peb tus kheej tsis txaus siab.

Tom qab tag nrho cov kauj ruam saum toj no ua tiav, nyem lub pob OK. Thiab tam sim no cia peb mus ncaj qha mus rau peb txoj kev yuav ua li cas koj thiaj li rov qab tau cov ntaub ntawv uas tau ploj lawm.

Rov qab Unsaved Cov ntaub ntawv hauv Excel manually

Nws tshwm sim tias tus neeg siv xav rov qab cov ntaub ntawv, tab sis nyob rau hauv daim nplaub tshev uas lawv yuav tsum tau, lawv tsis yog. Qhov no feem ntau yog hais txog "UnsavedFiles" nplaub tshev. Vim li cas qhov no tshwm sim? Raws li koj tuaj yeem nkag siab los ntawm lub npe ntawm cov npe no, tsuas yog cov ntaub ntawv uas tus neeg siv tsis tau khaws cia tau muab pov tseg ntawm no. Tab sis muaj cov xwm txheej sib txawv. Piv txwv li, tus neeg siv yav dhau los khaws cov ntaub ntawv, tab sis rau qee qhov laj thawj, thaum kaw lub qhov rais Excel, lawv nias lub pob "Tsis txhob txuag".

Yuav ua li cas thaum muaj qhov xwm txheej zoo li no?

1. Mus rau ntu kev xaiv, uas nyob rau hauv "Cov ntaub ntawv" ntawv qhia zaub mov. Yuav ua li cas qhib nws twb tau piav saum toj no.
2. Tom ntej no, qhib "Txuag" ntu thiab nrhiav qhov chaw, uas yog me ntsis qis dua autosave. Nws hu ua Autosave Data Directory. Ntawm no peb tuaj yeem teeb tsa lub nplaub tshev uas cov ntawv luam theej ntawm cov ntaub ntawv yuav raug cawm, thiab saib daim ntawv tais ceev tseg no. Peb yuav tsum luam txoj hauv kev qhia hauv kab no los ntawm nias qhov tseem ceeb ua ke Ctrl + C.
3. Tom ntej no, qhib File Explorer. Qhov no yog qhov kev pab cuam uas koj tau nkag mus rau tag nrho cov folders. Nyob ntawd peb nyem rau ntawm qhov chaw nyob bar thiab muab tshuaj txhuam txoj hauv kev uas peb tau theej hauv cov kauj ruam dhau los ntawd. Nias Enter. Tom qab ntawd, qhov xav tau nplaub tshev yuav qhib.
4. Ntawm no koj tuaj yeem pom cov npe ntawm cov ntaub ntawv uas tuaj yeem rov qab tau. Nws tseem tsuas yog qhib nws, thiab qhov ntawd yog nws.

Tseem ceeb! Cov ntaub ntawv yuav muaj npe txawv ntawm qhov qub. Txhawm rau txiav txim siab qhov tseeb, koj yuav tsum tsom mus rau hnub uas txuag.

Qhov kev zov me nyuam yuav ceeb toom tias qhov no yog cov ntaub ntawv tsis tau khaws tseg. Txhawm rau kho nws, koj yuav tsum nyem lub pob tsim nyog thiab paub meej tias qhov kev txiav txim.

Yuav ua li cas rov qab tau cov ntaub ntawv Excel uas tsis tau khaws cia

Raws li peb twb to taub lawm, thiaj li yuav rov qab tau cov ntaub ntawv uas tsis tau khaws tseg, koj yuav tsum qhib ib daim ntawv teev npe tshwj xeeb. Koj tseem tuaj yeem siv txoj hauv qab no:

1. Qhib "Cov ntaub ntawv" zaub mov.
2. Nyem rau ntawm lub pob "Qhib". Tom qab nias lub pob no, lub pob tsis ntev los no yuav nyob rau ntawm sab xis ntawm lub vijtsam. Qhov txuas mus rau lub nplaub tshev uas muaj cov phau ntawv tsis tau khaws cia yog nyob rau hauv qab kawg, nyob rau hauv daim ntawv khaws tseg zaum kawg. Koj yuav tsum tau nyem rau ntawm nws.
3. Muaj ib txoj hauv kev ntxiv. Koj tuaj yeem nyem rau ntawm "Cov ntsiab lus" cov ntawv qhia zaub mov hauv tib "Cov Ntaub Ntawv" ntawv qhia zaub mov. Nws muaj rau kev nyem nkaus xwb yog tias qee cov ntaub ntawv twb qhib rau lub sijhawm no. Nyob ntawd peb nyem rau ntawm "Book Management" thiab nyob ntawd koj tuaj yeem pom cov khoom "Restore Unsaved Books". Nws tseem nyem rau ntawm nws thiab qhib cov ntaub ntawv xav tau.

Yuav rov qab tau cov ntaub ntawv Excel li cas tom qab kev sib tsoo

Excel cia li pom qhov program poob. Thaum koj qhib ib daim ntawv thov uas tau poob lawm, ib daim ntawv teev cov ntaub ntawv uas tuaj yeem rov qab tau yuav tshwm sim.

Tom qab ntawd koj tuaj yeem khaws cov ntaub ntawv no. Ntxiv mus, nws raug pom zoo kom ua li ntawd. Peb pom tias Excel nws tus kheej tau npaj los cawm peb, yog tias nws tau muab lub sijhawm zoo li no. Yog tias muaj teeb meem, cov ntaub ntawv yuav raug rov qab los.