Duk da cewa, a gaba ɗaya, Microsoft Excel yana da matsayi mai girma na zaman lafiya, matsaloli ma yana faruwa tare da wannan aikace-aikacen. Daya daga cikin wadannan matsalolin shine saƙon "Kuskure yayin aika umarni zuwa aikace-aikacen." Yana faruwa a lokacin da kake ƙoƙarin ajiye ko bude fayil, da kuma aiwatar da wasu wasu ayyuka. Bari mu ga abin da yake haifar da wannan matsalar, da yadda za a gyara shi.
Dalilin kuskure
Mene ne ainihin mawuyacin wannan kuskure? Za mu iya bambanta da wadannan:
- Damage ga superstructure;
- Ƙoƙari don samun damar bayanai na aikace-aikacen aiki;
- Kurakurai a cikin rajista;
- Dama ta Excel.
Matsalolin matsala
Yadda za a kawar da wannan kuskure ya dangana ne a kan hanyar. Amma, tun a mafi yawancin lokuta, yana da wuya a kafa dalilin fiye da kawar da shi, hanyar da ta dace shine ta gwada hanya na ƙoƙarin gano hanyar da ta dace daga zaɓuɓɓuka da ke ƙasa.
Hanyar 1: Kashe DDE Ƙinƙasa
Yawancin lokaci, yana yiwuwa a kawar da kuskure yayin aika umarni ta hanyar dakatarwa DDE.
- Jeka shafin "Fayil".
- Danna abu "Zabuka".
- A cikin matakan sigogi wanda ya buɗe, je zuwa kasan "Advanced".
- Muna neman tsari na saitunan "Janar". Bude wannan zaɓi "Nuna tambayoyin DDE daga wasu aikace-aikacen". Muna danna maɓallin "Ok".
Bayan haka, a yawancin lokuta, an kawar da matsala.
Hanyar 2: Kashe Yanayin Haɗi
Wataƙila wataƙila ta haifar da matsala ta sama za ta iya taimakawa yanayin daidaitawa. Don ƙaddamar da shi, kana buƙatar ka ci gaba da yin matakan da ke ƙasa.
- Muna motsawa, ta amfani da Windows Explorer, ko kowane mai sarrafa fayil, zuwa shugabanci inda kayan aikin Microsoft Office ke zaune a kan kwamfutar. Hanyar zuwa gare shi kamar haka:
C: Fayilolin Shirin Fayilolin Microsoft Office OFFICE№. A'a. Yawan adadin ofis din. Alal misali, babban fayil inda aka ajiye shirye-shirye na Microsoft Office 2007 zai zama OFFICE12, Microsoft Office 2010 shine OFFICE14, Microsoft Office 2013 ne OFFICE15, da sauransu. - A cikin fayil na OFFICE, bincika fayil na Excel.exe. Mun danna kan shi tare da maɓallin linzamin linzamin dama, kuma a cikin yanayin mahallin da aka bayyana mun zaɓi abu "Properties".
- A cikin maɓallan Properties wanda ya buɗe, je zuwa shafin "Kasuwanci".
- Idan akwai akwati a gaban abu "Gudun shirin a yanayin daidaitawa"ko "Gudun wannan shirin a matsayin mai gudanarwa", sannan cire su. Muna danna maɓallin "Ok".
Idan ba a saita akwati a cikin sassan ba daidai ba, to, ci gaba da bincika tushen matsalar a wani wuri.
Hanyar 3: Tsaftacewar Rubutun
Ɗaya daga cikin dalilan da zai iya haifar da kuskure lokacin aika aikawar zuwa aikace-aikace a Excel shine matsala a cikin wurin yin rajista. Saboda haka, muna buƙatar tsaftace shi. Kafin a ci gaba da kara ayyukan da za a shinge kan yiwuwar sakamakon wannan hanya, muna bada shawara mai karfi wajen samar da maimaita tsari.
- Domin ya fito da window "Run", shigar da maɓallin haɗi Win + R akan keyboard. A bude taga, shigar da umurnin "RegEdit" ba tare da fadi ba. Danna maballin "OK".
- Editan Edita ya buɗe. A gefen hagu na edita shine bishiyar jagorancin. Matsar zuwa jagorar "CurrentVersion" kamar haka:
HKEY_CURRENT_USER Software Microsoft Windows CurrentVersion. - Share dukkan fayilolin da ke cikin shugabanci "CurrentVersion". Don yin wannan, danna kan kowane babban fayil tare da maɓallin linzamin linzamin dama, kuma zaɓi abu a cikin mahallin menu "Share".
- Bayan an gama sharewa, sake fara kwamfutar kuma duba aikin Excel.
Hanyar 4: Gyara matakan gaggawa
Matsalar wucin gadi ga matsala na iya zama kashe fasalin kayan aiki a Excel.
- Gudura zuwa ɓangaren da ya saba da mu ta hanyar hanyar farko ta magance matsalar. "Zabuka" a cikin shafin "Fayil". Sake danna abu "Advanced".
- A cikin buƙatar da aka buɗe madaidaicin Excel, nemi saitin saitunan "Allon". Saita alamar kusa da saiti "Kashe kayan aikin injiniyar hawan gaggawa". Danna maballin "Ok".
Hanyar 5: musaki ƙara-kan
Kamar yadda aka ambata a sama, ɗaya daga cikin mawuyacin wannan matsala na iya zama rashin aiki na wasu nau'i-nau'i. Sabili da haka, a matsayin ma'auni na wucin gadi, zaku iya amfani da shigar da add-ins Excel.
- Bugu da kari, je shafin "Fayil"zuwa sashi "Zabuka"amma wannan lokaci danna abu Ƙara-kan.
- A ƙasa sosai na taga a cikin jerin saukewa "Gudanarwa"zaɓi abu COM Add-ins. Muna danna maɓallin "Ku tafi".
- Cire duk add-ons da aka jera. Muna danna maɓallin "Ok".
- Idan bayan wannan, matsalar ta ɓace, to zamu sake komawa taga na COM-add-ins. Saita alamar, kuma danna maballin "Ok". Duba idan matsalar ta dawo. Idan duk abin da yake a cikin tsari, to, je zuwa gaba-da-nan na gaba, da dai sauransu. Ƙarin ƙara inda aka dawo da kuskure ya ƙare, kuma ba a kunna ba. Duk sauran add-ons za a iya kunna.
Idan, bayan rufe dukkan add-on, matsalar ta kasance, wannan yana nufin cewa za a iya kunna add-on, kuma kuskure ya kamata a gyara ta wata hanya.
Hanyar 6: Sake Saitin Fayil na Fayil
Hakanan zaka iya kokarin sake saita ƙungiyoyin ƙungiyoyi don warware matsalar.
- Ta hanyar maɓallin "Fara" je zuwa "Hanyar sarrafawa".
- A cikin Sarrafa Manajan, zaɓi sashe "Shirye-shirye".
- A cikin taga wanda ya buɗe, je zuwa kasan "Shirye-shiryen Saɓo".
- A cikin taga saitin shirin, ta hanyar tsoho, zaɓi abu "Kwatanta nau'in fayiloli da ladabi na shirye-shirye na musamman".
- A cikin jerin fayiloli, zaɓi tsawo xlsx. Muna danna maɓallin "Canja shirin".
- A cikin jerin shirye-shiryen da aka shirya da ya buɗe, zaɓi Microsoft Excel. Danna maballin. "Ok".
- Idan Excel ba a cikin jerin shirye-shiryen da aka shirya ba, danna maballin "Review ...". Ku tafi cikin hanyar da muka yi magana game da ku, ku tattauna yadda za'a magance matsalar ta hanyar karkatar da jituwa, sannan ku zaɓi fayil ɗin excel.exe.
- Muna yin irin waɗannan ayyuka don tsawo xls.
Hanyar 7: Sauke sabuntawar Windows kuma sake shigar da Microsoft Office
A ƙarshe amma ba kadan ba, rashin samun ƙarin ɗaukakawar Windows mai muhimmanci zai iya zama dalilin wannan kuskure a Excel. Dole ne a bincika duk an sauke samfurorin da aka samo kuma, idan ya cancanta, sauke wadanda aka ɓace.
- Sake buɗe maɓallin kulawa. Je zuwa sashen "Tsaro da Tsaro".
- Danna abu "Windows Update".
- Idan akwai saƙo a bude taga game da samun samfurori, danna maballin "Shigar Ɗaukaka".
- Muna jiran samfurorin da za a shigar, kuma sake farawa kwamfutar.
Idan babu wani daga cikin waɗannan hanyoyin da ya taimaka wajen magance matsalar, to, yana iya zama daidai ya yi tunani game da sake shigar da software na Microsoft Office, ko ma sake sake aiwatar da tsarin Windows ɗin gaba ɗaya.
Kamar yadda kake gani, akwai wasu zaɓuɓɓukan zaɓuɓɓuka don kawar da kurakurai lokacin aika umarni a Excel. Amma, a matsayin mai mulkin, a cikin kowane akwati daya akwai kawai daidai bayani. Saboda haka, don kawar da wannan matsala, wajibi ne a yi amfani da hanyar gwaji don amfani da hanyoyi daban-daban don kawar da kuskure har sai dai an sami zaɓi daidai.
