Qhov twg yog cov thaub qab khaws cia hauv Excel

Thaub qab yog tsim cov ntaub ntawv rau cov ntaub ntawv tom qab rov qab nyob rau hauv rooj plaub thawj cov xov xwm tawg lossis ploj. Koj tuaj yeem tsim ib daim qauv ntawm cov ntaub ntawv hauv Microsoft Excel; qhov program muaj cov cuab yeej rau qhov no. Txhawm rau rov qab cov ntaub ntawv, koj tuaj yeem siv lwm txoj haujlwm Excel - AutoRecovery. Cia peb xav txog txhua qhov muaj peev xwm rov qab tau cov kev hloov pauv ploj hauv cov ntxhuav.

Kev teeb tsa tsis siv neeg thaub qab

Qhov kev zov me nyuam muaj peev xwm tsim tau ib cov ntaub ntawv ntxiv uas luam tag nrho cov qub thiab hloov kho ib txhij nrog nws. Kev teeb tsa lub thaub qab yog qhov tseem ceeb tshwj xeeb tshaj yog thaum muaj kev pheej hmoo ntawm kev kaw thaum muaj xwm txheej ceev lossis kaw lub computer. Yog tias koj lub cuab yeej tsis ruaj khov, ua raws li ob peb kauj ruam yooj yim kom koj tsis txhob poob kev hloov pauv rau daim ntawv nthuav qhia.

1. Qhib "Cov ntaub ntawv" tab thiab nrhiav cov khoom "Save As" hauv cov ntawv qhia zaub mov. Nyem rau nws qhib lub dialog box.

2. Hauv qhov rai uas tshwm, qhib cov ntawv qhia me me "Service", khawm nyob hauv qab. Yuav Tsum Muaj Kev Xaiv General.

3. Kos lub thawv "Nco ntsoov rov qab". Lwm cov teb yog xaiv tau. Yog tias koj xav tau, koj tuaj yeem tiv thaiv cov ntaub ntawv tam sim ntawd nrog tus password thiab teeb tsa cov ntawv pom zoo nyeem nkaus xwb. Yog tias txhua yam tsim nyog hauv qhov rais no ua tiav, nyem "OK".

4. Peb khaws cov ntaub ntawv mus rau txhua qhov chaw yooj yim siv tib lub "Save As" qhov rai. Yuav ib txwm muaj XLK thaub qab ntawm nws hauv ib lub nplaub tshev lossis ntawm koj lub desktop.

Cov txiaj ntsig tom qab thawj qhov kev hloov pauv tau txais kev cawmdim zoo li no:

Tseem ceeb! Tam sim no peb tuaj yeem teb cov lus nug nyob qhov twg cov ntaub ntawv khaws cia: nyob rau hauv tib lub nplaub tshev uas cov ntaub ntawv qub tau txais kev cawmdim.

Yuav ua li cas los tsim ib tug immutable backup

Ib qho kev thaub qab tsis tu ncua txuag ib phau ntawv ua haujlwm Excel, uas yog mus txog hnub ib save dhau los. Qee lub sij hawm qhov kev xaiv no tsis haum, thiab koj xav tau ib qho version ntawm daim ntawv ob peb kauj ruam ua ntej qhov kawg txuag. Txhawm rau nkag mus rau cov ntawv ua ntej ntawm cov ntaub ntawv, koj yuav tsum nruab ib qho ntxiv-hauv. Microsoft tsis faib cov add-ons li no rau ntawm lub vev xaib raug cai, lawv ib feem suav nrog hauv qhov program.

Ua tib zoo mloog! Koj tuaj yeem nrhiav cov add-ons hauv qhov chaw qhib hauv Is Taws Nem, lawv siv tau raug cai. Nco ntsoov xyuas lub xaib thiab rub tawm nrog lub antivirus system kom tsis txhob tso cov ntaub ntawv ntiag tug thiab cov ntaub ntawv tseem ceeb ntawm kev pheej hmoo.

Cov add-in xav tau rau thaub qab hu ua VBA-Excel. Cov add-on yog them, tab sis koj tuaj yeem siv nws cov haujlwm thaum lub sijhawm sim. Haum rau cov khoos phis tawj nrog OS los ntawm Windows XP thiab tom qab, rau versions ntawm Excel los ntawm 2007 thiab tom qab. Installation cov lus qhia muaj nrog rau cov ntaub ntawv installation.

1. Thaum lub add-in yog ntsia, VBA-Excel tab yuav tshwm sim ntawm toolbar. Qhib nws thiab nyem rau ntawm "Thaub qab" khawm.
2. Nyob rau hauv lub dialog box uas qhib, xaiv ib qho chaw kom txuag tau qhov thaub qab thiab teeb tsa cov ntawv luam. Yog tias koj xav tau ib cov ntaub ntawv uas luam cov ntsiab lus ntawm tus thawj, koj tsis tas yuav sau lub sijhawm ntawm kev tsim cov ntawv luam tsis siv neeg. Nyem "Txuag".

Thaum cov ntawv luam tsis tas yuav tsum tau, koj yuav tsum rov nyem rau ntawm "Backup" khawm. Cov kab "Tshem tawm thaub qab" yuav tshwm sim - nyem rau ntawm nws, thiab cov ntaub ntawv yuav tsis tshwm sim. Qhov no tsuas yog yuav tsum tau ua yog tias tsis siv neeg luam ntawv tau teeb tsa.

Teeb tsa autosave ntawm cov kev hloov pauv hauv ib daim ntawv

Thaum muaj xwm txheej ceev, tsis siv neeg txuag kev hloov pauv kuj tseem pab tau. Cov ntawv theej ntawm cov ntaub ntawv tshwm rau ntawm lub tab tshwj xeeb tom qab rov pib dua. Thaum tsis tu ncua, qhov kev zov me nyuam cia li sau tag nrho cov kev hloov pauv uas tshwm sim hauv phau ntawv, yog tias tsim nyog tau teeb tsa.

1. Qhib "Kev xaiv" ntu ntawm "Cov ntaub ntawv" tab. Lub dialog box nrog cov ntawv qhia zaub mov yuav tshwm sim ntawm qhov screen - yuav tsum tau "Txuag" yam khoom.
2. Kos lub thawv Autosave thiab teem caij hloov pauv tau npaum li cas. Koj tuaj yeem teem sijhawm txawm tias ib feeb hauv qhov chaw, tab sis qhov kev txuag tsis tu ncua yuav qeeb Excel ntawm lub khoos phis tawj tsis muaj zog. Nws kuj tseem tsim nyog ticking kab tom ntej kom thaum koj kaw cov ntaub ntawv yam tsis tau khaws cia, qhov tseeb nws pib-sau version tau txais kev cawmdim.

3. Xaiv cov folders rau autosaving cov ntaub ntawv. Feem ntau lawv tau sau npe tam sim hauv qhov chaw, thiab txoj hauv kev coj mus rau Excel folders. Yog tias koj txaus siab rau qhov chaw nyob qhov twg cov ntaub ntawv tau txais kev cawmdim, koj yuav tsum tsis txhob hloov dab tsi. Koj yuav tsum paub qhov twg autosave cov ntaub ntawv khaws cia kom koj tuaj yeem nrhiav tau sai sai yav tom ntej.

Tom qab kaw qhov kev pabcuam xwm txheej ceev - piv txwv li, thaum kaw lub khoos phis tawj - koj yuav tsum qhib Excel dua thiab xaiv cov ntaub ntawv khaws cia hauv "Cov Ntaub Ntawv Rov Qab" tab. Muaj autosave nkag. Ua tib zoo saib lub sijhawm tsim ntawm cov ntaub ntawv los xaiv qhov tseeb version.

Tseem ceeb! Yog tias cov ntaub ntawv khaws tseg tsis xav tau ntxiv lawm, hauv lub dialog box uas tshwm sim thaum koj ua tiav nrog cov ntaub ntawv no, koj yuav tsum nias lub pob "Tsis txhob txuag".

Yuav ua li cas rov qab tau ib phau ntawv Excel uas tsis tau khaws tseg

Yog tias koj tsis tuaj yeem qhib qhov tseeb version ntawm cov ntaub ntawv tom qab kev sib tsoo, koj tuaj yeem nkag mus rau hauv daim nplaub tshev uas cov ntaub ntawv khaws cia autosave uas twb muaj lawm. Cia peb siv cov haujlwm ntawm "Cov Ntaub Ntawv" tab kom tsis txhob mus nrhiav ib daim nplaub tshev hauv Explorer.

1. Thaum tus neeg siv qhib "Cov ntaub ntawv" tab, qhov kev zov me nyuam cia li qhia txog "Cov Lus Qhia" ntu. Peb pom cov khoom "Versions" nyob rau hauv qab ntawm lub vijtsam thiab nias lub pob "Manage versions".

2. Ib cov ntawv qhia zaub mov yuav qhib - "Rov qab Unsaved Books". Los ntawm txhaj rau nws, koj yuav raug coj mus rau lub dialog box rau qhib ib daim ntawv. Nrhiav cov ntaub ntawv xav tau hauv cov npe thiab nyem "Qhib".

Qee lub sij hawm tsis muaj cov ntaub ntawv hauv cov ntawv tais ceev tseg. Hauv qhov no, nyob ib sab ntawm cov khoom "Versions", muaj qhov nkag tau hais tias tsis muaj cov ntaub ntawv dhau los. Yog tias qhov no tshwm sim, koj yuav tsis tuaj yeem rov qab tau cov kev hloov pauv tau.