Yadda troubleshoot kurakurai a lokacin da ka ajiye Excel workbooks

Microsoft Excel ne mai falle tsara ta Microsoft. Samuwa a kan da yawa Tsarukan aiki da suka hada da Windows, macOS, iOS da Android da yayi iko kayayyakin aiki, kamar hoto, lissafi, pivot alluna da sauransu yin daban-daban ayyuka.

• Magani 1: Yadda Troubleshoot Excel Kuskuren
• Magani 2: Gyara Excel Wordbooks da Gyara Tool

Abin da irin kuskure na faruwa a lokacin da ka ajiye Excel fayil

Lokacin da ƙoƙarin ajiye wani Excel fayil, za ka iya yi mamaki da duk wani nau'i na kurakurai. Sa'ar al'amarin shine akwai mafita ga duk aka sani kurakurai. Bari mu duba wasu daga cikin kurakurai da kuma yadda za a gyara su.

Kafin ka fara troubleshoot Excel kuskure da yin amfani da classing hanyoyin ko ta hanyar yin amfani da wani Excel gyara kayan aiki, tabbatar ajiye your aiki a matsayin mafi kyau kamar yadda ka iya. A wadannan hanyoyin iya hada kwamfuta sake yi, wanda zai iya kai wa ga rasa your Excel data. Bari mu duba wasu workaround hanyoyin ajiye your Excel fayil na farko:

1. A batun iya lalacewa ta hanyar da sunan, don haka kokarin da daban-daban daya:
   - A saman hagu kusurwar allon, click on "File" sai kuma ka danna kan "ajiye a matsayin"
   - Zabi wani sunan daban
2. Zabi wani nau'in fayil for your Excel Kundin:
   - Danna kan "File", sai "Ajiye As"
   - Wani sabon taga zai bude. a kasa za ka ga "Ajiye kamar yadda Type", a cikin abin da jerin zaɓuka zabi wani version, kamar .xlsm ko .xlsx.
3. Adana abubuwan da ka Kundin matsayin HTML:
   - Danna kan "File", sai "Ajiye As"
   - Inda ya ce "Save as Type", zaɓi "Web Page"
   - Ajiye your Excel fayil

Magani 1: Yadda Troubleshoot Excel Kuskuren

Yanzu cewa your fayil aka amince da ceto zuwa kwamfutarka, za ka iya fara zuwa troubleshoot Excel kuskure . Domin fahimtar yadda za a gyara Excel, dole ne ka fahimci abin da ke haifar da batun da fari. Akwai 'yan dalilai wanda zai iya sa Excel to matsalar aiki na samfur:

1. Daya daga cikin dalilan da za su iya zama abin da Jaka directory ba ba ku izini don kammala wannan aiki. Dole ne ka bayar da wani fayil da wadannan izini:
   - Rubuta
   - Karanta
   - Share
   - Gyara
   
2. Wani batun da zai iya haifar da matsalar iya zama daga wani ɓangare na uku ƙara-a. Wadannan iri kadan shirye-shirye taimaka Excel don kammala daban-daban ayyuka. Wasu add-ins, an aka riga aka loda a lokacin da ka shigar da MS Excel yayin da wasu za a iya shigar da hannu daga kafofi da dama. Wani lokaci wadannan ƙara-ins iya haifar da matsaloli da kuma tabbatar da daya daga mafi daga gare su, to, zarge, za ka iya bude Excel a yanayin kariya:
   - Da farko kusa Excel gaba daya
   - Gano wuri inda kana da MS Excel
   - Latsa "CTRL" key kuma bar danna kan MS Excel executable bude shi. Rike da iko key har sai kun sami wadannan sakon "Excel ya gano cewa kana rike saukar da Ctrl key. Kada ka so ka fara Excel a yanayin kariya? Danna Ee.
   - Yanzu cewa ka kasance a cikin yanayin kariya, kokarin bude wani kwafin your Kundin kuma ganin idan ka iya ajiye shi.
   

   Idan ka sami damar ajiye shi, to, shi yana nufin cewa daya ko mahara add-ins, suna haifar da batun, don haka za ka yi don gano abin da daya da kuma share shi. Bayan ka samu troublesome add-a, a nasĩha ne a tuntube da developer na cewa takamaiman add-a matsayin su na da wani fix don batun.

3. Idan Disk ne cika, sosai wuya amma zai iya faruwa. Dole ne ka share wasu sarari.
4. An riga-kafi iya katse ceton aiwatar da your Excel Kundin. Mai riga-kafi software dan lokaci tarnhayar matakai kamar yadda suka duba shi, don kauce wa karya game da fayil ake kamuwa ko ba. Idan kana da wani aiki riga-kafi, a kokarin kashe shi, kawai don ganin idan ba za ka iya cece ka Excel Kundin.
5. Idan kana amfani da wani shared Kundin kuma wani mutum yana kokarin ya ceci Excel fayil a lokaci guda kamar yadda ka ne. Idan wannan shi ne yanayin, mafi sauki hanyar ne don gaya wa mutum jira ko kawai jira minti daya da kuma sake gwadawa.
6. Idan da tsawon da sunan fayil ne fiye da 218 characters za ka sami kuskure sakon "Sunanfayil ba shi da inganci", dole ne ka gyara sunan a cikin wannan harka.

Magani 2: Gyara Excel Wordbooks da Gyara Tool

Akwai kuskure daga abin da waɗannan classic hanyoyin ba su aiki. Sa'ar al'amarin shine akwai gagarumi Phoenix Excel Gyara wanda shi ne m wani Excel gyara kayan aiki. Yana iya yadda ya kamata a gyara m ko Excel fayiloli cewa ba za a iya bude ba tare da yin wani canje-canje zuwa ga Kundin. Ga 'yan daga cikin manyan abũbuwan amfãni:

Matakai a gyara Excel fayil kurakurai:

Mataki 1 Run da executable fayil bude gagarumi Phoenix gyara kayan aiki. Sa'an nan danna "Add fayil" zaɓi don zabi your fayil.

Mataki 2 A taga zai bayyana a kan allon. A wannan lokaci, dangane idan kana da wata guda, ko mahara fayiloli a gyara, zabi cikin "Zabi File" ko "Select Jaka" zaɓi.

Mataki na 3 zarar ka located your fayil ko babban fayil, a Excel gyara kayan aiki , danna "Scan" button.

Mataki na 4 Bayan kamar 'yan seconds za ka sami wani preview na gyara Excel fayil.

Mataki 5 Ajiye fayil zuwa gida drive.

Gagarumi Phoenix ne mai iko Excel gyara kayan aiki. A sauki don amfani dubawa da kuma sauri aiki damar taimaka masu amfani da gyara gurbace Excel fayiloli da sauri don haka ba za su iya ci gaba da aikinsu.

A 'yan tips lokacin da akayi tare da m Excel fayil:

• Rufe duk a guje Excel workbooks kafin kokarin gyara wani mara kirki fayil .
• Adana abubuwan da ka yi aiki kafin ka troubleshoot Excel kuskure.
• Kafin samun cikin wahala gyara matsala matakai, fara da sauki wadanda farko.