Indlela yokuxazulula izinkinga zokulondoloza amafayela amakhulu ku-Excel

Uma usebenza ngamaspredishithi amakhulu, kuvamile ukuthi i-Excel ihambe kancane, ithathe isikhathi eside ukulondoloza, noma ibonise amaphutha uma izama ukulondoloza . Ngezinye izikhathi ifayela alibonakali likhulu kangako, kodwa lisaphahlazeka, lithatha isikhathi eside, noma likhiphe imiyalezo ekhungathekisayo ethi "Idokhumenti ayigcinwanga".

Ngokuvamile, la maphutha awabangelwa yinoma yini "eyimfihlakalo," kodwa kunalokho yinhlanganisela yemikhawulo ye-Excel, izinkinga zesikhala, izindlela zamafayela ezinde kakhulu, izingxabano ze-antivirus, amafayela afomethiwe ngokweqile, nezinye izinto eziqoqana kuze kube yilapho incwadi yokusebenzela ingazinzile. Izindaba ezinhle ukuthi cishe njalo ungagwema ukulahlekelwa umsebenzi wakho futhi ubuyisele ukuphendula okuthile kufayela uma wazi ukuthi ubheke kuphi.

Indlela i-Excel egcina ngayo amafayela nokuthi kungani yehluleka ngezincwadi ezinkulu zomsebenzi

Ukuze uqonde ukuthi kungani incwadi enkulu yokusebenzela ngezinye izikhathi ingalondolozi kahle noma yonakale , kuyasiza ukwazi, ngokuvamile, ukuthi i-Excel yenzani uma uchofoza u-Save noma u-Save As.

Ngaphakathi, uhlelo alulifaki ifayela esikhundleni salo ngqo. Esikhundleni salokho, i-Excel iqale idale ifayela lesikhashana kufolda efanayo yendawo , enegama elingahleliwe futhi engenaso isandiso esibonakalayo (isibonelo, into efana ne-Cedd4100). Bese ibhala konke okuqukethwe yincwadi yokusebenza, kufaka phakathi zonke izinguquko ozenzile, kuleli fayela lesikhashana.

Uma ulondoloza ifayela elikhona kakade, isinyathelo esilandelayo ukuthi i-Excel isuse ifayela lokuqala uma ifayela lesikhashana selibhalwe ngempumelelo . Kuphela uma lokho kususwa sekuqediwe lapho liqhubekela esigabeni sokugcina senqubo.

Ekugcineni, i-Excel iqamba kabusha ifayela lesikhashana libe yigama olibonayo (isibonelo, i-Book1.xlsx), ithatha indawo yelokuqala. Le nqubo yenzelwe ukunciphisa ingozi yokonakala, kodwa uma iphazamiseka nganoma yisiphi isikhathi, kuzovela izinkinga.

Uma kukhona okungahambi kahle ngale ndlela yokusebenza, izinto eziningana zingase zenzeke: amafayela esikhashana angashiywa ngemuva , inguqulo yokuqala ingase ilahleke, noma ifayela lamanje lingashiywa lingaphelele . Kuye ngesikhathi esiqondile sokwehluleka, uzobona imilayezo yamaphutha ehlukene, futhi umonakalo ungaba mkhulu kakhulu noma ungabi mkhulu kangako.

Uma umlayezo ubonisa ukuthi "noma yimaphi amakhophi agciniwe ngaphambilini asusiwe" noma ukuthi "idokhumenti ayigciniwe ," isimo sishintsha kancane. Kulezi zimo, inqubo ivame ukuphazamiseka esigabeni lapho i-Excel isusa ifayela lokuqala noma iqamba kabusha elo lesikhashana, ngakho ifayela lesikhashana elifundekayo lingase lihlale, kodwa elokuqala alisekho.

Uma inkinga ihambisana nokuphahlazeka kwesistimu noma ukucima kukagesi ngokuzumayo, okungcono kakhulu ukuthola nokuvula lelo fayela lesikhashana kufolda yendawo oya kuyo . Enye indlela yokugxila ekusesheni kwakho ukuhlola amafayela akamuva ku-Windows 11 noma kufolda yesikhashana yeseshini ukuthola ifayela elisolisayo.

Imiyalezo yamaphutha evamile lapho igcinwa nokuthi isho ukuthini ngempela

Uma usebenza ngezincwadi zomsebenzi ezinkulu noma uxhumano lwe-inthanethi olungazinzile, i-Excel ingabonisa imiyalezo yamaphutha njengokuthi "Idokhumenti ayigciniwe," "Idokhumenti ayigciniwe ngokugcwele," noma efanayo . Nakuba izwakala ifana, imbangela ingahluka kancane.

Izaziso ezijwayelekile ezihlobene nenqubo yokulondoloza yilezi:

• "Idokhumenti ayilondolozwanga"
• "Idokhumenti ayilondolozwanga ngokuphelele"
• "Idokhumenti ayilondolozwanga. Noma yimaphi amakhophi alondolozwe ngaphambilini asusiwe."
• "Idokhumenti ayilondolozwanga"

Ezimweni ezimbili zokuqala, ngokuvamile kusho ukuthi iphutha lenzeka ngenkathi i-Excel izama ukudala noma ukubhala ifayela lesikhashana . Ngokuvamile, ifayela lokuqala lihlala linjalo kudiski futhi lokho okubonayo esikrinini kusesememori, ngakho-ke usenethuba lokuzama ukulilondoloza.

Lokhu kuphazamiseka kungabangelwa yinto elula njengokucindezela ukhiye we-ESC phakathi nokulondoloza, iphutha lehadiwe noma lesofthiwe, noma ngisho nenkinga ngesitoreji ngokwaso (idrayivu yangaphandle eyonakele, inethiwekhi engazinzile, njll.). Kulesi simo, kuyalulekwa ukuzama ukulondoloza incwadi kwenye idrayivu noma indawo.

Uma umlayezo ubonisa ukuthi "noma yimaphi amakhophi agciniwe ngaphambilini asusiwe" noma ukuthi "idokhumenti ayigciniwe ," isimo sishintsha kancane. Kulezi zimo, inqubo ivame ukuphazamiseka esigabeni lapho i-Excel isusa ifayela lokuqala noma iqamba kabusha elo lesikhashana, ngakho ifayela lesikhashana elifundekayo lingase lihlale, kodwa elokuqala alisekho.

Uma inkinga ihambisana nokuphahlazeka kwesistimu noma ukucima kukagesi ngokuzumayo, okungcono kakhulu ukuthola nokuvula lelo fayela lesikhashana kufolda yendawo oya kuyo . Enye indlela yokugxila ekusesheni kwakho ukuhlola ifolda(amafolda) yesikhashana yeseshini ukuthola ifayela elisolisayo.

Izici ezivimbela ukulondolozwa kwamafayela amakhulu ku-Excel

Incwadi enkulu ayihlali ibangela izinkinga, kodwa ngale kwephuzu elithile, imikhawulo yesistimu, ifomethi yamafayela, kanye nendlela amakhasi ahlelwe ngayo kuba yizinto ezibaluleke kakhulu . Izizathu ezivame kakhulu zokulondoloza ukwehluleka zilula impela.

Enye yezinkinga ezivame kakhulu isikhala sediski noma isikhala esinganele kudrayivu yenethiwekhi lapho uzama ukulondoloza khona incwadi yokusebenza . Uma kungekho ndawo eyanele yokudala lonke ifayela lesikhashana, i-Excel izobonisa izexwayiso ezinjengokuthi "Idiski igcwele" futhi ngeke ikwazi ukuqeda inqubo.

Enye inkinga evamile izimvume ezinqunyelwe kuma-drive enethiwekhi noma amafolda ezinkampani . Ungase ube nokufinyelela kokufunda, kodwa hhayi imvume yokubhala ephelele, okungabangela ukulondoloza ukuthi kwehluleka noma kukuvimbele ekushintsheni ifayela lokuqala ngelesikhashana.

Ukungqubuzana nesofthiwe yokuphepha nakho kuyimbangela. Ezinye izinhlelo ze-antivirus ziskena amafayela asanda kudalwa noma aguquliwe ngesikhathi sangempela futhi zingavimba ukufinyelela okwesikhashana , lapho i-Excel iphakathi nokulondoloza. Umphumela: amaphutha lapho kulondolozwa izincwadi zokusebenza ezikhona, kuyilapho amafayela amasha ebonakala esebenza ngaphandle kwezinkinga.

Enye inkinga ebalulekile yizincwadi zomsebenzi ezabiwe noma izincwadi zomsebenzi ezivulwa ngabasebenzisi abangaphezu koyedwa ngesikhathi esisodwa . Uma wena nomunye umuntu nizama ukulondoloza ifayela elifanayo ngesikhathi esifanayo, i-Excel ayikwazi ukulibhala ngaphezulu ngoba esinye isibonelo sesivele silishintsha. Lokhu kubangela ukungqubuzana kokwabelana okuvamile kanye nemiyalezo yokukhiya amafayela.

Ekugcineni, kukhona imbangela enganakwa kangako: ubude bendlela kanye negama lefayela . Ku-Windows, uma indlela ephelele (amafolda + igama lefayela) idlula imikhawulo ethile, i-Excel ingabuyisa amaphutha anjengokuthi "Igama lefayela alivumelekile" lapho izama ukuligcina noma ukulivula, ikakhulukazi uma liseduze nezinhlamvu ezingu-218 noma ngaphezulu.

Uma usayizi wefayela ungesiwo lowo obonakala: imigqa engenalutho, ukufometha, nezitayela

Umthombo ovamile wezinkinga zekhanda ukuthola ukuthi incwadi yokusebenzela ebonakala ilula, enemigqa embalwa yedatha kanye namafomula athile ayisisekelo, ithatha amakhulu ama-megabytes futhi kuthatha isikhathi ukuyivula nokuyigcina . Abantu abaningi baye bahlangana nefayela elingaphezu kwama-200 MB, ngokombono, elaliqukethe amakhasi ambalwa anezibalo ezilula.

Ezimweni eziningi zalezi, inkinga ukuthi ishidi linamakhulu ezinkulungwane noma ngisho nezigidi zemigqa engenalutho i-Excel eyibheka njenge-"used ," ngezinye izikhathi ngenxa yokufometha okusetshenziswe ngokungahlosile kuyo yonke ikholomu, iseli elilahlekile ekugcineni elinenani noma ifomula, noma ububanzi obungakhethiwe kahle.

Indlela esheshayo yokuthola lokhu ukusebenzisa inhlanganisela ye-CTRL + END ukuze uye "eselini lokugcina elisetshenzisiwe" eliqashelwa yi-Excel ephepheni . Uma ukwenza kanjalo kukuyisa emgqeni ongaqondakali, ongaphansi kakhulu kwendawo yangempela yedatha, kuwuphawu olucacile lokuthi kukhona okumaka leyo migqa njengesebenzayo (kungaba okuqukethwe noma ukufometha).

Isixazululo esisebenzayo kulezi zimo ukususa yonke imigqa namakholomu engeziwe kuze kube sekupheleni kweshidi . Isibonelo, ngokubeka ikhesa yakho emgqeni ngokushesha ngemva komugqa wakho wokugcina wedatha, ukhethe yonke imigqa namakholomu, bese uwasusa.

Inqubo ejwayelekile izoba yile:

1. Khetha umugqa ongezansi komugqa wokugcina onedatha noma amafomula avumelekile (chofoza inombolo yomugqa).
2. Usar I-CTRL + SHIFT + Umcibisholo Wesokudla ukwelula ukukhetha kukholomu yokugcina.
3. Pulsar I-CTRL + SHIFT + DOWN ACROW ukukhetha kuze kufike emgqeni wokugcina otholakalayo weshidi.
4. Susa yonke imigqa ekhethiwe.
5. Londoloza ifayela, ulivale, bese ulivula kabusha ukuze i-Excel "isethe kabusha" iseli lokugcina elisetshenzisiwe.

Ezimweni ezingaphezu kweyodwa zangempela, ukusebenzisa le nqubo yokuhlanza ekhasini ngalinye kunciphise usayizi wencwadi kusuka ku-200 MB kuya ngaphansi kuka-400 KB , kanye nokuthuthuka okukhulu ekuvuleni nasekugcineni isivinini. Kuphinde kunciphise kakhulu ingozi yokuphahlazeka.

Amafomethi, izitayela, kanye nokufometha okunemibandela: izitha ezithule zokusebenza

Ngale kwemigqa “yezipoki”, esinye isizathu esenza izincwadi ezinkulu zihambe kancane futhi ziqine lapho zilondolozwa ukusetshenziswa ngokweqile kokufometha, izitayela, kanye nemithetho yokufometha enemibandela.

Ukufometha amaseli kuyasiza ekwenzeni idatha iqondakale ngokushesha, kodwa ukusebenzisa ukufometha emigqeni noma kumakholomu aphelele angasetshenziswanga empeleni kungabangela usayizi wencwadi yokusebenza ukhuphuke kakhulu. Kunjalo nangamakhulu noma izinkulungwane zezitayela zamaseli ezahlukene, okungase futhi kubangele iphutha elithi "Amafomethi amaseli amaningi kakhulu ahlukene".

Ukuze kusizwe ngalokhu, iMicrosoft inikeza isengezo esibizwa ngokuthi "Clean Up Excess Cell Formatting ," esihlanganiswe kuthebhu yemibuzo yezinhlelo ezithile ze-Office (Microsoft 365 kanye ne-Office Professional Plus 2013, phakathi kwezinye). Uma ungayiboni le thebhu, ungayinika amandla ngokuya ku -File > Options > Add-Ins , ukhethe i-COM Add-Ins ebhokisini le-Manage, bese uhlola inketho ehambisanayo.

Uma i-add-in isivuliwe, mane nje uye kuthebhu ethi Umbuzo bese usebenzisa i- "Clean Excess Cell Formatting ," ukhetha ukuthi ufuna ukusebenza eshidini lamanje noma encwadini yokusebenzela yonke. Ngemva kokusebenzisa ukuhlanza, kuzodingeka ulondoloze izinguquko ukuze ucindezele ifayela.

Uma inkinga ibangelwa izitayela eziningi kakhulu esezivele zenziwe encwadini yokusebenzela , ungasebenzisa amathuluzi athile anconywe yiMicrosoft, njengezinsiza zangaphandle zokuhlanza izitayela kumafayela e-.xlsx/.xlsm noma ama-plugin amafomethi e-.xls/.xlsb enama-binary kanye nezincwadi zomsebenzi ezivikelwe noma ezibethelwe.

Ngesikhathi esifanayo, kungumqondo omuhle futhi ukubuyekeza ukufometha okunemibandela . Uma kunemithetho esetshenziswa kububanzi obukhulu noma ephindwe kabili kumashidi amaningi, ungakhulula izinsiza kanye nesikhala ngokukhetha Ukufometha Okunemibandela > Sula Imithetho > Sula Imithetho kusuka ku-Ishidi Lonke kuthebhu ethi Ikhaya, bese uphinda le nqubo kunoma yimaphi amashidi lapho lesi sici sisetshenziswe khona ngokweqile.

Izibalo, amafomula, kanye ne-RAM: kungani incwadi yokusebenzela "ejwayelekile" iqina lapho igcina imali

Ngisho noma ifayela lingelikhulu ngama-megabytes, indlela amafomula aklanywe ngayo ingabangela i-Excel ukuthi icindezele i-RAM etholakalayo ize ifike emkhawulweni wayo bese iphahlazeka lapho izama ukubala kabusha nokugcina ama-.

Amacala avamile abeka ingcindezi enkulu enjinini yokubala amafomula abhekisela kumakholomu noma imigqa yonke ngaphandle kwesidingo sangempela (isibonelo, ukusebenzisa i-SUM(A:A) ezinkulungwaneni zamaseli), kanye nokuhlanganiswa okukhulu kwemisebenzi efana ne-SUMIF, COUNTIF, SUMPRODUCT noma amafomula e-array phezu kwamabanga amakhulu.

Imisebenzi eguquguqukayo (njenge-NOW, TODAY, OFFSET, INDIRECT, phakathi kwezinye) nayo idlala indima uma isetshenziswa ngezinga elikhulu, ngoba iphoqa i-Excel ukuthi ibale kabusha kaningi, okubonakala kakhulu kumakhompyutha anememori encane.

Uma usususile imithetho yokufometha, izitayela, kanye nokufometha okunemibandela futhi incwadi yokusebenzela isasebenza ngokungajwayelekile, kufanelekile ukubuyekeza amafomula abalulekile aphindaphindwa izikhathi eziyizinkulungwane noma asebenza kumabanga amakhulu ngokungalingani. Ukwenza lula izinkomba, ukukhawulela ububanzi bokubala emigqeni esetshenzisiwe ngempela, noma ukuhambisa izibalo ezithile kumathebula e-pivot noma ku-Power Query kunganciphisa kakhulu umthwalo womsebenzi.

Kubalulekile ukukhumbula ukuthi, ngale kosayizi nobunzima obuthile, i-RAM yekhompyutha yakho iba yisithiyo esiyinhloko . Uma uhlelo luphelelwa yi-RAM, incwadi yokusebenza ingathatha isikhathi eside ukuyilondoloza noma ngisho nokuphahlazeka. Kulezi zimo, ngaphezu kokwenza ifayela libe ngcono, kuyasiza ukuhlola ukusetshenziswa kwememori ku-Windows futhi ucabangele ukuthuthukisa i-RAM yakho noma ukuvala ezinye izinhlelo zokusebenza ezisebenzisa izinsiza eziningi ngenkathi usebenza ne-Excel.

Imikhawulo yemigqa nekholomu kanye namafomethi efayela ku-Excel

Elinye iphuzu elibalulekile, ikakhulukazi uma usebenza ngamafayela amakhulu ombhalo njenge-.csv noma i-.txt , yimingcele yegridi ye-Excel kanye nefomethi ngayinye yefayela.

Uma uvula isethi yedatha enkulu kakhulu evela kufayela le-CSV, i-Excel ingabonisa isexwayiso esinjengokuthi, "Le sethi yedatha inkulu kakhulu kwigridi ye-Excel. Uma ulondoloza le ncwadi yokusebenza, uzolahlekelwa idatha engalayishwanga ." Ngaleso sikhathi, ifayela selivele lifinyeziwe: kulayishwe imigqa namakholomu amaningi kuphela njengezisekelo zeshidi; okusele kushiywe ngaphandle.

Kulezi zimo, kubalulekile ukukhumbula izinto ezimbili: okokuqala, akufanele ulondoloze ifayela lokuqala , ngoba uzolahlekelwa unomphela noma iyiphi idatha engakalayishwa. Okwesibili, uma udinga ukusebenza nesethi yonke yedatha, i-Excel iyodwa ayanele ukulinganisa igridi.

Inketho ephephe kakhulu ukuvula ibhuku lokusebenzela elingenalutho, bese kuthi kuthebhu yeDatha, usebenzise i-Get & Transform Data (Power Query) ngenketho ethi "From Text/CSV" ukuze ungenise ifayela. Lokhu kukuvumela ukuthi ulayishe yonke isethi yedatha kumodeli yedatha noma kuthebula le-pivot, noma ngabe idlula imikhawulo yomugqa nekholomu ebonakalayo.

Ngokuyilayisha njengomthombo wethebula le-pivot (isibonelo, ngokukhetha okuthi "Layisha ngaphakathi" > Umbiko we-PivotTable), ithebula le-pivot lizokwazi ukufingqa nokuhlaziya yonke isethi yedatha , yize igridi yeshidi lokusebenzela ingenakulibonisa lonke ngesikhathi esisodwa. Kodwa-ke, kubalulekile ukukhumbula ukuthi le ncwadi yokusebenzela ayisaqukethe ifayela le-CSV "elicacile", kodwa inguqulo ecutshunguliwe.

Ngokuphathelene nemikhawulo yefomethi ngayinye, amafayela amadala e-.xls asekela kuphela imigqa engu-65.536 ngeshidi ngalinye , kuyilapho i-.xlsx (kanye ne-.xlsm yayo esuselwe kuyo) ivumela imigqa efika ku-1.048.576. Ngakho-ke, lapho usebenza ngedatha eningi, kubalulekile ukulondoloza ngefomethi ye-.xlsx kune-.xls; ungafunda kabanzi ngamafomethi amafayela ku-Office ukuze ukhethe efaneleke kakhulu.

Izinketho ezisheshayo zokuzama ukulondoloza incwadi yokusebenzela enenkinga ngaphandle kokulahlekelwa idatha

Uma usuvele umatasa kakhulu futhi i-Excel yenqaba ukulondoloza, into ebaluleke kakhulu ukuzama ukulondoloza ulwazi oluningi ngangokunokwenzeka ngaphambi kokuthi uqale ukwenza izivivinyo zokuhlasela . Kunezindlela eziningana ezisebenzayo ongazama ngokulandelana kwazo.

Isinyathelo sokuqala esilula ukulondoloza ibhuku lokusebenzela elinegama elihlukile . Kumenyu yefayela, ukusebenzisa i-Save As nokukhetha igama elihlukile kuphoqa i-Excel ukuthi idale ifayela elisha esikhundleni sokushintsha elikhona. Ngezinye izikhathi inkinga ithinta kuphela ifayela lokuqala, futhi lolu shintsho luyalidlula.

Enye indlela ewusizo kakhulu ukuhambisa wonke amaspredishithi abalulekile encwadini entsha yokusebenzela . Ukuze wenze lokhu, ungakha ishidi "lokugcwalisa", uhlanganise wonke amashidi edatha ngaphandle kwalelo, uchofoze kwesokudla, bese ukhetha u-Hambisa noma u-Kopisha, uwathumele encwadini entsha yokusebenzela. Ngale ndlela, uhudula okuqukethwe kodwa hhayi ngempela konke "udoti" okuqongelelwe kufayela lokuqala.

Uma incwadi yokusebenzela iqukethe ama-macro e-VBA, kuzodingeka futhi ukopishe amamojula ekhodi kusuka kumhleli we-Visual Basic kuya encwadini yokusebenzela entsha . Ngale ndlela, awulahlekelwa yinoma yiluphi uhlobo lwe-logic olungase luhlotshaniswe nezinkinobho, imicimbi, njll.

Ngezinye izikhathi, inkinga ihlobene nefomethi ethile yefayela. Ukuzama ukulondoloza ibhuku lokusebenzela ngefomethi ehlukile kungaxazulula inkinga: isibonelo, uma ifayela liku-.xls, zama ukuligcina njenge-.xlsx noma i-.xlsm, noma ngisho nangesikhashana kwenye ifomethi ukuze ubone ukuthi ukulondoloza kuyaqedwa yini.

Uma usola indawo (inethiwekhi engazinzile, idrayivu yangaphandle ehamba kancane, njll.), isu eliyisisekelo ukuzama ukulondoloza ifayela kufolda noma idrayivu ehlukile : idiski yendawo esikhundleni sedrayivu yenethiwekhi, idrayivu ye-USB flash, njll. Uma isebenza lapho, unezinkomba zokuthi inkinga ivela ezimvume, isikhala, noma ukuzinza kwendlela yokuqala.

Hlola indawo yokuqala: hlola ukulondolozwa kanye nesikhala sediski

Ukuze uthuthukise ukuxilongwa, kuyasiza ukwenza ucwaningo oluncane: dala incwadi entsha yokusebenza engenalutho ngokuphelele bese uzama ukuyigcina endaweni efanayo enenkinga . Uma incwadi entsha yokusebenza igcina ngaphandle kwenkinga kuleyo folda, inkinga kungenzeka ukuthi isefayeleni lokuqala, hhayi indawo. Uma usola indlela, hlola indawo yokugcina ezenzakalelayo yamafayela.

Kodwa-ke, uma ungakakwazi ukulondoloza ifayela elisha kuleyo ndawo, cishe ubhekene nenkinga ngesikhala sediski noma izimvume ezinganele . Esimweni sokuqala, kuzodingeka ukhulule isikhala, bese kwesibili, ubuyekeze izimvume nomphathi wesistimu yakho.

Lokhu kuziphatha kunikeza nezinkomba mayelana nobude begama lefayela noma ukungqubuzana kokwabelana . Isibonelo, uma amafayela anamagama amade kakhulu noma amafayela agcinwe ezindleleni ezinamafolda amaningi angaphansi ehluleka, ukufinyeza indlela nokwenza lula igama kungase kwanele ukwenza i-Excel isebenze ngokujwayelekile futhi.

Uma, ngemva kwalezi zivivinyo, amaphutha eqhubeka futhi kungekho zinkinga zesikhala noma zemvume ezisobala, kuyalulekwa ukuthi ucabange kabusha ngamasu okuhlanza: ukususa imigqa namakholomu angenalutho, ukunciphisa ukufometha, izitayela zokulungisa amaphutha, kanye nokubukeza amafomula asindayo , njengoba kuxoxwe ngakho ngaphambili.

Zama ukuqala kabusha kumodi ephephile bese ugwema izingxabano zangaphandle.

Enye indlela yokuhlukanisa inkinga ukuhlola ukuthi ifayela liziphatha kanjani uma uqala uhlelo kwimodi ephephile futhi usebenza nencwadi yokusebenza kusukela lapho . Kule modi, i-Windows ilayisha kuphela inani elincane, okwenza kube lula ukuvimbela ukuphazamiseka okuvela kwisofthiwe yomuntu wesithathu.

Uma ulondoloza kudrayivu yenethiwekhi, ungaqala futhi uhlelo lwakho ku-Safe Mode nge-Networking bese uzama ukulondoloza ibhuku lokusebenza endaweni efanayo eyabelwe . Uma konke kusebenza ku-Safe Mode futhi ifayela ligcinwa ngaphandle kwamaphutha, cishe kukhona i-plugin, isofthiwe ye-antivirus, ithuluzi lokuvumelanisa, noma into efanayo ephazamisayo.

Ezinguqulweni zakamuva ze-Excel, imodi ephephile yohlelo lokusebenza ingasetshenziswa ukukhubaza izengezo zenkampani yangaphandle nokubona ukuthi zikhona yini ezibangela ukuphahlazeka kokulondoloza . Ukukhubaza okwesikhashana isofthiwe yakho yokulwa namagciwane nakho kungasebenza njengesivivinyo: uma incwadi yokusebenzela igcina kahle ngaphandle kwayo, unesimangalo esicacile.

Uma, ngisho nangemva kokuqala kumodi ephephile noma ngaphandle kwama-plugin, incwadi yokusebenza ingakakwazi ukulondolozwa kahle, khona-ke izinkinga ezifana nezimvume zesistimu, igama lefayela elide kakhulu, noma umonakalo wangaphakathi encwadini yokusebenza ngokwayo kungenzeka . Ezimweni ezimbi kakhulu, amathuluzi okulungisa akhethekile angadingeka.

Uma ifayela selivele lonakele futhi lingavuli noma libonisa amaphutha okuqukethwe okungafundeki, kunezinsiza ezikhethekile zokulungisa amadokhumenti e-Office ezikwazi ukwakha kabusha izincwadi zomsebenzi ze-.xls kanye ne-.xlsx, ukuthola amathebula, izithombe, amashadi, kanye namafomula. Lezi zinsiza zivame ukukuvumela ukuthi ulungise amafayela amaningi ngesikhathi esisodwa futhi ziyahambisana nezinguqulo ezahlukene ze-Excel, yize kufanele zibhekwe njengesixazululo sokugcina.

Gcina i-Excel ne-Windows zisesikhathini, futhi uthuthukise imvelo

Ngaphandle kwezimbangela zangaphakathi zefayela, kwenza umehluko omkhulu nokuthi ngabe i-Excel ne-Windows zisesikhathini . Ukulungiswa okuningi kokuzinza nokusebenza kusatshalaliswa ngezibuyekezo, futhi lokhu kungenza umehluko omkhulu ngezincwadi ezinkulu zomsebenzi.

Ngaphakathi kohlelo lokusebenza ngokwalo, ungahlola izibuyekezo bese uzisebenzisa kusuka ku-akhawunti yakho ye-Office, kuyilapho ku-Windows, kuyalulekwa ukuhlola i-Windows Update njalo ukuze ufake ama-patches kanye nokuthuthukiswa . Ngemva kokubuyekezwa okukhulu okuthile, ukuqala kabusha ikhompyutha yakho kunganconywa ukuze izinguquko zisebenze ngokugcwele.

Uma ubona ukuthi unezinkinga zokulondoloza kuphela uma ifayela liku- drive yangaphandle noma ku-USB disk , kufanelekile ukuzama ukusebenza kufolda yendawo esheshayo kuqala, futhi uma incwadi yokusebenza isilondoloziwe futhi ivaliwe, yikopishele ku-drive yangaphandle. Lokhu kugwema izithiyo noma ukuphazamiseka okufushane kokuxhumeka ngenkathi usebenza.

Kubalulekile futhi ukukhumbula ukuthi izengezo ze-Excel kanye nezandiso zezinkampani zangaphandle zingathinta kabi ukusebenza, ikakhulukazi uma ziphazamisa inqubo yokulondoloza. Uma ukusebenza kuthuthuka ngemva kokuzikhubaza, uzokwazi ukuthi enye yazo ibangela inkinga futhi unganquma ukuthi uyigcine, uyibuyekeze, noma uyishintshe.

Okokugcina, ukusebenzisa izici ezifana ne -Autosave ku-Microsoft 365 kusiza ukunciphisa umthelela walezi zinkinga, ngoba incwadi yokusebenzela igcina izinguquko njalo futhi cishe akunakwenzeka ukuthi ilahlekelwe yimisebenzi emikhulu uma kukhona okungahambi kahle kungazelelwe.

Ngamafuphi, ukuqonda indlela i-Excel egcina ngayo amafayela, ukuthi yiziphi izici ezikhulisa usayizi wangempela wefayela, nokuthi yini okufanele uyenze lapho kuvela amaphutha kukuvumela ukuthi ulindele ukuphahlazeka futhi ulondoloze iningi ledatha yakho, ngisho nasezincwadini zokusebenza ezinkulu kakhulu . Ngemikhuba embalwa emihle (ukulawula ukufometha nezitayela, ukubheka imigqa engenalutho, ukusebenzisa ukufometha okufanele, ukuhlola izindlela zamafayela, nokugcina ikhompyutha yakho ibuyekeziwe), kulula kakhulu ukusebenza namafayela amakhulu ngaphandle kokwesaba ukuthi angaphelele njalo uma uchofoza ku-Londoloza.

I-athikili ehlobene:

I-Windows Explorer iyaphahlazeka uma uzama ukulondoloza amafayela. Ungayilungisa njengochwepheshe

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.