Yuav ua li cas Kho ncaj Excel ntaub ntawv yuam kev nyob rau hauv Excel 2013

"Peb pom ib qho teeb meem nrog ib co ntsiab lus nyob rau hauv . Koj puas xav kom peb mus sim zoo npaum li raws li peb ua tau? Yog hais tias koj tso siab rau lub hauv paus ntawm phau, nias yog "

• Part 1: Yuav ua li cas yog lub yuam kev ua Excel ntaub ntawv tau corrupted
• Part 2: Nrog 'Qhib thiab Kho' feature rau Kho siab tsis ncaj Excel ntaub ntawv
• Part 3: Kho MS Excel ntaub ntawv nrog Excel Kho Tool
• Part 4: Tswv yim rau Kho corrupted Excel ntaub ntawv

Part 1: Yuav ua li cas yog lub yuam kev ua Excel ntaub ntawv tau corrupted

Ua kom muaj qhov yuam kev, feem ntau yog vim:

• a). ib co kev ua yuam kev nyob rau hauv tej add-ins nyob rau hauv lub thib peb tog software.
• b). Yog hais tias ib txoj hlua yog ntxiv rau ib tug cell es tsis txhob ntawm tus xov tooj no yuam kev tej zaum yuav tuaj. Qhov no kuj yuav tshwm sim yog tias ib txoj hlua ntxiv uas yog convertible rau ib tug xov tooj.

Ib tug ob peb scenarios qhov twg Excel ntawv twg thiaj li raug corrupted muaj raws li hauv qab no:

1. Kev shutdown ntawm lub system: Muaj ntau lub sij hawm computer system yauv cia li shutdown vim fais fab mov tsis ua hauj lwm los yog tej zoo xws li cov yog vim li cas. Txawm li cas los, shutting cia lub system nquag tab sis tsis muaj zoo kaw tag nrho cov khiav ntaub ntawv sau npe yuav kuj ua rau puas tsuaj rau cov ntaub ntawv thiab cov ntaub ntawv mus rau ib tug zoo xws li cov degree. MS Excel ntaub ntawv kuj tau puas los yog corrupted vim xws yog vim li cas.
2. Tus kab mob no: Computer kab mob uas yog cov kev pab cuam maliciously tsim los kis qhov chaw los yog cov ntaub ntawv cov ntaub ntawv nyob rau hauv ib tug computer, feem ntau ntawm ib tug heev loj scale. A computer system kab mob nrog tus kab mob no yuav ua tau ib tug ua ntawm Excel ntaub ntawv tau txais lawm.
3. Phem sectors rau ib tug cia ntaus ntawv: Cov cia li xws li nyuaj tsav (lub zos), nyuaj tsav (lwm) mem tsav, thiab lwm yam tej zaum yuav tau tsim kev phem sectors tshaj tej lub sij hawm ntawm lub sij hawm, uas yog cia li ib tug kho vajtse teeb meem, Excel ntawv rau ntawm cov neeg phem no sectors ntawm cia xov xwm yuav tau corrupt.
4. Kev tuav ntawm MS Excel: Ib npaj txhij txog kaw ntawm Excel ntawv los yog kev kaw ntawm ib tug qhib cov ntaub ntawv yuav tsum muaj ib tug ua kom muaj corrupted Excel ntaub ntawv.
5. Loj cov ntaub ntawv loj: Yeej MS Excel yog tsis meant rau kov lossis loj cov ntaub ntawv raws li nws tsis yog ib tug database, yog li ntawd, txoj kev noj nyiaj txiag ua yog koj overload zoo ua ntaub ntawv thov kom muaj ib tug loj npaum li cas ntawm cov ntaub ntawv.
6. Software teeb meem: Tej zaum software tsis sib haum raws li zoo raws li, tsis tshua, tab sis yog, printing zoo cov ntaub ntawv kuj yuav ua kom puas rau excel cov ntaub ntawv.
7. Macros thiab qauv: Excel Macros thiab complex qauv kuj muaj ib tug paub yus lub qe phem ntawm txoj kev corrupted ntaub ntawv nyob rau hauv ib tug ua hauj lwm ntawv.

Part 2: Nrog 'Qhib thiab Kho' feature rau Kho siab tsis ncaj Excel ntaub ntawv

Yuav kom kho Excel phau (Excel 2013) nrog lub hom ua yuam kev cov lus: "Peb pom ib qho teeb meem nrog ib co ntsiab lus nyob rau hauv <filename>. Koj puas xav kom peb mus sim zoo npaum li raws li peb ua tau? Yog hais tias koj tso siab rau lub hauv paus ntawm phau, nias yog "

Uas zoo nkaus li nrog Excel 2007/2010 li zoo, muaj tsib txoj kev mus rau rov qab corrupted ntaub ntawv.

1. Restore (los ntawm thaub qab). Cov ntaub ntawv yuav tsum tau rov qab los ntawm cov thaub qab whereas backup yuav tsum tau khaws cia tau.

2. Restore (los ntawm rov qab ua ntaub ntawv thov). Qhov no yog ib qho lwm txoj kev mus thaub qab, ib cov ntaub ntawv muaj tag nrho cov Excel ntaub ntawv uas koj yuav nqa rov qab txawm hais tias cov ntaub ntawv yog deleted los yog puas ntawd. Ua li no cim 'xyuas' nyob rau hauv txhua txhua lub thawv uas "Txuag AutoRecovery" nyob rau hauv lub Excel Options, tsuas yog 'lov tes taw AutoRecover'.

3. Rov qab los ntawm chaw ua hauj lwm ntawv. Qhov kev xaiv no yog muaj tsuas yog thaum cov ntaub ntawv yog ib nyuag cuam tshuam. Nyob rau hauv lub neeg ua hauj lwm pane ntawm documentary rov qab, xub nyob ze zoo tu qab tso cov ntaub ntawv tej zaum yuav clicked thiab 'Txuag AS' kev xaiv enables rov qab.

4. Qhib thiab Kho "feature. Excel txiav pib sim rov qab yog cov ntaub ntawv nws detects tej corrupt Excel 2013 cov ntaub ntawv, raws li cov chaw yog muab nyob rau hauv MS Excel nws tus kheej. Tab sis tsis ua hauj lwm rau no hom, phau ntawv rov qab yog achievable los ntawm "Qhib thiab Kho" feature. Ua raws li cov kauj ruam.

• qhib Excel
• Nyem ntaub ntawv Qhib.
• Xauj. Xaiv corrupted ntawv.
• Los ntawm rub-down ntawv qhia zaub mov (nias xub qhib khawm) nyem 'Qhib thiab Kho'.

5. Peb-tog cuab yeej.

Nyob rau hauv cov ntaub ntawv tsis muaj leej twg ntawm cov kev xaiv rov qab Excel 2013 cov ntaub ntawv kom zoo, zoo tshaj plaws kev Excel Kho software 'Stellar Phoenix Excel Kho' yuav tsum tau siv rau kev txhim kho tag nrho cov uas tsis.

Part 3: Kho MS Excel ntaub ntawv nrog Excel Kho Tool

Stellar Phoenix Excel Kho yog ib qho Excel ntaub ntawv kho software. Lub demo version yog free rau cia tus novice kev zoo. Nws yog ib tug yuav tsum muaj excel ntaub ntawv kho software uas flawlessly kho corrupted excel cov ntaub ntawv. Qhov no mus zoo ua ntaub ntawv thov kho software muaj ob daim ntawv tso cai versions, ib tug rau ib tug tib neeg siv thiab lwm yam rau ntau yam systems yog muaj txhawb Mac (Excel2011) thiab tag nrho versions ntawm qhov rais.

Microsoft Excel Kho Tool

• Kho txhua yam ntawm cov ntaub ntawv khaws tseg nyob rau hauv puas zoo cov ntaub ntawv xws li lub rooj, charts, qauv, comments, dluab, thiab lwm yam
• Restore tag nrho koj cov corrupted excel cov ntaub ntawv mus rau lawv qub sawv.
• Saib cov kho mus zoo ua ntaub ntawv thov nyob rau hauv real-time, saib npaum li cas ntawm cov ntaub ntawv tau raug zoo tu qab tso raws li nws kho.
• Tag nrho cov hom ntawm MS chaw ua hauj lwm kev noj nyiaj txiag uas tsis (rau XLS thiab XLSX ntaub ntawv xwb) yuav muaj leej twg nrog no lub cuab tam.
• Qhov no mus zoo ua ntaub ntawv thov kev kho lub cuab tam yuav siv tau rau ob leeg lub qhov rais thiab Mac platforms nyob rau hauv thiaj li yuav kho siab tsis ncaj zoo cov ntaub ntawv.
• Tag nrho cov hom ntawm MS chaw ua hauj lwm kev noj nyiaj txiag uas tsis (rau XLS thiab XLSX ntaub ntawv xwb) yuav muaj leej twg nrog no lub cuab tam.
• Qhov no mus zoo ua ntaub ntawv thov kev kho lub cuab tam yuav kho puas cov ntaub ntawv ntawm txhua lub versions ntawm 2000 mus 2016 uas muaj xws li 2000, 2003, 2007, 2010, 2013, thiab lwm yam

Download lub qhov rais Version Download Mac Version

Tej yam yooj yim cov kauj ruam ua Excle ntaub ntawv Kho

Rau lub qhov rais, cov nram qab ib theem zuj zus ntawm cov kauj ruam yuav tsum tau ua raws tau yooj yim kho corrupted excel ntaub ntawv , corrupted los yog puas ntsoog. Rau Mac, cov kev xaiv yog muaj thiab yuav tau siv tib txoj kev. Qhov no Excel ntaub ntawv kho software ua hauj lwm sib npaug zoo rau tog twg los ntawm ob mus kho corrupted excel ntaub ntawv .

Kauj ruam 1

Kauj ruam 2

Kauj ruam 3

Kauj ruam 4

Part 4: Tswv yim rau Kho corrupted Excel ntaub ntawv

Case 1. Thaum Excel yuav tsis qhib cov ntaub ntawv

1. Luam thiab qhib siab tsis ncaj cov ntaub ntawv rau ib qho nyuaj-tsav.
2. Nrhiav .xlb cov ntaub ntawv. Tsis tas li ntawd kom ib tug thaub qab kom zoo. Rho tawm .xlb. Restart Excel.
3. Sim qhib cov ntaub ntawv nyob rau hauv MS lo lus los yog Notepad. Txawm li cas los, hais tias yuav cia koj rov qab cov ntaub ntawv, tiam sis tsis formatting
4. Siv Excel XP. Qhov no muaj kev zoo dua qub rau rov qab.
5. Thaum sim qhib cov ntaub ntawv, lov tes taw macros
6. Nyem pib khiav Excel nyob rau hauv kev ruaj ntseg hom thiab ces sau "C: \ Program ntaub ntawv \ Microsoft office \ chaw ua hauj lwm \ excel.exe" / s

Case 2. Thaum Excel ntaub ntawv no yog qhib

1. Sim ib yam txawv computer
2. Hloov tshem pib txuag.
3. Tua cov ntaub ntawv xyaum sib faib khoom xaiv
4. Tsis txhob khiav Excel los ntawm ib tug muag nthas
5. Txuag tau cov ntaub ntawv raws li ib tug web page thiab rov qhib nws raws li Excel ntaub ntawv.
6. Noj luaj li cas ntawm cov ntaub ntawv Excel
7. Rov qab mus rau qhov kawg version ntawm cov ntaub ntawv dim.

Precautionary tswv yim kom tsis txhob muaj mus zoo ua ntaub ntawv thov tau corrupted

• Xyuas kom system yog kaw cia kom zoo.
• Yuav nruab qhov tseeb anti-virus.
• Tsis phem sectors yuav tsum tau muaj nyob rau hauv lub cia ntaus ntawv.
• Yuav kaw Excel kom zoo.
• Tsis txhob loj loj cov ntaub ntawv tuav nrog Excel.