Ngaphandle kwento yokuba, ngokubanzi, inkqubo yeMicrosoft Excel ibonakaliswa linqanaba eliphezulu lokuqina, kunye nesi sicelo, ngamanye amaxesha senzeka. Enye ingxaki enjalo yinkangeleko yomyalezo "Impazamo xa uthumela isicelo somyalelo". Ivela xa uzama ukugcina okanye ukuvula ifayile, kunye nokuchitha ezinye iintshukumo ngayo. Masihlangabene nezinto ezibangele le ngxaki, kwaye inokuthi ipheliswe njani.
Unobangela wempazamo
Zeziphi izizathu eziphambili ezibangela le mpazamo? Unokukhetha oku kulandelayo:- Ukonakaliswa kwenkolelo;
- Ukuzama ukufikelela kwidatha yesicelo esebenzayo;
- Iimpazamo kwirejista yenkqubo;
- Umonakalo kwinkqubo ye-Excel.
Isisombululo
Iindlela zokuphelisa le mpazamo ixhomekeke kwisizathu sayo. Kodwa, kwiimeko ezininzi, kunzima ngakumbi ukumisela isizathu sokuphelisa, isisombululo sengqondo ngakumbi yindlela yesampulu yokuzama ukufumana indlela eyinyani yezenzo eziboniswe ngezantsi.
Indlela yoku-1: Khubaza i-DDE Ihoshe
Uninzi lwazo, ukuphelisa impazamo xa isikhokelo somyalelo sinokususwa ngokukhubaza i-Dde.
- Yiya kwi "Ifayile" yethebhu.
- Cofa kwi "Parameter".
- Kwifestile yeparamitha evula, yiya kwicandelwana "ehambisileyo".
- Sikhangela ibhloko "ngokubanzi". Susa uphawu malunga "nokugcina izicelo zeDDE kwezinye iinkqubo" zeparamitha ". Cofa kwiqhosha "Kulungile".
Emva koko, kwinani elikhulu lamatyala, ingxaki iyashenxiswa.
Indlela 2: Khubaza indlela yokuhambelana
Elinye isizathu esinokwenzeka esichazwe ngaphezulu kwengxaki inokubandakanywa kwimodi yokuhambelana. Ukuze uyikhubazeke, kufuneka uzisebenzise ngoku ngokuthe ngqo.
- Yiya kwi-Windows Explorer, okanye nayiphi na imiphathi yefayile, kwi-Microsoft ye-Microsoftindows ye-Microsoftindows yeSoftware kwikhompyuter yakho. Indlela eya kuyo yile ilandelayo: c: \ iifayile zenkqubo ye-Microsoft \ office ~ Hayi. Inombolo yephakheji yeofisi. Umzekelo, ifolda apho iofisi ye-2007 igcinwe, iya kubizwa ngokuba iOfisi12, yeMicrosoft 2014, iOfisi yeOfisi yeMicrosoft, iOfisi yeMicrosoft 2013 - eOfisi15, njl.
- Kwincwadi yeOfisi sikhangela ifayile ye-Excel.exe. Ndicofa kuyo ngeqhosha le mouse lasekunene, kwaye kwimenyu yomxholo, khetha eyona nto "impahla".
- Kwifestile ye-Excel Properties Window evula, yiya kwithebhu efanelekileyo.
- Ukuba ujonga iibhokisi phambi kwenkqubo "yokuqalisa kwimodi yokuhambelana", okanye "phumezile le nkqubo egameni lomlawuli", ke ubasuse. Cofa kwiqhosha "Kulungile".
Ukuba iibhokisi zokutshekisha azifakwanga kwizinto ezifanelekileyo, emva koko qhubeka ujonge umthombo wengxaki kwenye indawo.
Indlela 3: Ukucoca irejista
Esona sizathu sokubangela impazamo xa sithumela umyalelo kwisicelo se-Excel, ziingxaki kwiRegistry. Ke ngoko, kuya kufuneka sicocwe. Ngaphambi kokuba uqhubeke kwezinye inyathelo, ukuze iqhubele phambili kwiziphumo ezinokubakho ezingathandekiyo zale nkqubo, sicebisa ngamandla ukudala indawo yokubuyisela inkqubo.
- Ukwenzela ukubongoza "Run" iwindows, sifaka i-win + r indibaniselwano yesitshixo kwikhibhodi. Kwifestile evulekileyo, faka umyalelo "wokurenta" ngaphandle kweekowuti. Cofa kwiqhosha "Kulungile".
- Umhleli weRegistry uyavula. Kwicala lasekhohlo lomhleli kukho umthi wezalathiso. Sisiya ku lawulo CurrentVersion ngendlela elandelayo: HKEY_CURRENT_USER \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion.
- Sicima zonke iifolda ezikwi "Vareevisions". Ukwenza oku, cofa kwifolda nganye ngeqhosha lasekunene lemouse, kwaye ukhethe "Cima" kwimenyu yemeko.
- Emva kokucima, qalisa kwakhona ikhompyuter kwaye ujonge ukusebenza kwenkqubo ye-Excel.
Indlela yesi-4: Ukucima isantya seHardware
Isisombululo sexeshana kwingxaki sinokukhubaza isantya se-hardware kwi-Excel.
- Yiya esele sisazi ukuba yindlela yokuqala yokusombulula icandelo lengxaki "kwiparamitha" kwi "Ifayile" yethebhu. Kwakhona, cofa kwinto ethi "Advanced".
- Kwi-Express ye-Explor Parameter Window evula, sikhangela ibhloko "yescreen". Faka i-tick malunga ne "khubaza ukukhawulezisa ukukhawulezisa ukwenziwa komfanekiso". Cofa kwiqhosha "Kulungile".
Indlela ye-5: Ukucima i-onns
Njengoko kuchaziwe apha ngasentla, esinye sezizathu zele ngxaki sinokungasebenzi kakuhle kwabanye abantshutshiso. Ke ngoko, njengemilinganiselo yethutyana, ungasebenzisa i-Excel eyongezelelweyo.
- Kwakhona, yiya kwi "Ifayile" yethebhu, kwicandelo "leparamitha", kodwa ngeli xesha ndicofa kwi "Yongeza".
- Kwinxalenye engezantsi yefestile, kuluhlu "lolawulo", khetha into "yentsomi". Cofa kwi "Pay Potter".
- Susa imikhawuli kuzo zonke ii-on ezidwelisiweyo ezidwelisiweyo. Cofa kwiqhosha "Kulungile".
- Ukuba emva koko, ingxaki inyamalala, emva koko sibuyela kwifestile yendlela enzima. Faka i-tick, kwaye cinezela iqhosha u "Kulungile". Sijonga ukuba ingxaki ayibuyanga. Ukuba yonke into ilungelelene, emva koko uye kwi-Supersts elandelayo, njl. Lo mbandela apho impazamo ibuyise khona, cima, kwaye ungasaguquki. Bonke abanye abantu benzonzobila banokubandakanywa.
Ukuba, emva kokucima zonke ii-on-on, ingxaki isekhona, oko kuthetha ukuba inkolelo inokuvulwa, kwaye impazamo kufuneka ipheliswe ngenye indlela.
Indlela yesi-6: Setha imephu yefayile
Ukusombulula ingxaki, ungazama kwakhona ukuseta kwakhona ifayile.
- Ngeqhosha "Qala", yiya kwiphaneli yokulawula.
- Kwiphaneli yokulawula, khetha icandelo "lenkqubo".
- Kwifestile evula, yiya kwicandelwana elizenzekelayo.
- Kwinkqubo ye-windows engagqibekanga yenkqubo, khetha "Iintlobo zefayile zemephu kunye neeprothokholi zeenkqubo ezithile".
- Kuluhlu lweefayile, khetha ulwandiso lwe-XLLX. Cofa kwi "Inkqubo yoTshintsho".
- Kuluhlu lweenkqubo ezicetyiswayo ezivula, khetha iMicrosoft Excel. Senza iqhosha "Kulungile".
- Kwiinkqubo ze-Excel azikho kuluhlu lweenkqubo ezicetyiswayo, cofa kwi "Ushwankathelo ..." iqhosha. Yiya kwindlela esithetha ngayo, exoxa ngayo indlela yokusombulula ingxaki yokukhupha, kwaye ukhethe ifayile ye-Excel.exe.
- Izenzo ezifanayo zenziwa kwaye zandise i-XLS.
Indlela yesi-7: Khuphela uHlaziyo lweWindows kunye nokubuyisela kwakhona kwakhona i-Ofisi ye-Ofisi ye-Microsoft ye-Microsoft
Hayi ubuncinci kwimpazamo yale mpazamo e-Excel inokuba kukunqongophala kohlaziyo lweWindows olubalulekileyo. Kuya kufuneka ujonge ukuba ngaba zonke uhlaziyo zikhutshelwa ngaphandle, kwaye ukuba kukho imfuneko, Khuphela ilahlekile.
- Vula ipaneli yolawulo kwakhona. Yiya kwicandelo "lenkqubo kunye nezokhuseleko".
- Cofa kwi-Windows Hlaziya igatya.
- Ukuba iwindow evula, kukho umyalezo malunga nokufumaneka kohlaziyo, cofa kwiqhosha "Faka uhlaziyo".
- Silinde de kufike uhlaziyo, kwaye qalisa kwakhona ikhompyuter.
Ukuba akukho zithuba zidwelisiweyo zincedise ukusombulula ingxaki, ke inokuba sengqiqweni ukucinga ngokubuyisela kwakhona i-Ofisi yeSoftwe ye-Microsoft, kwaye malunga nokufaka inkqubo yokusebenza yeWindows ngokupheleleyo.
Njengoko ubona, uninzi lweendlela ezininzi ezinokubakho zokuphelisa impazamo xa uthumela umthetho kwi-Excel. Kodwa, njengommiselo, kwimeko nganye kukho isisombululo esinye kuphela. Ke ngoko, ukuze siyiphelise le ngxaki, kuya kufuneka basebenzise iindlela ezahlukeneyo zokusombulula impazamo, kude kufike ukhetho oluchanekileyo.