Gcwalisa ngokuzenzakalelayo amaseli ku-Microsoft Excel

Uma i-Excel autosave inikwe amandla, ke lolu hlelo lugcina ngezikhathi ezithile amafayela alo okwesikhashana kumhlahlandlela othize. Uma kwenzeka izimo ezingalindelekile noma izinkinga zokuhlela, zingabuyiselwa. Ngokuzenzakalelayo, ukuvimba ngokuzenzakalelayo kuvunyelwe ngezikhathi zamaminithi angu-10, kodwa ungashintsha le nkathi noma ukhubaza lesi sici ngokuphelele.

Njengomthetho, emva kokuhluleka, i-Excel ngokusebenzisa isikhombimsebenzisi sayo yenza umsebenzisi enze inqubo yokutakula. Kodwa kwezinye izimo kuyadingeka ukuthi usebenze namafayela wesikhashana ngokuqondile. Khona-ke kuyadingeka ukwazi ukuthi ziphi. Ake sibhekane nalolu daba.

Indawo yamafayela wesikhashana

Masinyane kumele ngithi amafayela wesikhashana ku-Excel ahlukaniswe abe izinhlobo ezimbili:

  • Izinketho ze-autosave;
  • Izincwadi ezingalondoloziwe.

Ngakho-ke, ngisho noma ungazange unike amandla amandla we-autosave, usengakwazi ukubuyisela le ncwadi. Yiqiniso, amafayela alawa mafomu amabili atholakala kumarekhodi ahlukene. Ake sithole ukuthi ziphi.

Ukubeka ama-Autosave Files

Ubunzima bokucacisa ikheli elithile ukuthi emacaleni ahlukene angeke kube kuphela inguqulo ehlukile yesistimu yokusebenza, kodwa futhi negama le-akhawunti yomsebenzisi. Futhi lesi sici sokugcina sinquma futhi ukuthi ifolda enezici esiyidingayo iyatholakala. Ngenhlanhla, kunendlela yonke jikelele yokuba wonke umuntu athole lolu lwazi. Ukuze wenze lokhu, landela lezi zinyathelo.

  1. Iya kuthebhu "Ifayela" I-Excel. Chofoza egameni lesigaba "Izinketho".
  2. Iwindi ye-Excel ivula. Yiya esigatshaneni "Gcina". Ngakwesokudla kwesigcawu eqenjini lezilungiselelo "Ilondoloza Amabhuku" kudingeka uthole ipharamitha "Idatha yedatha yokulungisa ngokuzenzakalelayo". Ikheli elichazwe kule nkambu libonisa isiqondisi lapho amafayela wesikhashana atholakala khona.

Isibonelo, kubasebenzisi be-Windows 7 system yokusebenza, iphethini yekheli kuyoba kanje:

C: Abasebenzisi igama lomsebenzisi AppData roaming Microsoft Excel

Ngokwemvelo, esikhundleni sokubaluleka "igama lomsebenzisi" Udinga ukucacisa igama le-akhawunti yakho kulesi senzakalo se-Windows. Kodwa-ke, uma wenza konke okuchazwe ngenhla, awudingi ukufaka noma yini eyengeziwe, ngoba indlela egcwele eya esiqondisweni izoboniswa endaweni efanele. Ukusuka lapho ungayibhala bese uyinamathisela I-Explorer noma wenze noma yiziphi ezinye izenzo ozibonayo ezidingekayo.

Qaphela! Indawo yamafayela we-autosave nge-Excel interface kubalulekile futhi ukubona ngoba ingashintshwa ngokuzenzakalelayo emkhakheni othi "Ukubuyiswa kwemoto ngokubuyisela idatha", ngakho-ke angeke ifane nesifanekiso esacacisiwe ngenhla.

Isifundo: Indlela yokusetha i-autosave ku-Excel

Ukubeka izincwadi ezingalondoloziwe

Okuncane kakhulu kunzima yizincwadi ezingakalungi ngokuzenzakalela. Ikheli lendawo yokugcina yale mafayela ngokusebenzisa isikhombimsebenzisi se-Excel singatholakala kuphela ngokumisa isimiso senqubo yokutakula. Azikho kufolda ehlukile ye-Excel, njengokwesikhashana esidlule, kodwa ngokujwayelekile ukugcina amafayela angaphunyiwe kuwo wonke imikhiqizo ye-software ye-Microsoft Office. Izincwadi ezingalondoloziwe zizotholakala kuqondisi olutholakala kuthempulethi elandelayo:

C: Abasebenzisi igama lomsebenzisi AppData Local Microsoft Office UnsavedFiles

Esikhundleni sokubaluleka "Igama lomsebenzisi", njengesikhathi esidlule, udinga ukufaka igama le-akhawunti esikhundleni. Kodwa uma ngokuphathelene nendawo yamafayela we-autosave asizange sikhathazeke ngokuthola igama le-akhawunti, njengoba singathola ikheli eligcwele lomshuwalense, ngakho-ke kulesi simo udinga ukwazi.

Ukuthola igama le-akhawunti yakho kulula. Ukwenza lokhu, chofoza inkinobho "Qala" engxenyeni engezansi kwesokunxele kwesikrini. Phezulu kwephaneli evelayo, i-akhawunti yakho izofakwa ohlwini.

Vele uyifake endaweni ephethini esikhundleni senkulumo. "igama lomsebenzisi".

Ikheli eliholayo lingenza, isibonelo, lifakwe kulo I-Explorerukuya emkhokheni oyifunayo.

Uma udinga ukuvula indawo yokugcina yezincwadi ezingalondoloziwe ezidalwe kule khompyutha ngaphansi kwe-akhawunti ehlukile, ungathola uhlu lwamagama omsebenzisi ngokulandela le miyalo.

  1. Vula imenyu "Qala". Hamba ngokusebenzisa into "Iphaneli Yokulawula".
  2. Ewindini evulekayo, hamba kusigaba "Ukwengeza nokususa amarekhodi womsebenzisi".
  3. Ewindini elisha, akukho sinyathelo esengeziwe esidingekayo. Lapho ungabona ukuthi yimaphi amagama womsebenzisi kule PC atholakalayo bese ukhetha okufanele uwasebenzise ukuze ufike esihlalweni sesitoreji sezincwadi zokusebenzela ze-Excel ezingalondoloziwe ngokufaka esikhundleni senkulumo kwisifanekiso sekheli "igama lomsebenzisi".

Njengoba kushiwo ngenhla, indawo yokugcina yezincwadi ezingalondoloziwe nayo ingatholakala ngokufanisa inqubo yokutakula.

  1. Yiya ohlelweni lwe-Excel kuthebhu "Ifayela". Okulandelayo, hamba kusigaba "Imininingwane". Engxenyeni efanele yefasitela chofoza inkinobho. Ukulawula Inguqulo. Emenyu evula, khetha into "Buyisela izincwadi ezingaphephile".
  2. Iwindi lokutakula livula. Futhi ivula ngokuqondile kule directory lapho amafayela ezincwadi ezingalondoloziwe agcinwa khona. Singakhetha kuphela ibha yekheli kule window. Okuqukethwe kuyoba ikheli lencwadi lapho kukhona khona izincwadi ezingaphephile.

Khona-ke singenza inqubo yokutakula ewindini elifanayo noma sisebenzise ulwazi olutholiwe mayelana nekheli lezinye izinjongo. Kodwa udinga ukucabangela ukuthi lolu khetho lufanelekile ukuze uthole ikheli lendawo yezincwadi ezingalondoloziwe ezidalwe ngaphansi kwe-akhawunti osebenza ngaphansi. Uma udinga ukwazi ikheli kwenye i-akhawunti, sebenzisa indlela echazwe ngaphambilini.

Isifundo: Ukuthola ibhuku lokusebenzela elingaphephile

Njengoba ungabona, ikheli eliqondile lendawo yamafayela e-Excel yesikhashana ingatholakala ngokusebenzisa isikhombimsebenzisi somsebenzi. Ukuze ugcine amafayela ngokuzenzakalela, lokhu kwenziwa ngezinhlelo zesistimu, nakwezincwadi ezingalondoloziwe ngokusebenzisa ukulingiswa kokutakula. Uma ufuna ukwazi indawo yamafayela wesikhashana owadalwa ngaphansi kwe-akhawunti ehlukile, ngakho-ke kuleli cala udinga ukuthola futhi ucacise igama lomsebenzisi othize.