Microsoft Excel shiri ne da ake amfani da shi sosai don tsarawa, tantancewa da ganin bayanai. Koyaya, wani lokacin lokacin aiki tare da shi zaku iya fuskantar matsaloli yayin ƙoƙarin buɗe fayilolin Excel.
Lokacin da ka danna fayil sau biyu kuma babu abin da ya faru, ko lokacin da fayil ɗin Excel ya buɗe amma ba a gani ba, za ka iya jin takaici. Wannan na iya zama matsala musamman idan kuna buƙatar samun damar bayanan da ke cikin wancan fayil nan take.
Abin farin ciki, muna da wasu mafita don taimaka muku magance matsalar. A cikin wannan labarin, za mu bi ku ta wasu abubuwa da za ku iya gwadawa don buɗe fayil ɗin Excel ɗin ku kuma sake fara aiki. Za mu kuma nuna muku yadda ake buɗe fayil ɗin Excel mai kare kalmar sirri idan kuna da matsala da hakan, kuma.
Sashe na 1: Abin da za a yi idan ba a iya buɗe fayil ɗin Excel ba
"Me yasa bazan iya bude fayil na Excel ba?" Matsalar gama gari ce da yawancin masu amfani ke fuskanta yayin amfani da MS Excel. Idan kuna fama da wannan matsala, kada ku damu: ba ku kadai ba.
Akwai 'yan dalilan da suka sa yanayin "Excel ya daina buɗe fayiloli" na iya faruwa, gami da:
- Saboda sabunta tsaro na Microsoft
- Fayil ɗin bai dace da sigar MS Office ɗin ku ba
- Aikace-aikacen Excel ko fayil ya lalace ko ya lalace
- Tsawon fayil ɗin ba daidai ba ne ko an gyara shi
- Plugins suna tsoma baki tare da buɗe fayil
Ko da yake Excel shahararriyar manhaja ce, kuma Microsoft a kullum yana aiki don tabbatar da cewa masu amfani da shi ba su fuskanci wata matsala ba, wani lokacin ba za ka iya bude fayil na Excel ba.
Idan kai ma kuna fuskantar wannan matsalar kuma ba ku san dalili ba, ga wasu yuwuwar mafita waɗanda za su taimaka muku warware ta:
Magani 1: Gyara Microsoft Office ɗin ku
Ɗaya daga cikin abubuwan farko da za ku iya gwadawa lokacin da fayil ɗin Excel ba zai buɗe ba shine gyara Microsoft Office. Wannan yana aiki idan MS Office da kansa yana haifar da matsala kuma yana hana ku buɗe fayiloli.
Gyaran Office MS yana taimaka muku warware matsalolin gama gari iri-iri, gami da waɗanda ke da alaƙa da fayilolin Excel ba buɗewa.
Don wannan, bi waɗannan matakan:
Mataki 1: Je zuwa "Control Panel" kuma a cikin "Programs" sashe danna kan "Uninstall wani shirin" zaɓi.
Mataki 2: Danna-dama akan Microsoft Office kuma zaɓi zaɓi "Change".
Mataki 3: A cikin gaba taga cewa ya bayyana, zaɓi "Online Gyara" da kuma bi tsokana don kammala tsari.
Magani 2: Cire alamar akwatin "Yi watsi da DDE".
Idan maganin farko bai yi aiki a gare ku ba, kada ku damu. Akwai wasu zaɓuɓɓuka. Wata hanyar da za a magance matsalolin "Fayil na Excel baya buɗewa" shine cire alamar akwatin "Yi watsi da DDE".
Dynamic Data Exchange (DDE) yarjejeniya ce da ke ba da damar aikace-aikace daban-daban don raba bayanai. Wannan yarjejeniya na iya haifar da matsala a wasu lokuta tare da aikace-aikacen MS Office, gami da rashin iya buɗe fayil ɗin Excel lokacin da mai amfani ya danna shi.
Don cire alamar akwatin "Yi watsi da DDE", bi waɗannan matakan:
Mataki na 1 : Bude MS Excel kuma je zuwa shafin "File".
Mataki na 2 : Danna "Zaɓuɓɓuka" sannan zaɓi "Na ci gaba".
Mataki na 3 : A cikin taga zaɓin “Babba”, gungura ƙasa zuwa sashin “Gabaɗaya” kuma cire alamar akwatin kusa da “Yi watsi da sauran aikace-aikacen da ke amfani da Dynamic Data Exchange (DDE)” kuma adana canje-canje.
Magani 3: Kashe Plugins
Idan har yanzu kuna fuskantar matsalar buɗe fayil ɗin Excel ɗinku, abu na gaba da zaku iya gwadawa shine kashe duk wani ƙari wanda zai iya yin kutse tare da buɗe fayil ɗin.
Add-ins na Excel kayan aiki ne na ɓangare na uku waɗanda za a iya ƙarawa zuwa Microsoft Office Excel don haɓaka ayyukan sa. Kodayake yawanci suna da amfani sosai, wani lokacin suna iya haifar da matsala.
Don kashe plugins, bi waɗannan matakan:
Mataki na 1 : Bude MS Excel kuma je zuwa shafin "File".
Mataki na 2 : Danna "Zaɓuɓɓuka" sannan zaɓi "Ƙara-kan".
Mataki na 3 : A cikin "Add-ons" taga, zaɓi "COM Add-ons" daga menu mai saukewa kuma danna "Tafi".
Mataki na 4 : A cikin taga na gaba, cire duk akwatunan kuma danna "Ok".
Magani 4: Sake saita Ƙungiyoyin Fayil na Excel zuwa Tsoffin
Idan kashe add-ins bai yi aiki ba, ko kuma ba ku da wani shigarwa, gwada sake saita duk ƙungiyoyin fayil ɗin Excel zuwa ƙimar su ta asali. Wannan zai tabbatar da cewa daidaitaccen shirin (Excel Application) yana buɗewa lokacin da kake ƙoƙarin buɗe fayil ɗin Excel.
Don sake saita ƙungiyoyin fayil, bi waɗannan matakan:
Mataki na 1 : Bude "Control Panel" kuma je zuwa "Shirye-shiryen> Default Programs> Saita tsoho shirye-shirye"
Mataki na 2 : Wani taga zai buɗe yana nuna "Default Apps" a cikin Saitunan Windows. Daga nan, kawai gungura ƙasa kaɗan kuma danna "Sai Predefinicións ta app."
Mataki na 3 : Na gaba, nemo shirin "Microsoft Excel" a cikin jerin kuma danna shi. Sannan danna "Manage".
Mataki 4: A ƙarshe, zaɓi kari na fayilolin da ba su buɗe ba kuma saita tsoffin aikace-aikacen su zuwa Excel.
Magani 5: Sami taimako daga Tallafin Microsoft
Idan kun gwada duk hanyoyin da ke sama kuma har yanzu ba za ku iya buɗe fayil ɗin Excel ɗin ku ba, mafi kyawun abin da zaku iya yi shine neman tallafi na Microsoft don taimako.
Microsoft yana ba da tallafi kyauta ga duk samfuran Office, don haka idan kuna fuskantar matsala tare da fayil ɗin Excel ɗinku, ƙungiyar ƙwararrun su yakamata su taimaka muku warware matsalar.
Don tuntuɓar su, je zuwa "https://support.microsoft.com/contactus/" kuma cika fom ɗin.
Sashe na 2: Yadda ake buɗe Excel mai kare kalmar sirri ba tare da kalmar sirri ba
Kamar yadda kake gani, akwai mafita da yawa da zaku iya gwadawa idan kuna fuskantar matsala buɗe fayil ɗin Excel. Amma menene za ku yi idan fayil ɗin yana da kariya ta kalmar sirri kuma ba ku da ɗaya?
Idan kun sami kanku a cikin wannan yanayin, kada ku damu. Wannan shine inda Fasfo don Excel ya shigo.
Fasfo don Excel an ƙera shi don taimaka wa masu amfani da su dawo da batattu ko kalmomin shiga da aka manta don fayilolinsu na Excel. Kayan aiki ne mai ƙarfi kuma mai sauƙin amfani wanda zai iya taimaka maka da sauri sake samun damar shiga fayil ɗin Excel ɗinka mai kariya.
Ba wai kawai ba, amma kuna da damar samun nasara mafi girma, yana ba ku damar komawa aiki akan fayil ɗinku da wuri-wuri.
Wasu sanannun fasalulluka na Fasfo don Excel sune:
- Ya dace da duk nau'ikan MS Excel, daga 1997 zuwa 2019.
- Yana ba da hanyoyin kai harin kalmar sirri 4 masu ƙarfi
- 100% mai lafiya don amfani ba tare da damar rasa bayanai ba
- Mafi girman nasara da lokacin dawowa cikin sauri
- Babu iyaka akan girman fayil
- Gwajin kyauta da garantin dawo da kuɗi
Anan ga yadda ake amfani da Fasfo don Excel don buɗe fayil ɗin Excel mai kare kalmar sirri ba tare da kalmar sirri ba:
Mataki 1: Zazzagewa kuma shigar Fasfo don Excel a kan kwamfutarka. Na gaba, kaddamar da shirin kuma danna "Cire Passwords."
Mataki 2: Zaɓi fayil ɗin Excel mai kare kalmar sirri da kuke son buɗewa, sannan zaɓi yanayin hari sannan danna "Maida".
Mataki na 3: Jira har sai shirin ya samo kalmar sirrin fayil ɗin Excel ɗin ku sannan danna "Kwafi" don adana shi a cikin allo kuma buɗe takaddun Excel mai kariya.
Kammalawa
Ko da yake Microsoft Excel shiri ne da aka tsara sosai kuma gabaɗaya yana gudana ba tare da wata matsala ba, har yanzu akwai lokutan da masu amfani suka gamu da kura-kurai da ke sa ya yi wahala buɗe fayil ɗin Excel. Da fatan mafita a cikin wannan labarin na taimaka muku gyara matsalar ta yadda zaku iya samun dama ga mahimman fayil ɗin Excel ɗinku ba tare da wata matsala ba.
Kuma idan kun manta ko rasa kalmar sirrin fayilolin Excel masu kare kalmar sirrinku, Fasfo don Excel na iya taimaka muku dawo da shiga cikin ƴan matakai masu sauƙi tare da ƙimar nasara 100%. Don haka, kuma la'akari da gwada shi idan kun makale.
