Ndekupi ma backups akachengetwa muExcel

Backup kugadzira faira rekuzotevera kudzoreredza data kana iyo yekutanga midhiya ikaputsika kana kunyangarika. Iwe unogona zvakare kugadzira kopi yedata muMicrosoft Excel; chirongwa chine zvishandiso zveizvi. Kuti udzore ruzivo, unogona kushandisa rimwe basa reExcel - AutoRecovery. Ngatitarisei mikana yese yekudzosera shanduko dzakarasika mumatafura.

Kumisikidza otomatiki backup

Iyo purogiramu inokwanisa kugadzira imwe faira iyo inokopa zvachose yekutanga uye inovandudzwa panguva imwe chete nayo. Kugadzirisa kuchengetedza kunonyanya kukosha mumamiriro ezvinhu apo kune njodzi yekuvharwa kwekukurumidzira kwepurogiramu kana kuvhara kwekombiyuta. Kana mudziyo wako usina kugadzikana, tevera nhanho shoma kuti usarasikirwe neshanduko paspredishiti.

1. Vhura iyo "Faira" tebhu uye tsvaga iyo "Save As" chinhu mumenyu. Dzvanya pairi kuti uvhure dialog box.

2. Muhwindo rinoonekwa, vhura menyu diki "Sevhisi", bhatani riri pazasi. Inoda General Options.

3. Tarisa bhokisi rakanzi "Gara uchichengetedza". Mimwe minda ine sarudzo. Kana uchida, iwe unogona pakarepo kudzivirira gwaro nepassword uye kuseta yakakurudzirwa yekuverenga-chete yekuwana. Kana zvese zvinodiwa muhwindo iri zvaitwa, tinya "OK".

4. Isu tinochengetedza faira kune chero nzvimbo yakakodzera tichishandisa iyo yakafanana "Save As" hwindo. Pachagara paine XLK backup padivi payo mufolda kana padesktop yako.

Mhedzisiro mushure mekunge shanduko yekutanga yachengetwa inoita seizvi:

Zvinokosha! Iye zvino isu tinokwanisa kupindura mubvunzo uko ma backups anochengetwa: mune imwecheteyo folda inochengeterwa faira rekutanga.

Maitiro ekugadzira isingachinjike backup

Kuchengetedza nguva dzose kunochengetedza bhuku rekushanda shanduro Excel, iyo yaive yemazuva ano yekuchengetedza yapfuura. Dzimwe nguva iyi sarudzo haina kukodzera, uye iwe unoda shanduro yegwaro nhanho shoma pamberi pekupedzisira kuchengetedza. Kuti ukwanise kuwana mavhezheni ekutanga egwaro, unofanirwa kuisa yekuwedzera. Microsoft haigove ma-add-ons akadaro pawebhusaiti yepamutemo, iwo akabatanidzwa muchirongwa.

Teerera! Iwe unogona kuwana ma-add-ons munzvimbo dzakavhurika paInternet, kushandiswa kwavo kuri pamutemo. Iva nechokwadi chekutarisa saiti uye kurodha neantivirus system kuitira kuti urege kuisa data rako pachako uye zvinyorwa zvakakosha panjodzi.

Iyo yekuwedzera-mukati inodiwa kuchengetedza inonzi VBA-Excel. Iyo yekuwedzera inobhadharwa, asi iwe unogona kushandisa mabasa ayo panguva yekuedzwa. Inokodzera makomputa ane OS kubva kuWindows XP uye gare gare, kune shanduro dzeExcel kubva 2007 uye gare gare. Mirayiridzo yekuisa inosanganiswa nefaira yekuisa.

1. Kana iyo yekuwedzera-yakaiswa, iyo VBA-Excel tebhu ichaonekwa pane toolbar. Vhura iyo uye tinya bhatani re "Backup".
2. Mubhokisi rebhokisi rinovhura, sarudza nzvimbo yekuchengetedza kuchengetedza uye gadzirisa zvirongwa zvekopi. Kana iwe uchida faira rimwe chete rinokopa zviri mukati meiyo yekutanga, haufanire kunyora nguva yekugadzira otomatiki yemakopi. Dzvanya "Save".

Kana makopi asingachadiwi, unofanirwa kudzvanya bhatani re "Backup". Mutsara we "Cancel backup" uchabuda - tinya pairi, uye mafaera anomira kuoneka. Izvi zvinofanirwa kuitwa chete kana otomatiki makopi marongero akaiswa.

Gadzirisa autosave yekuchinja mugwaro

Mumamiriro ezvinhu ekukurumidzira, kuchengetedza otomatiki kwekuchinja kunobatsirawo. Makopi echinyorwa anoonekwa pane yakakosha tebhu mushure mekutangazve. Panguva dzenguva dzose, purogiramu inonyora zvinyorwa zvose zvinoshanduka zvinowanikwa mubhuku, kana zvigadziridzo zvakakodzera zvakagadzirirwa.

1. Vhura chikamu che "Options" pane "Faira" tab. Bhokisi rebhokisi rine menyu richaonekwa pachiratidziro - "Chengetedza" chinhu chinodiwa.
2. Tarisa iyo Autosave bhokisi uye isa kuti kangani shanduko dzinochengetwa. Iwe unogona kuseta kunyange miniti imwe muzvigadziriso, asi kuchengetedza kwakadai kunoderedza Excel pane isina simba komputa. Izvo zvakakoshawo kutara mutsara unotevera kuitira kuti kana iwe ukavhara gwaro pasina kuchengetedza, yazvino auto-yakarekodhwa vhezheni inochengetwa otomatiki.

3. Sarudza maforodha ekuchengetedza mafaera. Kazhinji ivo vanonyoreswa pakarepo muzvirongwa, uye nzira inotungamira kune Excel mafolda. Kana iwe uchigutsikana nenzvimbo iyo mafaera anochengetwa, haufanirwe kuchinja chero chinhu. Iwe unofanirwa kuziva kwakachengetwa mafaera e autosave kuitira kuti iwe ugone kukurumidza kuawana mune ramangwana.

Mushure mekuvhara kwechimbichimbi kwechirongwa - semuenzaniso, kana uchidzima komputa - unofanirwa kuvhura Excel zvakare uye sarudza faira kuti uchengetedze mu "Document Recovery" tab. Pane autosave zvinyorwa. Ngwarira kunguva yekugadzirwa kwegwaro kuti usarudze shanduro chaiyo.

Zvinokosha! Kana mafaira akachengetwa asingachadiwi, mubhokisi rebhokisi rinoonekwa paunopedza kushanda nemagwaro aya, unofanira kudzvanya bhatani re "Usachengeta".

Maitiro ekudzoreredza bhuku rekushanda reExcel risina kuchengetwa

Kana iwe usina kukwanisa kuvhura yazvino vhezheni yegwaro mushure mekuparara, unogona kuwana iyo folda iyo iripo autosave mafaera anochengetwa. Ngatishandisei mabasa e "Faira" tebhu kuitira kuti tisatsvage folda muExplorer.

1. Kana mushandisi avhura iyo "Faira" tab, chirongwa chinoratidza otomatiki chikamu che "Details". Isu tinowana chinhu "Versions" pazasi pechidzitiro uye tinya bhatani re "Manage versions".

2. Chinhu chimwe chemenu chinovhura - "Dzora Mabhuku Asina Kuchengetwa". Nekudzvanya pairi, iwe unoendeswa kubhokisi rebhokisi rekuvhura gwaro. Tsvaga faira raunoda mune rondedzero uye tinya "Vhura".

Dzimwe nguva hapana magwaro mufolda. Muchiitiko ichi, pedyo ne "Versions" chinhu, pane chinyorwa chinotaura kuti hapana shanduro dzakapfuura dzefaira. Kana izvi zvikaitika, haugone kudzoreredza shanduko dzakaitwa.