Hada hotuna biyu a cikin Microsoft Word

Kuskuren kokarin ƙoƙarin bude takarda na Excel ba sau da yawa, amma, duk da haka, suna faruwa. Irin waɗannan matsalolin za a iya haifar da lalacewar daftarin aiki, da kuma malfunctions na wannan shirin ko ma da tsarin Windows duka. Bari mu bincika ainihin dalilai na matsaloli tare da bude fayiloli, kuma gano yadda za'a gyara yanayin.

Ayyuka da Nemo

Kamar yadda a kowane lokacin matsala, neman hanyar da za a iya fitowa daga cikin halin da matsalolin yayin bude littafin Excel, ya kasance a cikin abin da ya faru nan take. Saboda haka, da farko, yana da muhimmanci don kafa abubuwan da suka haddasa rashin aiki na aikace-aikacen.

Don gane tushen dalilin: a cikin fayil kanta ko a cikin matsalolin software, gwada buɗe wasu takardu a cikin wannan aikace-aikacen. Idan sun bude, ana iya tabbatar da cewa tushen tushen matsalar shine lalata littafin. Idan mai amfani ya kasa bude ko da to, to wannan matsala yana cikin matsaloli tare da Excel ko tsarin aiki. Kuna iya yin shi daban: kokarin buɗe littafin buƙata akan wani na'ura. A wannan yanayin, binciken da ya samu nasara zai nuna cewa duk abin da yake tare da takardun, kuma matsalolin ya kamata a bincika a wata hanya dabam.

Dalili na 1: Matsalar Hadadda

Babban dalilin rashin nasara a yayin bude wani littafi na Excel, idan ba ya kwanta cikin lalacewar takardun da kansa ba, shi ne batun daidaitawa. Ba'a haifar da gazawar software ba, amma ta amfani da tsohuwar ɗaba'ar shirin don buɗe fayilolin da aka yi a cikin sabon salo. A lokaci guda, ya kamata a lura da cewa ba duk takardun da aka yi a sabon salo ba zai sami matsaloli a buɗe a aikace-aikace na baya. Maimakon haka, mafi yawansu za su fara kullum. Abubuwan da aka ƙayyade kawai sune waɗanda aka gabatar da fasahar cewa tsofaffin sassan Excel ba zasu iya aiki tare da su ba. Alal misali, lokutan farko na wannan na'ura mai sarrafawa ba zai iya aiki tare da nassoshi ba. Saboda haka, tsohon aikace-aikacen ba zai iya buɗe littafin da ke dauke da wannan kashi ba, amma zai kaddamar da mafi yawan sauran takardun da aka kirkiro a cikin sabon fasalin.

A wannan yanayin, za'a iya samun maganin biyu kawai ga matsalar: ko dai bude takardun irin wannan a kan wasu kwakwalwa tare da software wanda aka sabunta, ko shigar da ɗaya daga sababbin sassan Microsoft Office a kan PC mai rikitarwa ba tare da dadewa ba.

Babu matsala ta gaba yayin bude takardun da aka tsara a tsoffin fasalin aikace-aikacen a sabon shirin. Sabili da haka, idan kana da sabon shigarwar Excel, to, babu matsala masu rikitarwa da suka danganci dacewa yayin bude fayiloli na shirye-shirye na baya.

Ya bambanta, ya kamata a ce game da tsarin xlsx. Gaskiyar ita ce an aiwatar da shi ne kawai daga Excel 2007. Duk aikace-aikace na baya bazai iya aiki tare da shi ta hanyar tsoho ba, domin a gare su "fasalin" shi ne xls. Amma a wannan yanayin, matsalar za a iya warware matsalar tare da kaddamar da wannan takarda ba tare da sabunta aikace-aikacen ba. Za a iya yin wannan ta hanyar shigar da takalmin musamman daga Microsoft a kan tsohon tsarin wannan shirin. Bayan wannan, littattafai da xlsx tsawo zasu buɗe a kullum.

Shigar patch

Dalili na 2: kuskuren saitunan

Wasu lokuta mawuyacin matsalolin yayin bude wani takardun aiki zai iya zama daidaitattun tsari na daidaitawar shirin kanta. Alal misali, lokacin da kake ƙoƙarin buɗe duk wani littafi na Excel ta danna sau biyu maɓallin linzamin hagu, saƙo mai biyowa zai iya bayyana: "Kuskure yayin aika umarni zuwa aikace-aikace".

Wannan zai kaddamar da aikace-aikacen, amma littafin da aka zaɓa ba zai bude ba. A lokaci guda ta cikin shafin "Fayil" a cikin shirin kanta, takardun ya buɗe kullum.

A mafi yawancin lokuta, wannan matsalar za a iya warware ta hanyar da ta biyo baya.

  1. Jeka shafin "Fayil". Kusa, koma zuwa sashe "Zabuka".
  2. Bayan da aka kunna ginin sigogi, a gefen hagu je zuwa kasan "Advanced". A gefen dama na taga muna neman ƙungiyar saituna. "Janar". Dole ne ya ƙunsar saiti "Nuna tambayoyin DDE daga wasu aikace-aikacen". Ya kamata a ɓoye idan an duba shi. Bayan haka, don adana sanyi na yanzu, danna maballin "Ok" a kasan taga mai aiki.

Bayan yin wannan aiki, ƙoƙari na dannawa sau biyu don buɗe rubutun ya kamata kammala nasara.

Dalili na 3: Sanya Mappings

Dalilin da ba za ku iya yin shi a hanya mai kyau ba, wato, ta danna sau biyu maɓallin linzamin kwamfuta na hagu, bude wani takardar Excel, ƙila za a iya haifar da ƙungiyoyin fayiloli mara daidai. Alamar wannan shine, misali, ƙoƙari na kaddamar da wani takardu a wani aikace-aikacen. Amma wannan matsala za a iya sauƙin warwarewa.

  1. Ta hanyar menu Fara je zuwa Control panel.
  2. Kusa, koma zuwa sashe "Shirye-shirye".
  3. A cikin saitunan aikace-aikacen aikace-aikacen da ya buɗe, tafi ta wurin abu "Manufar shirin don bude fayilolin irin wannan".
  4. Bayan haka, za a gina jerin sunayen nau'o'i daban-daban waɗanda aka buɗe da aikace-aikacen da suka bude su. Muna neman ne a cikin jerin kariyar jerin Excel xls, xlsx, xlsb ko wasu waɗanda ya kamata su bude cikin wannan shirin, amma ba a bude ba. Lokacin da ka zaba kowane ɗayan waɗannan kari a saman teburin ya zama rubutun Microsoft Excel. Wannan yana nufin cewa tsarin wasan yana daidai.

    Amma, idan an ƙayyade wani aikace-aikacen yayin da zaɓin fayil ɗin Excel ta al'ada, wannan yana nuna cewa an tsara tsarin da ba daidai ba. Don saita saitunan latsa maballin "Canja shirin" a saman gefen dama na taga.

  5. Yawancin lokaci a taga "Zaɓin Shirin Shirin" Sunan Excel ya kamata a cikin ƙungiyar software mai bada shawarar. A wannan yanayin, kawai zaɓi sunan aikace-aikacen kuma danna maballin "Ok".

    Amma, idan saboda wasu yanayi ba a cikin jerin ba, to, a wannan yanayin danna maballin "Review ...".

  6. Bayan haka, taga mai binciken zai buɗe inda dole ne ka sanya hanya zuwa babban fayil na Excel ɗin kai tsaye. An samo a cikin babban fayil a adireshin da ke biye:

    C: Fayilolin Shirin Fayil na Microsoft Office Office

    Maimakon alamar "A'a" kana buƙatar saka adadin lambar Microsoft naka. Lissafi na fasali na Excel da Lambobin adireshi kamar haka:

    • Excel 2007 - 12;
    • Excel 2010 - 14;
    • Excel 2013 - 15;
    • Excel 2016 - 16.

    Da zarar ka koma zuwa babban fayil ɗin da ya dace, zaɓi fayil EXCEL.EXE (idan ba a nuna kari ba, za a kira shi kawai ƘARI). Latsa maɓallin "Bude".

  7. Bayan haka, za ku koma cikin jerin zaɓin shirin, inda dole ne ku zaɓi sunan "Microsoft Excel" kuma danna maballin "Ok".
  8. Sa'an nan kuma za a sake shigar da aikace-aikacen don bude nau'in fayil ɗin da aka zaba. Idan dama kariyar Excel ba su da dalili, dole ne ka yi hanyar da ke sama don kowane ɗayan su daban. Bayan da babu wasu mawings ba daidai ba don gama aiki tare da wannan taga, danna kan maballin "Kusa".

Bayan haka, takardun aiki na Excel ya kamata ya buɗe daidai.

Dalili na 4: Ƙari-ƙari ba sa aiki daidai.

Ɗaya daga cikin dalilan da ya sa littafin na Excel bai fara ba zai iya zama aiki mara kyau na add-ins, wanda yake rikici da juna ko tare da tsarin. A wannan yanayin, hanyar ƙetare shine don ƙuntata ƙarancin kuskure.

  1. Kamar yadda a hanya ta biyu don warware matsalar ta hanyar shafin "Fayil", je zuwa matakan sigogi. A can muna matsawa zuwa sashe Ƙara-kan. A kasan taga shine filin "Gudanarwa". Danna kan shi kuma zaɓi saitin COM Add-ins. Muna danna maɓallin "Ku tafi ...".
  2. A cikin bude taga na jerin add-ons muna cire akwati daga duk abubuwan. Muna danna maɓallin "Ok". Saboda haka dukkan add-ons kamar Com za a kashe.
  3. Muna kokarin buɗe fayil ɗin ta hanyar danna sau biyu. Idan ba ta bude ba, to amma ba game da add-ins ba, zaka iya mayar da su duka, amma nemi dalilin a wani. Idan daftarin aiki ya buɗe a al'ada, to wannan yana nufin cewa ɗaya daga cikin add-ons ba ya aiki daidai. Don bincika wanene, koma zuwa dakin add-ons, duba daya daga cikinsu kuma danna maballin "Ok".
  4. Duba yadda aka buɗe takardun. Idan duk abin da ke da kyau, to, sai ka danna taɗaɗɗa na biyu, da dai sauransu, har sai mun sami wanda tare da hada wanda akwai matsaloli tare da budewa. A wannan yanayin, yana buƙatar kashewa kuma ba a juya, ko mafi kyau har yanzu, ta hanyar zaɓar kuma danna maɓallin dace. Duk sauran add-ons, idan babu matsaloli a aikin su, za'a iya kunna.

Dalili na 5: matakan gaggawa

Matsaloli tare da buɗe fayiloli a Excel na iya faruwa lokacin da aka kunna matakan gaggawa. Kodayake wannan lamari ba lallai ba ne haɓaka don buɗe takardu. Saboda haka, da farko, kana buƙatar bincika ko dalilin ne ko a'a.

  1. Je zuwa sakin layi na Excel da aka sani a sashen "Advanced". A gefen dama na taga muna neman saitin saituna. "Allon". Yana da saiti "Kashe kayan aikin injiniyar hawan gaggawa". Sanya akwati a gaba da shi kuma danna maballin. "Ok".
  2. Duba yadda aka bude fayiloli. Idan sun buɗe a al'ada, to baza canza saitunan ba. Idan matsalar ta ci gaba, zaka iya kunna matakan gaggawa kuma ci gaba da neman dalilin matsalar.

Dalili na 6: lalata littafin

Kamar yadda aka ambata a baya, daftarin aiki bazai bude ba saboda an lalace. Wannan na iya nuna cewa wasu littattafai a misalin wannan shirin suna gudana kullum. Idan ba za ka iya bude wannan fayil a wani na'ura ba, to, tare da amincewa za mu iya cewa dalilin shi ne a kansa. A wannan yanayin, zaka iya kokarin dawo da bayanan.

  1. Kaddamar da na'ura mai kwakwalwa ta Excel ta hanyar hanyar gado ko menu Fara. Jeka shafin "Fayil" kuma danna maballin "Bude".
  2. An kunna taga fayil ɗin budewa. A ciki akwai buƙatar ka je shugabanci inda matsala ta ƙunshi. Zaɓi shi. Sa'an nan kuma danna gunkin a cikin nau'i mai maƙalli wanda ya juya baya kusa da maɓallin "Bude". Jerin yana bayyana inda ya kamata ka zaɓa "Bude kuma mayar ...".
  3. An kaddamar da taga wanda ke samar da ayyuka da yawa don zaɓar daga. Na farko, bari mu gwada sauƙin dawo da bayanai. Saboda haka, danna maballin "Gyara".
  4. Tsarin sakewa yana gudana. Idan aka samu nasarar kammalawa, taga ya bayyana, ya sanar da shi. Ya kamata kawai danna maballin "Kusa". Bayan haka, ajiye bayanan da aka dawo dasu a hanyar da aka saba - ta latsa maɓallin a cikin nau'i na fadi a cikin kusurwar hagu na taga.
  5. Idan littafin bai ba da izinin dawowa ta wannan hanya ba, to, sai mu koma baya sannan mu danna maɓallin. "Cire bayanai".
  6. Bayan wannan, wani taga yana buɗewa inda za a sa ka ko dai ka sake fasalin dabarar zuwa dabi'u ko mayar da su. A cikin akwati na farko, dukkanin matakan da ke cikin takardun za su shuɗe, kuma kawai sakamakon binciken zai kasance. A cikin akwati na biyu, za a yi ƙoƙari don adana maganganun, amma babu nasara. Muna yin zabi, bayan haka, dole a dawo da bayanan.
  7. Bayan wannan, ajiye su a matsayin fayil ɗin raba ta danna maballin a cikin nau'i na fadi.

Akwai wasu zaɓuɓɓukan don dawo da bayanan daga lalata littattafai. Ana tattauna su a cikin wani batu.

Darasi: Yadda za'a gyara fayiloli Excel mara kyau

Dalili na 7: Excel cin hanci da rashawa

Wani dalili da ya sa shirin ba zai iya bude fayiloli iya zama lalacewa ba. A wannan yanayin, kana buƙatar gwadawa. Hanyar sake dawowa ta dace kawai idan kuna da haɗin Intanet.

  1. Je zuwa Control panel ta hanyar maɓallin Farakamar yadda aka bayyana a baya. A cikin taga wanda yake buɗewa danna abu "A cire shirin".
  2. Gila yana buɗe tare da jerin duk aikace-aikacen da aka sanya akan kwamfutar. Muna neman abu a ciki "Microsoft Excel"zaɓi wannan shigarwa kuma danna maballin. "Canji"located a saman panel.
  3. Gila don canza saitin shigarwa yanzu yana buɗewa. Sanya sauyawa a matsayi "Gyara" kuma danna maballin "Ci gaba".
  4. Bayan haka, ta hanyar haɗawa da Intanit, za a sabunta aikace-aikacen, kuma za a kawar da kuskuren.

Idan ba ku da haɗin Intanet ko don wani dalili kuma ba za ku iya amfani da wannan hanyar ba, to, a wannan yanayin dole ku dawo ta amfani da kwakwalwa.

Dalili na 8: matsaloli na tsarin

Dalilin rashin yiwuwar bude fayil ɗin Excel zai iya zama wani lokacin damuwa cikin tsarin aiki. A wannan yanayin, kana buƙatar yin jerin ayyuka don mayar da lafiyar tsarin tsarin Windows a matsayin cikakke.

  1. Da farko, duba kwamfutarka tare da mai amfani da cutar anti-virus. Yana da kyawawa don yin wannan tare da wani na'ura wanda ba'a tabbatar da cewa zai kamu da cutar ba. Idan akwai wani abu marar ganewa ka bi shawarwari na riga-kafi.
  2. Idan bincike da cirewa daga ƙwayoyin cuta ba su warware matsalar ba, to gwada sake juyar da tsarin zuwa yanayin dawowa na ƙarshe. Gaskiya ne, don amfani da wannan damar, kana buƙatar ƙirƙirar shi kafin kowace matsala ta faru.
  3. Idan waɗannan da sauran mafita ga matsalar ba su ba da kyakkyawan sakamako ba, to, za ka iya gwada hanya na sake shigar da tsarin aiki.

Darasi: Yadda za a ƙirƙirar maɓallin mayar da Windows

Kamar yadda kake gani, matsalar da bude littattafan Excel na iya haifar da dalilai daban-daban. Za a iya ɓoye su cikin fayil cin hanci da rashawa, da kuma a cikin saituna mara kyau ko a cikin matsaloli na shirin kanta. A wasu lokuta, dalilin yana iya zama matsalar matsalar tsarin aiki. Saboda haka, mayar da cikakken aikin yana da mahimmanci don ƙayyade tushen hanyar.