Kuskuren aika umarni zuwa aikace-aikace a Microsoft Excel: mafita ga matsalar

Duk da cewa, gabaɗaya, Microsoft Excel yana da babban matakin kwanciyar hankali, wannan aikace-aikacen ma wasu lokuta yana da matsaloli. Ofayan waɗannan matsalolin shine bayyanar saƙon "Kuskuren aika umarni zuwa aikace-aikacen." Yana faruwa lokacin da kake ƙoƙarin adanawa ko buɗe fayil, kazalika da aiwatar da wasu ayyuka tare da shi. Bari mu ga abin da ya haifar da wannan matsalar, da kuma yadda za a gyara shi.

Sanadin kuskure

Menene ainihin dalilan wannan kuskuren? Za'a iya bambanta masu zuwa:

• Damara lalata
• Yunkuri don samun damar bayanai na aikace-aikacen aiki;
• Kurakurai a cikin rajista;
• Cin hanci da rashawa shirin.

Matsalar warware matsala

Hanyoyi don warware wannan kuskuren sun dogara da sanadin sa. Amma, tunda a mafi yawan lokuta, yafi wuya a iya kafa dalili maimakon a kawar da shi, to mafita mai ma'ana shine a nemi hanyar da ta dace ta aiwatar daga zabin da aka gabatar a kasa, ta amfani da hanyar gwaji.

Hanyar 1: Musaki DDE Ignore

Sau da yawa fiye da ba, yana yiwuwa a kawar da kuskuren yayin aika umarni ta hanyar watsi da watsi da DDE.

1. Je zuwa shafin Fayiloli.



2. Danna kan kayan "Zaɓuɓɓuka".



3. A cikin taga yana buɗe, je zuwa sashin layi "Ci gaba".



4. Muna neman shinge na saiti "Janar". Cire zaɓi "Yi watsi da buƙatun DDE daga wasu aikace-aikacen". Latsa maballin "Ok".

Bayan haka, a cikin adadin lokuta da yawa, ana warware matsalar.

Hanyar 2: kashe yanayin karfin karfinsu

Wataƙila sanadin matsalar da aka bayyana a sama na iya zama yanayin daidaita karfin kunna. Domin kashe shi, dole ne saika bi matakan da ke ƙasa.

1. Mun je, ta amfani da Windows Explorer, ko kowane mai sarrafa fayil, zuwa ga shugabanci inda kunshin software na Microsoft Office yake a kwamfutar. Hanya zuwa gare ta ita ce:C: Fayilolin Shirya Microsoft Office OFFICE№. A'a. Shine lambar dakin taro. Misali, jakar inda aka adana shirye-shiryen Microsoft Office 2007 za'a kira OFFICE12, Microsoft Office 2010 - OFFICE14, Microsoft Office 2013 - OFFICE15, da sauransu.



2. A cikin babban fayil ɗin, nemi fayil ɗin Excel.exe. Mun danna shi tare da maɓallin linzamin kwamfuta na dama, kuma a cikin mahallin mahallin da ya bayyana, zaɓi abu "Bayanai".



3. A cikin taga Properties da aka bude, je zuwa shafin "Amincewa".



4. Idan akwai akwati na gaba da abu "Run shirin a yanayin karfinsu", ko "Gudun wannan shirin a matsayin shugaba"sannan cire su. Latsa maballin "Ok".

Idan ba a bincika akwatunan akwatun cikin sakin layi daya ba, to zamu ci gaba da neman asalin matsalar a wani wuri.

Hanyar 3: tsaftace wurin yin rajista

Ofayan dalilan da zasu iya haifar da kuskure yayin aika umarni zuwa aikace-aikace a cikin Excel matsala ce ta rajista. Saboda haka, muna buƙatar tsaftace shi. Kafin ci gaba da matakai na gaba don ɗaukar kanka kan yiwuwar abin da ba a so na wannan hanyar, muna bayar da shawarar sosai a samar da tsarin mayar da batun.

1. Domin kiran taga Run, a kan mukan shiga mabuɗin maɓallin Win + R. A cikin taga da ke buɗe, shigar da umarnin "RegEdit" ba tare da ambato ba. Latsa maɓallin "Ok".



2. Edita yana yin rajista. Itace bishiyar tana gefen hagu na editan. Mun matsa zuwa kundin "Yawarakumar" ta hanyar:HKEY_CURRENT_USER Software Microsoft Windows CurrentVersion.



3. Share duk manyan fayilolin dake cikin littafin "Yawarakumar". Don yin wannan, danna-dama akan kowane babban fayil, kuma zaɓi abu a cikin mahallin mahallin Share.



4. Bayan an cire cirewar, sake kunna kwamfutar ka bincika shirin mai kyau.

Hanyar 4: musaki hanzarin kayan aiki

Matsayi na wucin gadi na iya zama don hana haɓaka kayan aiki a cikin Excel.

1. Je zuwa sashin da muka saba da mu a farkon hanyar warware matsalar. "Zaɓuɓɓuka" a cikin shafin Fayiloli. Danna kan kayan kuma "Ci gaba".
2. A cikin taga wanda ke buɗe ƙarin zaɓuɓɓukan Excel, bincika toshe saitunan Allon allo. Duba akwatin kusa da sigogi "A kashe kayan aikin da aka fadada na kayan aikin". Latsa maballin "Ok".

Hanyar 5: musaki add-kan

Kamar yadda aka ambata a sama, ɗayan abubuwan da ke haifar da wannan matsala na iya zama mummunan aikin wasu ƙari. Saboda haka, azaman wucin gadi ne, zaku iya amfani da kashe ƙwararrun masu ƙara tayo.

1. Mun sake tafiya, kasancewa cikin shafin Fayilolito sashe "Zaɓuɓɓuka"amma wannan karon danna abun "Karin abubuwa".



2. A ƙasan taga, a cikin jerin abubuwan da aka sauke "Gudanarwa", zaɓi abu "COM Add-ins". Latsa maballin Je zuwa.



3. Cire duk kayan kara da aka jera. Latsa maballin "Ok".



4. Idan daga baya, matsalar ta ɓace, sannan kuma za mu sake komawa zuwa taga ƙara-da ke cikin COM. Duba akwatin kuma danna maɓallin. "Ok". Duba idan matsalar ta dawo. Idan komai ya kasance cikin tsari, to sai a je zuwa add-on na gaba, da sauransu. Mun kashe kari akan wanda kuskuren ya koma, kuma kar ya kunna shi kuma. Duk sauran kara za'a iya kunna su.

Idan, bayan an kashe duk waɗannan ƙari, matsalar ta ci gaba, to wannan yana nufin cewa ana iya ƙara ƙarawa, kuma ya kamata a gyara kuskuren ta wata hanyar.

Hanyar 6: sake saita ƙungiyoyi fayil

Don magance matsalar, zaku iya ƙoƙarin sake saita ƙungiyoyin fayil ɗin.

1. Ta hanyar maɓallin Fara je zuwa "Kwamitin Kulawa".



2. A cikin Kwamitin Gudanarwa, zaɓi sashin "Shirye-shirye".



3. A cikin taga yana buɗe, je zuwa sashin layi "Shirye-shiryen tsoho".



4. A cikin tsoho saitin tsarin taga, zaɓi "Kwatanta nau'in fayil da ladabi na takamaiman shirye-shirye".



5. A cikin jerin fayiloli, zaɓi tsawo na xlsx. Latsa maballin "Canza shirin".



6. A cikin jerin shirye shiryen da aka bada shawarar budewa, zabi Microsoft Excel. Latsa maballin "Ok".



7. Idan Excel baya cikin jerin shirye-shiryen da aka bada shawara, danna maballin "Yi bita ...". Muna bin hanyar da muka tattauna game da ita, tattauna hanyar da za a magance matsalar ta hanyar rage karfin aiki, kuma zaɓi fayil ɗin kyau.exe.



8. Muna yin daidai don fa'idodin xls.

Hanyar 7: Zazzage sabunta Windows da Saka Microsoft Office Suite

A ƙarshe amma ba mafi ƙaranci ba, abin da ya faru na wannan kuskuren a cikin Excel na iya zama saboda rashi sabuntawar sabuntawar Windows. Kuna buƙatar bincika ko an saukar da duk sabbin abubuwan da ke ciki, kuma idan ya cancanta, zazzage waɗanda suka ɓace.

1. Sake kuma, buɗe Ikon Sarrafawa. Je zuwa sashin "Tsari da Tsaro".



2. Danna kan kayan Sabuntawar Windows.



3. Idan a cikin taga yana buɗewa akwai saƙo game da kasancewar sabuntawa, danna maballin Sanya Sabis.



4. Muna jira har sai an sanya sabuntawar kuma muna sake kunna kwamfutar.

Idan babu ɗayan waɗannan hanyoyin da ke sama da suka taimaka wajen magance matsalar, to yana iya yin ma'ana don sake tunani game da girka kayan aikin Microsoft Office, ko ma sake amfani da tsarin aikin Windows gaba ɗaya.

Kamar yadda kake gani, akwai yan 'yan zabi dayawa na gyara kuskuren yayin aika umarni a cikin Excel. Amma, a matsayinka na doka, a kowane yanayi akwai yanke hukunci daya tilo. Don haka, don kawar da wannan matsala, ya zama dole a yi amfani da hanyoyi daban-daban na kawar da kuskuren ta amfani da hanyar gwaji har sai an samo zaɓi kawai.