Matsalar buɗe fayilolin Excel

Kasawa a kokarin buɗe littafin aikin Excel ba sau da yawa ba ne, amma, har yanzu, suna faruwa. Irin waɗannan matsalolin ana iya haifar dasu ta hanyar lalacewar daftarin aiki, tare da lalata ayyukan shirin ko da tsarin Windows gaba ɗaya. Bari mu bincika takamaiman abubuwan da ke haifar da matsaloli tare da buɗe fayiloli, da kuma gano yadda za a gyara lamarin.

Dalilai da Magani

Kamar yadda a kowane lokaci mai matsala, bincika hanyar fita daga matsalar matsalar lokacin buɗe littafin Excel yana ɓoye cikin ainihin abin da ya faru. Saboda haka, da farko, ya zama dole a tsayar da ainihin abubuwan da suka haifar da aikace-aikacen rashin aiki.

Don fahimtar tushen dalilin: a cikin fayil ɗin kanta ko a cikin matsalolin software, gwada buɗe wasu takaddun a cikin aikace-aikace iri ɗaya. Idan sun bude, zamu iya yanke hukuncin cewa tushen matsalar shine lalacewar littafin. Idan mai amfani ya kasa buɗewa a nan, to matsalar tana tattare da matsalolin Excel ko tsarin aiki. Kuna iya aikata shi ta wata hanyar: gwada buɗe littafin matsala akan wata na'urar. A wannan yanayin, nasarar da ya samu zai nuna cewa komai yana kan tsari, kuma akwai bukatar a nemi matsalolin a wani wuri.

Dalili 1: Batutuwan jituwa

Babban abin da ya fi haifar da gazawa yayin buɗe littafin aikin allo, idan ba batun lalata daftarin aiki ba ne, batun jituwa ne. Ba lalacewa ta hanyar software, amma ta amfani da tsohon sigar shirin bude fayilolin da aka yi a cikin sabon salo. A lokaci guda, ya kamata a lura cewa ba kowane takaddar da aka yi a cikin sabon sigar ba za ta sami matsala yayin buɗe cikin aikace-aikacen da suka gabata. Akasin haka, mafi yawansu za su fara al'ada. Iyakar abin da kawai ake ba su ne wadanda aka gabatar da fasahohin da tsoffin nau'ikan Excel ba za su iya amfani da su ba. Misali, a farko misalai na wannan kayan aikin tebur ba zasu iya aiki tare da nassoshi madauwari ba Saboda haka, littafin mai ɗauke da wannan kashi ba zai iya buɗe tsohuwar aikace-aikacen ba, amma zai ƙaddamar da yawancin sauran takaddun da aka yi a cikin sabon sigar.

A wannan yanayin, za a iya samun mafita biyu kawai ga matsalar: ko dai buɗe irin waɗannan takardu a kan sauran kwamfutoci tare da sabbin software, ko shigar da ɗayan sabon sigogin Microsoft Office a kan PC mai matsala a maimakon wanda ya gabata.

Matsalar baya lokacin buɗe takaddun bayanai a cikin sabon shirin wanda aka kirkira a cikin tsoffin sigogin aikace-aikacen ba a lura dasu. Don haka, idan kuna da sabon fasalin Excel wanda aka shigar, to ba za a iya samun matsala matsala dangane da daidaituwa lokacin buɗe fayilolin shirye-shiryen da suka gabata ba.

Na dabam, ya kamata a faɗi game da tsarin xlsx. Gaskiyar ita ce, ana aiwatar da ita kawai tun Excel 2007. Duk aikace-aikacen da suka gabata ba zasu iya aiki tare da ita ta asali ba, saboda su xls shine "asalin" tsarin. Amma a wannan yanayin, ana iya magance matsalar fara irin wannan takaddun har ma ba tare da sabunta aikace-aikacen ba. Ana iya yin wannan ta hanyar sanya facin musamman daga Microsoft akan tsohuwar sigar shirin. Bayan haka, litattafai tare da xlsx tsawo zasu bude kullun.

Sanya facin

Dalili na 2: ba daidai ba saiti

Wasu lokuta dalilin matsalolin yayin buɗe takaddun na iya zama ba daidai ba tsarin saitin shirye-shiryen kansa. Misali, lokacin da kake kokarin bude wani littafi na Excel ta danna maballin linzamin kwamfuta na hagu, danna sako na iya bayyana: "Kuskuren aika umarni zuwa aikace-aikace".

A wannan yanayin, aikace-aikacen zai fara, amma littafin da aka zaɓa ba zai buɗe ba. A lokaci guda ta hanyar shafin Fayiloli a cikin shirin kanta, daftarin aiki yana buɗewa koyaushe.

A mafi yawan lokuta, ana iya magance wannan matsala ta hanyar da ke biye.

1. Je zuwa shafin Fayiloli. Bayan haka za mu matsa zuwa sashin "Zaɓuɓɓuka".



2. Bayan an kunna sigogi taga, a sashin hagu zamu tafi zuwa sashin yanki "Ci gaba". A ɓangaren dama na taga muna neman rukuni na saiti "Janar". Ya kamata ya ƙunshi sigogi "Yi watsi da buƙatun DDE daga wasu aikace-aikacen". Cire shi idan an bincika. Bayan haka, don adana tsari na yanzu, danna maɓallin "Ok" a kasan taga aiki.

Bayan kammala wannan aikin, ƙoƙari na biyu don buɗe takaddun tare da dannawa sau biyu ya kamata ya kammala cikin nasara.

Dalili 3: kafa kundin tsari

Dalilin da ba za ku iya buɗe takaddar Excel ba a cikin daidaitaccen hanya, wato, ta danna maɓallin linzamin kwamfuta na hagu sau biyu, na iya zama saboda daidaitattun tsarin ƙungiyoyin fayil. Alamar wannan ita ce, alal misali ƙoƙari don fara aiki a cikin wani aiki. Amma ana iya magance wannan matsalar cikin sauki.

1. Ta hanyar menu Fara je zuwa Gudanarwa.



2. Bayan haka za mu matsa zuwa sashin "Shirye-shirye".



3. A cikin taga saitunan aikace-aikacen da ke buɗe, je zuwa "Dalilin shirin don buɗe fayilolin wannan nau'in".



4. Bayan haka, za a gina jerin nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan nau'ikan tsari, wanda za a nuna ayyukan da ke buɗe su. Muna neman wannan jerin abubuwan haɓaka Excel xls, xlsx, xlsb ko wasu waɗanda ya kamata su buɗe a cikin wannan shirin, amma kar a buɗe. Lokacin da ka zaɓi kowane ɗayan waɗannan kari, rubutun Microsoft Excel ya kamata ya kasance a saman tebur. Wannan yana nufin cewa tsarin daidaitawa yayi daidai.

   

   Amma, idan an kayyade wani aikace-aikacen lokacin da aka nuna fayil ɗin Excel na yau da kullun, to wannan yana nuna cewa an daidaita tsarin ba daidai ba. Don saita saiti danna kan maɓallin "Canza shirin" a cikin ɓangaren dama na taga.



5. Yawancin lokaci a cikin taga "Tsarin shirin" Yakamata sunan ya kamata ya kasance cikin rukunin shirye-shiryen da aka bada shawara. A wannan yanayin, kawai zaɓi sunan aikace-aikacen kuma danna maɓallin "Ok".

   

   Amma, idan saboda wasu yanayi ba cikin jerin ba ne, to a wannan yanayin muna danna maballin "Yi bita ...".



6. Bayan wannan, taga mai bincike yana buɗewa wanda dole ne a ƙayyade hanyar zuwa babban fayil ɗin Excel kai tsaye. Ana samunsa cikin babban fayil a adireshin masu zuwa:

   C: Fayilolin Shirya Microsoft Office Office№

   Madadin alamar "A'a.", Kuna buƙatar bayyana adadin kunshin Microsoft Office ɗinku. The rubutu tsakanin iri na Excel da lambobin ofishin kamar haka:

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

   Bayan kun ƙaura zuwa babban fayil ɗin da ya dace, zaɓi fayil SAURARA.EXE (idan ba a kunna nuni na kari ba, to za a kira shi kawai FASAHA) Latsa maballin "Bude".



7. Bayan haka, kun koma taga zaɓi na shirin, inda dole ne zaɓi sunan "Microsoft Excel" kuma danna maballin "Ok".



8. Sannan za a sake sanya aikace-aikacen don buɗe nau'in fayil ɗin da aka zaɓa. Idan da yawa daga cikin abubuwan haɓaka Excel suna da manufa ba daidai ba, to lallai ne sai kun yi hanyar da ta gabata don kowannensu daban. Bayan babu kwatancen da ba daidai ba, don kammala aikin tare da wannan taga, danna maɓallin Rufe.

Bayan wannan, Littattafan aikin Excel yakamata su buɗe daidai.

Dalili na 4: add-kan basa aiki yadda yakamata

Daya daga cikin dalilan da yasa littafin aikin karatun bai fara ba yana iya zama kuskuren aiwatar da abubuwan kara wanda ke rikita juna ko kuma tare da tsarin. A wannan yanayin, hanyar fita ita ce a kashe ƙara wanda bai dace ba.

1. Kamar yadda a cikin hanyar ta biyu don warware matsalar ta hanyar shafin Fayiloli, je zuwa taga zabin. A nan mun matsa zuwa sashin "Karin abubuwa". A kasan taga akwai filin "Gudanarwa". Danna shi kuma zaɓi sigogi "COM Add-ins". Latsa maballin "Ku tafi ...".



2. A cikin taga taga jerin add-kan, saka wasu abubuwan. Latsa maballin "Ok". Don haka duk addara-nau'ikan nau'in nau'in COM za a kashe.



3. Muna ƙoƙarin buɗe fayil tare da dannawa sau biyu. Idan bai bude ba, to ba batun karin bane, zaku iya kunna su, amma ku nemi dalili a wani. Idan an buɗe takaddar a koyaushe, to wannan yana nufin cewa ɗayan abubuwan ƙari ba sa aiki daidai. Don bincika wanne, koma cikin ƙara-kan taga, saita alamar akan ɗayansu sannan danna maɓallin "Ok".



4. Duba yadda takardun suke buɗe. Idan komai yayi kyau, to sai ka kunna add-in na biyu, da sauransu, har sai mun isa ga wanda ka kunna wanda akwai matsaloli game da budewa. A wannan yanayin, kuna buƙatar kashe shi kuma kar ku kunna shi, ko ma ya fi kyau, share shi ta sa alama da latsa maɓallin daidai. Duk sauran abubuwan da ake karawa, idan babu matsaloli a aikinsu, za a iya kunna su.

Dalili 5: hawan kayan masarufi

Matsalar buɗe fayiloli a cikin Excel na iya faruwa lokacin da aka kunna haɓaka kayan aiki. Kodayake wannan ba lallai bane matsala ce ta buɗe takardu. Sabili da haka, da farko, kuna buƙatar bincika ko shine dalilin ko ba haka ba.

1. Je zuwa taga sananniyar sananniyar zaɓin zaɓi na Excel a cikin ɓangaren "Ci gaba". A ɓangaren dama na taga muna neman katangar saiti Allon allo. Yana da siga "A kashe kayan aikin da aka fadada na kayan aikin". Sanya akwati a gabanta saika danna maballin "Ok".



2. Duba yadda fayilolin suke buɗe. Idan suka bude a kullun, to ba za su sake sauya saitunan ba. Idan matsalar ta ci gaba, zaku iya kunna hanzarin kayan aikin kuma ku ci gaba da neman dalilin matsalolin.

Dalili na 6: lalacewar littafi

Kamar yadda aka ambata a baya, takaddun na iya buɗewa tukuna saboda ya lalace. Wannan na iya nuna ta gaskiyar cewa wasu littatafai a cikin wannan kwafi na shirin suna farawa koyaushe. Idan ba za ku iya buɗe wannan fayil ɗin akan wata naúrar ba, to tare da amincewa zamu iya cewa dalilin yana cikin kanta. A wannan yanayin, zaku iya ƙoƙarin dawo da bayanan.

1. Mun fara aikin shimfida aikin Excel ta hanyar gajeriyar hanya a kan tebur ko ta hanyar menu Fara. Je zuwa shafin Fayiloli kuma danna maballin "Bude".



2. Fayil bude taga yana aiki. A ciki, kuna buƙatar zuwa ga shugabanci inda takaddun matsala yake. Zaba shi. Bayan haka danna maballin alwati mai rikitarwa kusa da maɓallin "Bude". Jerin yana bayyana wanda ya zaɓi "Bude a mayar ...".



3. Wani taga yana buɗewa wanda ke ba da matakai da yawa don zaɓan daga. Da farko, gwada sauƙin dawo da bayanai. Sabili da haka, danna maballin Maido.



4. Hanyar dawo da aiki tana ci gaba. Idan kuwa aka samu nasarar kammalawa, sai taga bayanai sun bayyana game da hakan. Yana buƙatar kawai danna maballin Rufe. Don haka adana bayanan da aka dawo dasu ta hanyar da ta saba - ta danna maɓallin a cikin hanyar diskette a saman kusurwar hagu na taga.



5. Idan ba za a iya dawo da littafin ta wannan hanyar ba, to, mun koma zuwa taga da ta gabata kuma danna maballin "Cire bayanai".



6. Bayan haka, wani taga yana buɗewa, wanda za a miƙa maka ko dai canza dabarun zuwa dabi'u ko dawo da su. A lamari na farko, duk dabarun da ke cikin takaddun sun ɓace, kuma sakamakon lissafin kawai ya rage. A lamari na biyu, za a yi ƙoƙari don adana maganganun, amma babu tabbacin nasara. Mun zabi, bayan wannan, dole ne a dawo da bayanan.



7. Bayan haka, adana su azaman fayil daban ta danna maɓallin a cikin diskette.

Akwai sauran zaɓuɓɓuka don dawo da bayanai daga littattafan da suka lalace. An tattauna su a cikin wani take daban.

Darasi: Yadda za a dawo da fayilolin Excel masu lalacewa

Dalili 7: Ingantaccen rashawa

Wani dalilin da yasa shirin ba zai iya buɗe fayiloli ba shine lalacewarsa. A wannan yanayin, kuna buƙatar yin ƙoƙari don mayar da shi. Hanyar dawowa mai zuwa ya dace kawai idan kuna da haɗin yanar gizo mai dorewa.

1. Je zuwa Gudanarwa ta maballin Farakamar yadda aka bayyana a baya. A cikin taga da ke buɗe, danna kan abin "Cire shirin".



2. Ana buɗe taga tare da jerin duk aikace-aikacen da aka sanya a kwamfutar. Muna neman abu a ciki "Microsoft Excel", zaɓi wannan shigar kuma danna maballin "Canza"dake saman kwamiti.



3. Tagan don canza shigarwa na yanzu ya buɗe. Sanya wurin canzawa a wuri Maido kuma danna maballin Ci gaba.



4. Bayan haka, ta hanyar haɗi zuwa Intanet, aikace-aikacen za a sabunta, kuma za a gyara aiyukan.

Idan baka da hanyar haɗin Intanet ko saboda wasu dalilai ba zaka iya amfani da wannan hanyar ba, to a wannan yanayin zaka iya dawo da amfani da faifin sakawa.

Dalili 8: matsalolin tsarin

Dalilin rashin iya buɗe fayil ɗin Excel na iya wasu lokuta rikice rikice ne a cikin tsarin aiki. A wannan yanayin, kuna buƙatar yin jerin ayyuka don dawo da lafiyar Windows gaba ɗaya.

1. Da farko, bincika kwamfutarka tare da mai amfani da riga-kafi. Yana da kyau a yi wannan daga wata na’urar da aka ba da tabbacin kar ta kamu da ƙwayar cuta. Idan ka sami abubuwan shakku, bi shawarwarin riga-kafi.



2. Idan bincike da cire ƙwayoyin cuta ba su magance matsalar ba, to, yi ƙoƙarin jujjuya tsarin zuwa ƙarshen maida. Gaskiya ne, don amfani da wannan damar, dole ne a ƙirƙira shi kafin wata matsala ta taso.



3. Idan waɗannan da sauran hanyoyin magance matsalar ba su bayar da sakamako mai kyau ba, to za ku iya gwada hanyoyin sake kunna tsarin aiki.

Darasi: Yadda za a ƙirƙiri aya mai amfani da Windows

Kamar yadda kake gani, matsalar buɗe littattafan Excel za a iya haifar da shi ta dalilai daban-daban. Ana iya ɓoye su duka a cikin cin hanci da rashawa, a cikin saitunan da ba daidai ba ko a cikin ɓarna na shirin. A wasu halaye, sanadin hakan na iya zama matsaloli a cikin tsarin aiki. Saboda haka, don mayar da cikakken aiki yana da matukar muhimmanci a tantance tushen dalilin.