Bace mashaya dabara a Excel - abin da za a yi. 3 mafita ga matsalar idan dabara bar bace

Ɗaya daga cikin mahimman wurare masu mahimmanci a cikin aikace-aikacen Excel shine mashaya dabara. Manufarsa ta dogara ne akan yin lissafi da gyara abubuwan da ke cikin sel. Bambance-bambancen mashaya dabara shine ta hanyar nuna tantanin halitta tare da ƙimar ƙarshe, za a haɗa nunin ayyukan da aka yi a cikin lissafin. Abin takaici, wani lokacin yanayi yana tasowa lokacin da wannan maɓallin ke ɓacewa daga kwamitin Excel. Za mu bincika yanayi da yawa da za su iya haifar da irin waɗannan matsalolin, da kuma yadda ake magance su ta hanyoyi mafi sauƙi.

Mashin dabara ya ɓace: menene dalili

Akwai dalilai guda biyu kawai da ya sa wannan nau'in haɗin gwiwar ke iya ɓacewa daga mashaya - wannan canji ne a saitunan Excel da gazawar software. Amma an raba su zuwa ƙarin cikakkun bayanai.

Dalili #1: Canja saitunan ciyarwa

Irin wannan matsala na iya faruwa bayan mai amfani da gangan ya buɗe wani abu da ke da alhakin gudanar da mashin ɗin dabara. Bari mu ga yadda za a magance matsalar:

1. A saman kayan aikin akwai maɓallin Dubawa.
2. Ta hanyar jujjuya siginan kwamfuta da danna maɓallin hagu, za mu je shafin da ya dace.
3. Bayan gano layin dabara, duba idan akwai kaska a gabansa. Shigar idan ya cancanta.
4. Sakamakon ayyukan da aka yi, layin zai sake bayyana a cikin tsarin shirin.

Hankali! Ba kwa buƙatar sake kunna shirin ko kwamfutar don gyara saitunan.

 Dalili #2: An Canja Saitunan Zaɓuɓɓukan Excel

Mashigin dabara na iya ɓacewa bayan bazata ko kashe ta da karfi a cikin zaɓuɓɓukan shirin. Don magance matsalar, ana amfani da hanyoyi guda biyu: na farko an bayyana shi a baya, kuma don gyara matsalar ta hanya ta biyu, kuna buƙatar sake maimaita duk matakan a jere kamar lokacin kashe wannan aikin. Wanne ya fi sauƙi kuma mafi fahimta shine mai amfani da PC ya yanke shawara. Magani ta hanya ta biyu:

1. A kan kayan aiki, nemo "File" kuma ci gaba.
2. A cikin shafin da ya buɗe, kuna buƙatar nemo "Settings". A matsayinka na mai mulki, abin dubawa yana samuwa a ƙasan shirin.

3. Na gaba, a cikin taga da ke buɗewa, je zuwa layin "Advanced", bayan danna abin da "Ƙarin zaɓuɓɓuka don aiki tare da Excel" zai bayyana a gefen hagu.
4. Ta hanyar jujjuya dabarar linzamin kwamfuta, muna ɗaga shafin sama, inda muka sami rukunin saituna "Screen".
5. A ƙasa kaɗan zaka iya samun "Show formula bar".
6. Akasin haka, duba akwatin.

Muhimmin! Ba kamar hanyar magance matsalar da ta gabata ba, wannan yana buƙatar tabbatar da canjin saitunan. Saboda haka, domin canje-canje su yi tasiri, a kasan ƙarin saitunan sigogi, kuna buƙatar danna maɓallin "Ok", wanda ke nufin kammala ayyukan.

Dalili #3: Rushewar shirin ko rashawa

Magance matsalar, idan an yi kurakurai a cikin saitunan, ana gyara su cikin sauƙi, amma abin da za a yi idan shirin ya rushe, ko kuma ya gaza gaba ɗaya. A wannan yanayin, kuna buƙatar ƙoƙarin dawo da Excel. Mai zuwa misali ne na maido da shirin ta amfani da Windows 10 a matsayin misali. Kodayake saitunan da ke cikin sigogin Windows na farko kusan iri ɗaya ne:

1. A cikin ƙananan kusurwar hagu, danna maɓallin "Fara".
2. A cikin mashaya bincike mun rubuta "Control Panel".
3. Bayan an gano ta tsarin, buɗe aikace-aikacen ta danna maɓallin linzamin kwamfuta na hagu.
4. A cikin aikace-aikacen da ke buɗewa, kuna buƙatar saita bayyanar gumakan zuwa ƙanana kuma je zuwa "Shirye-shiryen da Features".
5. Tagan Uninstall/Change Programs zai buɗe. Anan zamu sami aikace-aikacen da muke buƙata (a cikin wannan yanayin, Microsoft Excel ko Office) kuma danna-dama akansa. A cikin akwatin maganganu da ya bayyana, kuna buƙatar kunna maɓallin "Change". Hakanan, ana iya aiwatar da aikin ta danna sunan shirin tare da maɓallin hagu kuma danna cikin taken jerin abubuwan da aka bayyana na dubawa "Change".

6. Da zarar an tabbatar da farkon canjin, sabon taga don maido da shirin zai buɗe. Anan kuna buƙatar zaɓar ɗayan hanyoyin. A matsayinka na mai mulki, "Quick farfadowa da na'ura" ya isa, wanda baya buƙatar haɗin Intanet. Saboda haka, mun dakatar da zabi a kan wannan abu kuma danna maɓallin "Maida" button.

Tagan “Uninstall and Change a Program” yana ƙunshe da fakitin Microsoft Office gama gari, bayan fara canje-canje, za a sake sake dawo da duk shirye-shiryen da aka haɗa a cikin wannan samfurin daga Microsoft. Jira tsari don kammala kuma tabbatar da cewa ma'aunin dabara ya bayyana a wurinsa. Idan hakan bai faru ba, koma ga hanya ta biyu.

Shawara! Hanya na biyu "Mayar da hanyar sadarwa" an zaɓi kawai idan babu abin da ya canza bayan hanyar farko. Yana buƙatar ƙarin lokaci da ingantaccen haɗin intanet.

Kammalawa

Lokacin gano matsala tare da asarar dabarar mashaya, ba kwa buƙatar yanke ƙauna da firgita. Da fatan za a fara karanta wannan labarin. Wataƙila dalilin shine canjin bazata a cikin saitunan shirin, wanda aka gyara a cikin minti kaɗan. A cikin mafi munin yanayi, lokacin da shirin ya rushe, kuna buƙatar dawo da Microsoft Office, wanda kuma ana yin shi cikin sauƙi idan kun bi duk umarnin.