Lapho agcinwa khona izipele ku-Excel

Ikhophi yasenqolobaneni iwukudalwa kwefayela lokutholwa kwedatha okulandelayo uma kwenzeka imidiya yoqobo iphuka noma inyamalala. Ungakwazi futhi ukudala ikhophi yedatha ku-Microsoft Excel; uhlelo lunamathuluzi alokhu. Ukubuyisela ulwazi, ungasebenzisa omunye umsebenzi we-Excel - Ukubuyisela Okuzenzakalelayo. Ake sicabangele wonke amathuba okubuyisela izinguquko ezilahlekile kumathebula.

Isetha isipele esizenzakalelayo

Uhlelo luyakwazi ukwenza ifayela elengeziwe elikopisha ngokuphelele elokuqala futhi libuyekezwe kanye kanye nalo. Ukusetha ikhophi yasenqolobaneni kubaluleke kakhulu ezimeni lapho kunengozi yokuvalwa kohlelo oluphuthumayo noma ukuvala shaqa kwekhompyutha. Uma idivayisi yakho ingazinzile, landela izinyathelo ezimbalwa ezilula ukuze ungalahlekelwa izinguquko kuspredishithi.

1. Vula ithebhu ethi “Ifayela” bese uthola into ethi “Londoloza Njenge” kumenyu. Chofoza kuyo ukuze uvule ibhokisi lengxoxo.

2. Ewindini elivelayo, vula imenyu encane "Isevisi", inkinobho itholakala ngezansi. Idinga Izinketho Ezijwayelekile.

3. Thikha ibhokisi elithi “Hlala wenze ikhophi yasenqolobaneni”. Ezinye izinkambu ungazikhethela. Uma uthanda, ungakwazi ukuvikela ngokushesha idokhumenti ngephasiwedi futhi usethe ukufinyelela okunconyiwe kokufunda kuphela. Uma konke okudingekayo kuleli windi kwenziwe, chofoza "OK".

4. Sigcina ifayela kunoma iyiphi indawo elula sisebenzisa iwindi elithi “Londoloza Njenge” elifanayo. Kuzohlala kukhona isipele se-XLK eduze kwayo kufolda noma kudeskithophu yakho.

Umphumela ngemva kokuba izinguquko zokuqala zilondoloziwe ubukeka kanje:

Kubalulekile! Manje sesingakwazi ukuphendula umbuzo lapho izipele zigcinwa khona: kufolda efanayo lapho ifayela lokuqala ligcinwa khona.

Usenza kanjani isipele esingaguquleki

Isipele esivamile silondoloza inguqulo yencwadi yokusebenzela Excel, ebikade isesikhathini esisodwa esidlule. Kwesinye isikhathi le nketho ayifanelekile, futhi udinga inguqulo yedokhumenti izinyathelo ezimbalwa ngaphambi kokugcina kokugcina. Ukuze ukwazi ukufinyelela izinguqulo zangaphambili zedokhumenti, kufanele ufake isengezo. I-Microsoft ayisabalalisi izengezo ezinjalo kuwebhusayithi esemthethweni, zifakwe kancane ohlelweni.

Nakani! Ungathola izengezo emithonjeni evulekile ku-inthanethi, ukusetshenziswa kwazo kusemthethweni. Qinisekisa ukuthi uhlola isayithi futhi ulande ngohlelo lwe-antivirus ukuze ungabeki idatha yomuntu siqu kanye nemibhalo ebalulekile engozini.

Isengezo esidingekayo ukuze wenze isipele sibizwa nge-VBA-Excel. Isengezo siyakhokhwa, kodwa ungasebenzisa imisebenzi yaso ngesikhathi sesivivinyo. Ifanele amakhompyutha ane-OS kusukela ku-Windows XP nakamuva, ezinguqulweni ze-Excel kusukela ngo-2007 nakamuva. Imiyalo yokufaka ifakiwe nefayela lokufaka.

1. Uma isengezo sesifakiwe, ithebhu ye-VBA-Excel izovela kubha yamathuluzi. Ivule bese uchofoza inkinobho ethi "Backup".
2. Ebhokisini lengxoxo elivulayo, khetha indawo ozolondoloza kuyo isipele bese usetha izilungiselelo zokukopisha. Uma udinga ifayela elilodwa elikopisha okuqukethwe koqobo, awudingi ukusho isikhathi sokudalwa okuzenzakalelayo kwamakhophi. Chofoza okuthi “Londoloza”.

Uma amakhophi engasadingeki, kufanele futhi uchofoze inkinobho ethi "Yenza isipele". Kuzovela umugqa othi "Khansela isipele" - chofoza kuwo, futhi amafayela azoyeka ukuvela. Lokhu kuzomele kwenziwe kuphela uma izilungiselelo zokukopisha okuzenzakalelayo zisethiwe.

Setha ukulondoloza ngokuzenzakalelayo izinguquko kudokhumenti

Ezimweni eziphuthumayo, ukulondoloza okuzenzakalelayo kwezinguquko nakho kuyasiza. Amakhophi edokhumenti avela kuthebhu ekhethekile ngemva kokuqala kabusha. Ngezikhathi ezithile, uhlelo luqopha ngokuzenzakalelayo zonke izinguquko ezivela encwadini, uma izilungiselelo ezifanele zisethiwe.

1. Vula ingxenye ethi “Izinketho” kuthebhu ethi “Ifayela”. Ibhokisi lengxoxo elinemenyu lizovela esikrinini - into ethi "Londoloza" iyadingeka.
2. Hlola ibhokisi Londoloza ngokuzenzakalela bese usetha ukuthi izinguquko zigcinwa kaningi kangakanani. Ungasetha ngisho nomzuzu owodwa kuzilungiselelo, kodwa ukulondoloza okunjalo kuzonciphisa i-Excel kukhompuyutha ebuthaka. Kuyafaneleka futhi ukuthika umugqa olandelayo ukuze uma uvala idokhumenti ngaphandle kokulondoloza, inguqulo yakamuva erekhodiwe ngokuzenzakalelayo igcinwa ngokuzenzakalelayo.

3. Khetha amafolda okulondoloza ngokuzenzakalelayo amafayela. Ngokuvamile zibhaliswa ngokushesha kuzilungiselelo, futhi indlela iholela kumafolda e-Excel. Uma wenelisekile ngendawo lapho amafayela agcinwa khona, akufanele ushintshe lutho. Udinga ukwazi ukuthi amafayela okulondoloza ngokuzenzakalelayo agcinwa kuphi ukuze uwathole ngokushesha esikhathini esizayo.

Ngemva kokuvala uhlelo oluphuthumayo - isibonelo, lapho ucisha ikhompuyutha - udinga ukuvula i-Excel futhi bese ukhetha ifayela ozoligcina kuthebhu "Yokubuyisela Idokhumenti". Kukhona okufakiwe kokulondoloza ngokuzenzakalela. Naka isikhathi sokudalwa kwedokhumenti ukuze ukhethe inguqulo efanele.

Kubalulekile! Uma amafayela alondoloziwe engasadingeki, ebhokisini lengxoxo elivela lapho uqeda ukusebenza ngale mibhalo, udinga ukuchofoza inkinobho ethi "Ungalondolozi".

Ungayithola kanjani kabusha incwadi yokusebenzela ye-Excel engalondoloziwe

Uma awukwazanga ukuvula inguqulo yakamuva yedokhumenti ngemva kokuphahlazeka, ungakwazi ukufinyelela ifolda lapho kugcinwa khona amafayela akhona okulondoloza ngokuzenzakalelayo. Masisebenzise imisebenzi yethebhu ethi “Ifayela” ukuze singayifuni ifolda ku-Explorer.

1. Uma umsebenzisi evula ithebhu "Ifayela", uhlelo lubonisa ngokuzenzakalelayo isigaba "Imininingwane". Sithola into ethi "Izinguqulo" ngaphansi kwesikrini bese uchofoza inkinobho ethi "Phatha izinguqulo".

2. Into eyodwa yemenyu izovuleka - "Buyisela Izincwadi Ezingagciniwe". Ngokuchofoza kuyo, uzoyiswa ebhokisini lengxoxo ukuze uvule idokhumenti. Thola ifayela olifunayo ohlwini bese uchofoza "Vula".

Kwesinye isikhathi awekho amadokhumenti kufolda. Kulesi simo, eduze kwento ethi "Izinguqulo", kukhona okufakwayo okusho ukuthi azikho izinguqulo zangaphambilini zefayela. Uma lokhu kwenzeka, ngeke ukwazi ukubuyisela izinguquko ezenziwe.