Yadda za a gyara Excel File Name ba shi da inganci Kuskuren

Wannan shi ne matukar kowa ga duk wani mai amfani da ake rubutu da Excel fayil zuwa haɗu da wani na da yawa iri kurakurai. Sau da yawa wani kuskure dangane da bude wani data kasance Excel fayil (wanda ke nufin wani matsala a samun dama da ake so Excel fayil), ko a kan ceton fayil ko Excel daftarin aiki (falle) ya auku. Akwai da dama yiwu dalilai na wadannan kurakurai, kuma daidai remedial ayyuka da cewa zai iya taimaka warware wannan batun.

• Part 1: The Best Excel fayil Gyara Tool
• Part 2: yadda za a gyara cin hanci da rashawa Excel fayil
• Sashe na 3: Gyara Excel Tare da 'Open da kuma Gyara' alama
• Sashe na 4: Ta yaya za a kauce wa Excel fayil samun cin hanci da rashawa

Wani kuskure da kuma manyan kama a yanayi bayyana a matsayin ko dai na wadannan sakonni:

• Sunan fayil ba shi da inganci
• Fayil ba za a iya isa ga.
• The hanyar da ka shiga, '<filename>', shi ne ma dogon.
• <Filename> ba a iya samu.
• '<Filename>. <Tsawo>' ba a iya samu (a samu a Excel 2000).

'File Name ba shi da inganci': yayin da samar da ceton, ko bude wani Excel fayil irin wannan kuskure na iya nufin daya daga wadannan dalilai:

1. Hanyar fayil ciki har da sunan fayil na iya wuce 218 yawan haruffa iyakance
2. Sunan fayil na iya zama ba daidai ba
3. Hanyar bazai dace
4. Fayil wuri ko drive iya ba za a daidai ba
5. Iyakancewar ɓarna na haruffa a sunan fayil
6. Backslash tsakanin manyan fayiloli
7. Haruffa a sunan fayil
8. The sunan fayil zai iya kasance daidai, amma ya aka sake masa suna ko motsa zuwa wasu wuri ko samu accidently share.

A wahala a samar da wata mahada zuwa wani Excel fayil taso daga iyakance 256 characters. Ganin cewa 218 characters iyakance ga fassara da hanya dogara ne a matsayin:

• Excel takardar sunan, matsakaicin 31 haruffa.
• Baka da Apostrophes ana amfani da su nuna Kundin sunan.
• An motsin rai alama.
• Reference na cell.

Wannan halin da ake ciki shi ne, duk da haka, da sauki za a magance matsayin daya iya ko dai sake suna fayil ko babban fayil ta amfani da gajeriyar sunan (ba wucewa 218 characters) ko motsi da fayil zuwa wani guntu mai suna fayil. Amma da wahala taso idan Excel fayil samun gurbace ko lalace.

Part 1: The Best Excel fayil Gyara Tool

Don gyara gurbace Excel fayil yawa Excel gyara Tools da Excel fayil gyara software suna samuwa. Gagarumi Excel Gyara Tool iya rike kurakurai kamar "kasa karanta fayil" ko "fayil shi ne cin hanci da rashawa da kuma ba za a iya bude". Yana iya rike duk Excel versions amma har zuwa Excel 2003. goyon bayan duk XLS versions.

Part 2: yadda za a gyara cin hanci da rashawa Excel fayil

Wadannan da jerin allon nuni (ga lashe) hanzarta taimaka don fita daga mataki zuwa mataki gyarawa da kuma murmurewa Excel fayiloli cewa an gurbace ko lalace. Option domin Mac kamar wancan za a iya amfani.

Mataki 1 Launch Excel fayil gyara , kuma zaži m Excel fayil daga gida drive da search.

Mataki 2 A cikin bincike sakamakon sashe nuna duk m Excel fayil, zaɓi ɗaya ko duk fara zuwa gyarawa tsari

Mataki na 3 Previewing da gyara zabi fayiloli daga hagu bar.

Mataki na 4 Ceton gyara Excel fayil da makõma zuwa wuri.

Sashe na 3: Gyara Excel Tare da 'Open da kuma Gyara' alama

MS Excel ta fasali sauƙaƙe wani atomatik dawo hanya idan ta gane wani gurbace Excel fayil. Duk da haka, idan dawo da yanayin kasa ta fara amfani iya kokarin dawo da hannu kamar yadda aka nuna a kasa.

Mataki 1. Danna fayil> Open.

Mataki 2. Danna fayil dauke da shafi worksheet, da kuma wuri

Mataki 3. Zabi a maganganu akwatin da gurbatattun fayil

Mataki 4. Danna kibiya a kusa da bude button

Mataki 5. Danna bude & gyara kamar yadda ya haskaka a nan.

tips:

Baya amfani da ɓangare na uku Excel Gyara Tool ko Excel fayil gyara software, 'yan dubaru na iya taimaka wa mai amfani warke ko gyara gurbace Excel fayil.

Case 1. Idan na'urar mai kwakwalwa ba zai iya bude fayil kokarin wadannan to ya warware matsalar da kanka.

1. Kwafi m fayil a kan rumbun-drive idan ta wanzu a kan floppy.
2. Ka yi kokarin samun .xlb fayil ajiye wani kwafin ajiya da. Yanzu share .xlb kuma zata sake farawa Excel.
3. Ka yi kokarin bude fayil a MS kalma ko Notepad wanda zai iya bari ka warke data amma ba tsarawa.
4. MS Excel 97/2000 viewer iya bari ka duba data da kuma buga. Open fayil ta amfani da wannan free shirin zuwa mai da bayanai. Wannan shirin na iya mai da ko da tsarawa, kazalika da cell dabi'u.
5. Amfani Excel XP wanda da mafi alhẽri zaɓuɓɓuka saboda maida.

Case 2. Idan Excel fayil shi ne bude Gwada wadannan to ya warware matsalar da kanka.

1. Gwada a kan wani daban-daban kwamfuta
2. Kada gudu Excel daga floppy
3. Kashe Auto-ajiye
4. Kashe fayil sharing wani zaɓi
5. Ajiye fayil a matsayin shafin yanar gizo da kuma sake bude shi a matsayin Excel fayil.

Sashe na 4: Ta yaya za a kauce wa Excel fayil samun cin hanci da rashawa

• Tabbatar da tsarin da aka rufe yadda ya kamata. Domin cewa al'amarin kusa da dukan aikace-aikace kafin a rufe ta. Duk da haka, saboda yanayi fiye da mutum iko kamar nan da nan cire hašin da ikon samar iya fararwa fayil cin hanci da rashawa saboda rashin iya rufe na aikace-aikace.
• Gwada shigar da latest anti-virus kiyaye ka tsarin free daga qeta harin. Ƙwayoyin cuta ko da yaushe yin Excel fayil mai saukin kamuwa zuwa cin hanci da rashawa
• Ka yi kokarin ci gaba da your ajiya sarari kamar yadda zai yiwu free daga sharri kansu chances na Excel fayil cin hanci da rashawa ne babban idan data da aka ajiye a kan wani mummunan kansu.
• Kokarin warware batutuwan da ba a MS Excel aikace-aikace. M da m rufe Excel takardar triggers fayiloli cin hanci da rashawa.
• Ka yi kokarin rike kananan data lokacin da akayi tare da Excel fayil. Babban data a kan na'urar mai kwakwalwa takardar ne a jagorancinsa hanyar fayil cin hanci da rashawa.