Yadda za a gyara cin hanci da rashawa Excel fayil Kuskure a Excel 2013

"Mun samu matsala da wasu abubuwan ciki a . Kuna so mu gwada warke kamar yadda za mu iya? Idan ka amince da tushen wannan Kundin, danna eh "

• Part 1: Mene ne Kuskuren hanyar Excel fayil samun gurbace
• Part 2: Tare da 'Open da kuma Gyara' alama zuwa Gyara m Excel fayil
• Sashe na 3: Gyara MS Excel Fayil tare da Excel Gyara Tool
• Sashe na 4: Tips to Gyara gurbace Excel fayil

Part 1: Mene ne Kuskuren hanyar Excel fayil samun gurbace

A sabili da kuskure, yawanci saboda:

• a). wasu kuskure a cikin wani add-ins a cikin ɓangare na uku software.
• b). Idan wani layi da aka kara wa wani cell maimakon yawan wannan kuskure na iya zo. Wannan kuma iya faruwa idan wani layi da aka kara abin da yake canzawa zuwa lamba.

A 'yan tatsuniyoyinsu inda Excel takardar samun gurbace ne kamar yadda a kasa:

1. M kashewa na tsarin: Mutane da yawa sau kwamfuta tsarin sha kwatsam kashewa saboda wutar lantarki rashin cin nasara ko wani irin dalilin. Duk da haka, rufe saukar da tsarin kullum amma ba tare da ya kamata rufe duk Gudun aikace-aikace na iya ma sa tareda žata effects zuwa fayiloli da bayanai zuwa wata irin mataki. MS Excel fayiloli kuma samun lalace ko gurbace saboda irin dalilai.
2. Virus: Computer ƙwayoyin cuta wadda ne shirye-shirye da qeta tsara don harba tushen ko fayilolin bayanai a kan kwamfutarka, sau da yawa a wani sosai manyan sikelin. A kwamfuta tsarin gurbata da kwayar cutar na iya zama wani dalili na Excel fayiloli yin gurbace.
3. Bad sassa a kan wani ajiya na'urar: The ajiya na'urorin misali rumbun kwamfutarka (gida), rumbun kwamfutarka (external) alkalami drive, da dai sauransu iya samun ci gaba bad sassa kan wasu lokaci, wanda shi ne m wani hardware matsala, Excel takardar a kan wadannan miyagun sassa na ajiya kafofin watsa labarai za su iya samun m.
4. M handling na MS Excel: An m rufe na Excel takardar ko rashin iya rufe na wani ya buɗe fayil na iya zama wani dalili na gurbace Excel fayil.
5. Manyan data size: Amma MS Excel ba a nufi ga tanadin babbar data kamar yadda shi ne, ba wani database, saboda haka, chances na cin hanci da rashawa ya zama mafi idan ka obalodi Excel fayil zuwa dauke da wani babban adadin bayanai.
6. Software rikici: Wani lokaci software rikice-rikice, kazalika da, da wuya, ko da yake, bugu Excel fayil iya zama sanadin tareda žata Excel fayiloli.
7. Macros da dabarbari: Excel Macros da hadaddun dabarbari ma da aka sani da mummunan suna samar gurbace data a wani aiki worksheet.

Part 2: Tare da 'Open da kuma Gyara' alama zuwa Gyara m Excel fayil

Don gyara Excel Kundin (Excel 2013) tare da irin sakon kuskuren: "Mun sãmi wata matsala tare da wasu abubuwan ciki a <filename>. Shin kana so mu gwada warke kamar yadda za mu iya? Idan ka amince da tushen wannan Kundin, danna eh "

Wannan ya bayyana tare da Excel 2007/2010, kazalika, akwai biyar hanyoyin warke gurbatattun fayil.

1. Dawo (daga Ajiyayyen). Fayil za a iya mayar da daga madadin alhãli kuwa madadin dole ne a kiyaye ta atomatik.

2. Dawo (daga farfadowa da na'ura fayil). Wannan shi ne wani madadin madadin, wani fayil hada da duk Excel data cewa za ka iya kawo koma har idan data aka share ko lalace bazata. Don yin wannan alama 'duba' a kowane akwati na "Ajiye AutoRecovery" a cikin Excel Zabuka, fãce 'A kashe AutoRecover'.

3. warke daga Daftarin aiki Office. Wannan wani zaɓi yana samuwa ne kawai a lokacin da fayil ne dan kadan shafa. A cikin aiki ayyuka na shirin dawo, arrow kusa gano fayil iya latsa kuma 'Ajiye AS' wani zaɓi damar dawo da.

4. Open da kuma Gyara "fasalin. Excel ta atomatik farawa yunƙurin dawo da shi ne yanayin da shi detects wani m Excel 2013 fayil, kamar yadda da makaman da aka bayar a MS Excel kanta. Amma gazawar wannan yanayin, manual dawo ne achievable ta "Open da kuma Gyara" fasalin. Bi wadannan matakai.

• Open Excel
• Danna fayil Open.
• Browse. Zabi gurbatattun worksheet.
• Daga Pull-saukar menu (latsa kibiya daga Open button) danna 'Open da kuma Gyara'.

5. Na uku-jam'iyyar Tools.

A cikin yanayin babu wani daga cikin wadannan zažužžukan warke Excel 2013 fayil yadda ya kamata, mafi kyau sana'a Excel Gyara software 'gagarumi Phoenix Excel Gyara' Ya kamata a yi amfani da su gyara duk kurakurai.

Sashe na 3: Gyara MS Excel Fayil tare da Excel Gyara Tool

Gagarumi Phoenix Excel Gyara ne Excel fayil gyara software. A demo version ne free to bari da novice kwarewa kage. Yana da wani dole ne Excel fayil gyara software cewa flawlessly gyare-gyare gurbace Excel fayil. Wannan Excel fayil gyara software offers biyu lasisi versions, daya ga wata guda mai amfani da kuma sauran for mahara tsarin ne samuwa goyon bayan Mac (Excel2011) da kuma duk versions na windows.

Microsoft Excel Gyara Tool

• Gyare-gyare duk irin data adana a lalace Excel fayil kamar Tables, Charts, dabarbari, comments, images, da dai sauransu
• Dawo da dukkan gurbace Excel fayiloli zuwa ga asali tsaye.
• Samfoti da gyara Excel fayil a real-lokaci, ganin yadda da yawa daga cikin fayil An gano kamar yadda ake gyara.
• Duk irin MS ofishin cin hanci da rashawa kurakurai (ga XLS da XLSX fayiloli kawai) za a iya abar kulawa da wannan kayan aiki.
• Wannan Excel fayil gyara kayan aiki za a iya amfani da a kan duka windows da kuma Mac dandamali domin a gyara m Excel fayil.
• Duk irin MS ofishin cin hanci da rashawa kurakurai (ga XLS da XLSX fayiloli kawai) za a iya abar kulawa da wannan kayan aiki.
• Wannan Excel fayil gyara kayan aiki iya gyara lalace fayiloli daga duk versions daga 2000 zuwa 2016 da ya hada da 2000, 2003, 2007, 2010, 2013, da dai sauransu

Download Windows Version Download Mac Version

Simple matakai don cika Excle fayil Gyara

Domin Windows, wadannan jerin matakai iya bi domin samun sauƙin gyara gurbace Excel fayil , gurbace ko lalace. Domin Mac, da zabin akwai kuma za a iya amfani da wannan hanya. Wannan Excel fayil gyara software na aiki daidai da kyau a kan ko dai na biyu zuwa gyara gurbace Excel fayil .

mataki na 1

mataki 2

mataki na 3

mataki na 4

Sashe na 4: Tips to Gyara gurbace Excel fayil

Case 1. Lokacin da Excel ba zai iya bude fayil

1. Kwafi da kuma bude m fayil a wuya-drive.
2. Nemo .xlb fayil. Har ila yau, ci gaba a madadin da. Share .xlb. Sake kunnawa Excel.
3. Gwada bude fayil a MS kalma ko Notepad. Duk da haka, da cewa zai bari ka warke data amma ba tsarawa
4. Amfani Excel XP. Wannan yana da mafi alhẽri zaɓuɓɓuka saboda maida.
5. Lokacin da yunƙurin bude fayil, musaki macros
6. Click fara guje Excel a yanayin kariya, sa'an nan kuma shigar da "C: \ Shirin fayil \ Microsoft ofishin \ ofishin \ excel.exe" / s

Case 2. Lokacin da Excel fayil shi ne bude

1. Gwada a kan wani daban-daban kwamfuta
2. Kashe Auto-ajiye.
3. Kashe fayil sharing wani zaɓi
4. Kada gudu Excel daga floppy
5. Ajiye fayil a matsayin shafin yanar gizo da kuma sake bude shi a matsayin Excel fayil.
6. Rage girman Excel fayil
7. Koma zuwa karshe version of fayil ceto.

Rigakafi Tips don kauce wa Excel fayil samun gurbace

• Tabbatar da tsarin da aka rufe yadda ya kamata.
• Ko da yaushe shigar da latest anti-virus.
• Babu bad sassa kasance a can a kan ajiya na'urar.
• Koyaushe rufe Excel yadda ya kamata.
• Kauce wa babbar data tanadin da Excel.