Naphezu kokuthi, ngokujwayelekile, i-Microsoft Excel inezinga eliphakeme kakhulu lomsebenzi wokuzinza, izinkinga zenzeka nalolu hlelo lokusebenza. Enye yalezi zinkinga umlayezo "Iphutha ngenkathi ithumela umyalo kuhlelo lokusebenza." Kwenzeka uma uzama ukulondoloza noma ukuvula ifayela, kanye nokufeza ezinye izenzo. Ake sibone ukuthi yini ebangela le nkinga, nokuthi ingayilungisa kanjani.
Izimbangela zephutha
Yiziphi izimbangela eziyinhloko zaleli phutha? Singahlukanisa okulandelayo:
- Ukulimala ku-superstructure;
- Zama ukufinyelela idatha esebenzayo yesicelo;
- Amaphutha ekubhaleni;
- Umonakalo we-Excel.
Ukuxazulula izinkinga
Izindlela zokuqeda leli phutha zithembele kumbangela walo. Kodwa, njengokungathi ezimweni eziningi, kunzima kakhulu ukusungula imbangela kunokuqeda, isisombululo esinengqondo kakhulu ukuzama indlela yokuzama ukuthola indlela efanele yezenzo kusukela ekukhethweni okulethwe ngezansi.
Indlela 1: Khubaza i-DDE Yehlisa
Ngokuvamile, kungenzeka ukuqeda iphutha lapho uthumela umyalo ngokukhubaza i-DDE ukungazinaki.
- Iya kuthebhu "Ifayela".
- Chofoza entweni "Izinketho".
- Kuwindi yemingcele evula, iya esigatshaneni "Okuthuthukisiwe".
- Sifuna ibhokisi lezilungiselelo "Jikelele". Susa ukukhetha "Yeka izicelo ze-DDE ezivela kwezinye izinhlelo zokusebenza". Sicindezela inkinobho "Kulungile".
Ngemuva kwalokho, kunamacala amaningi, inkinga iqedwa.
Indlela 2: Khubaza Imodi Yokuvumelanisa
Enye imbangela yenkinga engenhla ingavunyelwa imodi yokuhambisana. Ukuze ukhubaze, udinga ukwenza njalo izinyathelo ngezansi.
- Sithutha, sisebenzisa i-Windows Explorer, noma noma iyiphi imenenja yefayela, esiqondisweni lapho iphakheji le-Microsoft Office isehlala kukhompyutha. Indlela eya kuyo yile ndlela elandelayo:
C: Uhlelo Lamafayela Microsoft Office OFFICEâ„–
. Ayikho inani le-office suite. Isibonelo, ifolda lapho izinhlelo ze-Microsoft Office 2007 zigcinwa khona yi-OFFICE12, i-Microsoft Office 2010 yi-OFFICE14, i-Microsoft Office 2013 yi-OFFICE15, njalonjalo. - Efonini ye-OFFICE, bheka ifayela le-Excel.exe. Sichofoza kuso nge inkinobho yesokudla yegundane, futhi kwimenyu ebonakalayo yomongo sakhetha into "Izakhiwo".
- Ewindini yezakhiwo ze-Excel evula, iya kuthebhu "Ukuhambisana".
- Uma kukhona amabhokisi okuhlola ngaphambi kwento "Qalisa uhlelo ngokuhambisana nemodi"onjezo "Gijima lolu hlelo njengomqondisi", bese ususa. Sicindezela inkinobho "Kulungile".
Uma amabhokisi okuhlola emaqenjini ahambelanayo engasethiwe, bese uqhubeka ubheka umthombo wenkinga kwenye indawo.
Indlela yesithathu: Ukuhlanzwa kwe-Registry
Esinye sezizathu ezingase zenze iphutha uma uthumela umyalo kwisicelo ku-Excel kuyinkinga ebhalweni. Ngakho-ke, kuzodingeka siyihlanze. Ngaphambi kokuqhubekela phambili ezenzweni ukuze sikwazi ukulwa nemiphumela engathandekayo yale nqubo, sincoma ngokuqinile ukudala uhlelo lokubuyisela indawo.
- Ukuze ukhiphe iwindi "Run", faka inhlanganisela yokhiye Win + R ekhibhodi. Ewindini evuliwe, faka umyalo othi "RegEdit" ngaphandle kwamacaphuno. Chofoza inkinobho ethi "Kulungile".
- I-Registry Editor ivula. Ehlangothini lwesobunxele lomhleli yi-tree directory. Hambisa esiqondisweni "CurrentVersion" ngendlela elandelayo:
HKEY_CURRENT_USER Software Microsoft Windows CurrentVersion
. - Susa wonke amafolda atholakala ku-directory "CurrentVersion". Ukuze wenze lokhu, chofoza kufolda ngayinye inkinobho yegundane kwesokudla, bese ukhetha into emenyu yemongo "Susa".
- Emva kokuqedwa kuqediwe, qala kabusha ikhompyutha bese uhlola ukusebenza kwe-Excel.
Indlela 4: Khubaza ukusheshisa kwe-hardware
Ikhambi lesikhashana le nkinga lingase livaliwe ukusheshisa kwe-hardware ku-Excel.
- Ukuhambisa esigabeni esivele sijwayele kithi ngendlela yokuqala yokuxazulula inkinga. "Izinketho" kuthebhu "Ifayela". Phinda uchofoze into "Okuthuthukisiwe".
- Esikhathini sefasitela ekhethiwe ye-Excel evuliwe, bheka ukuthi izilungiselelo zivimbe "Isikrini". Hlela umaki eduze kwepharamitha "Khubaza ukusheshiswa kwezithombe ze-hardware". Chofoza inkinobho "Kulungile".
Indlela 5: khubaza izengezo
Njengoba kubonisiwe ngenhla, esinye sezimbangela zalenkinga kungenzeka kube ukungasebenzi kwamanye uhlobo lokungeza. Ngakho-ke, njengesilinganiso sesikhashana, ungasebenzisa ukukhubaza ukungena kwe-Excel.
- Futhi, iya kuthebhu "Ifayela"kuya kwesigaba "Izinketho"kodwa khathesi uchofoze into Engeza-ons.
- Ngaphansi phansi kwefasitela ohlwini lokudonsa phansi "Ukuphathwa"khetha into Izengezo ze-COM. Sicindezela inkinobho "Hamba".
- Susa wonke ama-add-on afakwe kuhlu. Sicindezela inkinobho "Kulungile".
- Uma emva kwalokhu, inkinga iphelile, bese siphinda sibuyela ewindini lokungeniswa COM. Beka uphawu, bese uchofoza inkinobho "Kulungile". Hlola ukuthi inkinga ibuyile. Uma konke kuhlelekile, yiya kokungeza okulandelayo, njll. I-add-on lapho iphutha libuyiselwe likhutshaziwe, futhi ayisekho amandla. Zonke ezinye izengezo zinganikwa amandla.
Uma, ngemva kokuvala zonke izengezo, inkinga ihlala, lokhu kusho ukuthi ama-add-on angavulelwa, futhi iphutha kufanele lilungiswe ngenye indlela.
Indlela 6: Hlela kabusha amaFayili eFayili
Ungazama futhi ukusetha kabusha izinhlangano zefayela ukuxazulula inkinga.
- Ngenkinobho "Qala" iya ku- "Iphaneli Yokulawula".
- KuPhaneli Yokulawula, khetha isigaba "Izinhlelo".
- Ewindwangu evulekayo, iya kwesigatshana "Izinhlelo ezizenzakalelayo".
- Esikhathini sefasitela lezilungiselelo zohlelo, ngokuzenzakalelayo, khetha into "Ukuqhathanisa izinhlobo zefayela nezinhlelo zezinhlelo ezithile".
- Kuhlu lwefayela, ukhethe isandiso xlsx. Sicindezela inkinobho "Shintsha uhlelo".
- Kuhlu lwezinhlelo eziphakanyisiwe ezivulwayo, khetha i-Microsoft Excel. Chofoza inkinobho. "Kulungile".
- Uma i-Excel engekho ohlwini lwezinhlelo eziphakanyisiwe, chofoza inkinobho "Buyekeza ...". Hamba ngendlela esayikhuluma ngayo, sixoxe ngendlela yokuxazulula inkinga ngokuvala ukuhambisana, bese ukhetha ifayela le-excel.exe.
- Senza izenzo ezifanayo okwandiswa kwe-xls.
Indlela 7: Landa ama-Windows updates bese ubuyisela i-Microsoft Office
Okokugcina, ukungabikho kwezinguquko ezibalulekile zeWindows kungase kubangele leli phutha ku-Excel. Kubalulekile ukuhlola ukuthi ngabe zonke izibuyekezo ezitholakalayo ziyalandwa futhi, uma kunesidingo, landa lezo ezingekho.
- Phinda uvule iphaneli yokulawula. Yiya esigabeni "Uhlelo nokulondeka".
- Chofoza entweni "I-Windows Update".
- Uma kukhona umlayezo efasiteleni evuliwe mayelana nokutholakala kwezibuyekezo, chofoza inkinobho "Faka izibuyekezo".
- Silinde izibuyekezo okufanele zifakwe, bese siqala kabusha ikhompyutha.
Uma engekho yalezi zindlela ezisize ukuxazulula le nkinga, kungase kudingeke ucabange ngokubuyisela iphakheji le-Microsoft Office, noma ukubuyisela kabusha uhlelo lokusebenza lwe-Windows lonke.
Njengoba ubona, kunezinketho ezimbalwa ezingenzeka zokuqeda amaphutha lapho uthumela umyalo ku-Excel. Kodwa, njengomthetho, esimweni ngasinye esithile kukhona isisodwa esisodwa isixazululo esifanele. Ngakho-ke, ukuze uqede le nkinga, kubalulekile ukusebenzisa indlela yokuhlola ukusebenzisa izindlela ezehlukene zokuqeda iphutha kuze kutholakale ukhetho olufanele kuphela.