Uma i-Excel ifaka isitoreji se-auto, lolu hlelo ngezikhathi ezithile lusindisa amafayela walo wesikhashana kwisikhombi esithile. Uma kwenzeka izimo noma ukwehluleka okungalindelekile emsebenzini wohlelo, zingabuyiselwa. Ngokuzenzakalelayo, isitoreji se-auto sivulekile ngokuvama kwemizuzu eyi-10, kepha le nkathi ingashintshwa noma ikhubaze lesi sici.
Njengomthetho, ngemuva kokwehluleka kwe-Exel, ngesibonisi saso, kunikeza umsebenzisi ukukhiqiza inqubo yokutakula. Kepha, kwezinye izikhathi, ngamafayela wesikhashana udinga ukusebenza ngqo. Lapho-ke kuza ukwazi ukuthi zitholakala kuphi. Ake sikutholele ngalo mbuzo.
Indawo yamafayela wesikhashana
Masinyane udinga ukusho ukuthi amafayela wesikhashana ku-Excel ahlukaniswe ngezinhlobo ezimbili:- Izinto zokugcina ezenzakalelayo;
- Izincwadi ezingalondoloziwe.
Ngakho-ke, noma ngabe awunaso isitoreji se-auto, usenawo amandla okubuyisela incwadi. Kuliqiniso, amafayela alezi zinhlobo ezimbili atholakala kwizikhomba ezihlukile. Ake sibheke ukuthi zibekwa kuphi.
Ukubeka amafayela we-autoshry
Ubunzima bokucacisa ikheli elithile ukuthi ezimweni ezahlukahlukene kungahle kube yinguqulo ehlukile yohlelo lokusebenza, kodwa futhi negama le-akhawunti yomsebenzisi. Futhi kusukela kwinto yokugcina nakho kuya ngokuthi, lapho ifolda itholakala khona nezinto ezidingekayo kithi. Ngenhlanhla, kunendlela efanelekile yokufunda lolu lwazi. Ukuze wenze lokhu, udinga ukwenza lezi zinyathelo ezilandelayo.
- Iya kuthebhu ye- "File" Excel. Chofoza egameni lesigaba se- "Parameters".
- Iwindi le-Excel Parameter livula. Iya esigatshaneni esithi "Ukusindisa". Ngakwesokunene sewindi ku-Izilungiselelo ze- "Gcina Book" Izilungiselelo, udinga ukuthola inketho ethi "Data Catalog". Yikheli elicacisiwe kulo mkhakha libonisa umkhombandlela wesikhundla samafayela wesikhashana.
Isibonelo, abasebenzisi bohlelo olusebenzayo lweWindows 7, ithempulethi yekheli izoba ngale ndlela elandelayo:
C: \ Abasebenzisi \ Userser_name \ appdata \ roaming \ microsoft \ Excel \
Ngokwemvelo, esikhundleni segama elithi "igama lomsebenzisi", udinga ukucacisa igama le-akhawunti yakho kulesi simo seWindows. Kodwa-ke, uma wenza konke njengoba kukhonjisiwe ngenhla, awudingi okungeziwe esikhundleni, ngoba indlela ephelele eya ku-Directory izokhonjiswa ensimini ehambisanayo. Ukusuka lapho ungakopisha bese unamathisela kumqhubi noma wenza ezinye izenzo ozicabangayo.
QAPHELA! Indawo yamafayela we-autosave ngokusebenzisa isikhombimsebenzisi se-Excel kubalulekile ukubukeka ngokwengeziwe futhi ngoba kungashintshwa ngesandla ku- "Ikhathalogi yedatha ye-AutosoreMount" field, ngakho-ke kungenzeka kungahambelani nethempulethi echazwe ngenhla.
Isifundo: Ungayisetha kanjani isitoreji se-auto ku-Excel
Ukubekwa kwezincwadi ezingalondoloziwe
Into enzima kakhudlwana yinto enezincwadi ezingenaso isitoreji esizenzakalelayo. Ungathola ikheli lendawo yokugcina amafayela anjengamafayela anjalo ngokusebenzisa isikhombimsebenzisi se-Excel kuphela ngokulingisa inqubo yokutakula. Azikho kwifolda ehlukile ye-Excel, njengasesimweni esedlule, futhi ngokuvamile ukugcina amafayela angahambisani nawo wonke amaphakethe we-Microsoft Office Software. Izincwadi ezingahambisani zizotholakala kumkhombandlela, otholakala kwithempulethi elandelayo:
C: \ Abasebenzisi \ umsebenzi-umsebenzisi \ appdata \ lendawo \ microsoft \ office
Esikhundleni segama elithi "igama lomsebenzisi", njengasesikhathini esedlule, udinga ukufaka igama le-akhawunti. Kepha, uma singazange sikhathaze ngokucacisa igama le-akhawunti, ngoba lalithola ikheli eliphelele lesikhombisi, khona-ke kulokhu kuyadingeka ukwazi.
Ulula ukuthola igama le-akhawunti yakho. Ukuze wenze lokhu, chofoza inkinobho yokuqala ekhoneni elingezansi kwesokunxele kwesikrini. Phezulu kwephaneli evelayo futhi i-akhawunti yakho izocaciswa.
Vele ungene esikhundleni sethempulethi esikhundleni senkulumo ethi "igama lomsebenzisi".
Ikheli elilandelayo lingaba, ngokwesibonelo, ukufaka umqhubi ozoya ku-Directory oyifunayo.
Uma udinga ukuvula indawo yokugcina izincwadi ezingekho emthethweni ezenziwe kule khompyutha ngaphansi kwe-akhawunti ehlukile, uhlu lwamagama abasebenzisi lungatholakala ngokulandela imiyalo elandelayo.
- Vula imenyu ethi "Qala". Dlula ngephaneli yokulawula.
- Efasiteleni elivula, lithuthele engxenyeni ethi "Ukungeza nokususa Ukuqoshwa Komsebenzisi Ukuqoshwa".
- Ewindini elisha, azikho izenzo ezengeziwe ezingadingi ukwenza. Ungabona lapho, ukuthi yimaphi amagama abasebenzisi kule PC atholakalayo bese ukhetha okufanelekile ukuyisebenzisa ukuze uye kwisikhombi esigciniwe se-Excel's, esikhundleni sokuveza igama lomsebenzisi.
Njengoba kushiwo ngenhla, indawo yokugcina izincwadi ezingahambelani nayo ingatholakala futhi, yenze ukumbumbuluzwa kwenqubo yokutakula.
- Iya kuhlelo lwe-Excel kuthebhu yefayela. Okulandelayo, sithuthela esigabeni "semininingwane". Ngakwesokunene sewindows sichofoza inkinobho ethi "Ukuphathwa Kwenguqulo". Kumenyu evula, khetha "Buyisela Into Engavikelekile".
- Kuvulwa iwindi lokutakula. Ngaphezu kwalokho, kuvulwa kulolo mkhombandlela lapho amafayela ezincwadi ezingalondoloziwe agcinwa khona. Kumele siqokomise kuphela ibha yekheli laleli windi. Kungukuqukethwe kwayo futhi kuzoba ikheli lesikhombi sendawo yezincwadi ezingalondoloziwe.
Okulandelayo, singakwenza inqubo yokubuyiselwa ewindini elifanayo noma sisebenzise imininingwane etholwe ezinye izinhloso. Kepha kuyadingeka ukubheka ukuthi le nketho ilungele ukuthola ikheli lendawo yezincwadi ezingafakwanga ezakhiwe ngaphansi kwe-akhawunti, ngaphansi kwalokho okusebenzayo manje. Uma udinga ukwazi ikheli kwenye i-akhawunti, bese usebenzisa indlela echazwe ekuqaleni kwesikhashana.
Isifundo: Ukubuyisela incwadi ethokomele excrel
Njengoba ukwazi ukubona, ikheli eliqondile lendawo yamafayili esikhashana amafayili atholakala ngesibonisi sohlelo. Amafayela wokugcina auto, lokhu kwenziwa ngamapharamitha wohlelo, nezincwadi ezingalondoloziwe ngokulingiswa kokubuyiselwa kokubuyiselwa. Uma ufuna ukwazi indawo yamafayela wesikhashana abenziwe ngaphansi kwenye i-akhawunti, khona-ke kulokhu kufanele wazi futhi ucacise igama legama lomsebenzisi elithile.