Yuav ua li cas Kho Excel ntaub ntawv lub npe yog tsis Valid yuam kev

Qhov no yog heev rau cov neeg siv kev soj ntsuam txog nrog Excel ntaub ntawv mus ntsib tau ib yam ntawm ntau hom ntawm tsis. Feem ntau ib qho yuam kev hais txog qhib ib lub uas twb muaj lawm zoo cov ntaub ntawv (uas txhais tau tias ib qho teeb meem nyob rau hauv tus txheejtxheem qhov xav excel ntaub ntawv), los sis txog txuag ib cov ntaub ntawv los yog zoo daim ntawv (spreadsheet) tshwm sim. Muaj ob peb tau yog vim li cas rau cov uas tsis, thiab coj pab tej yam uas yuav pab tau daws tej teeb meem.

• Part 1: Qhov zoo tshaj plaws Excel ntaub ntawv Kho Tool
• Part 2: Yuav ua li cas Kho ncaj Excel ntaub ntawv
• Part 3: Kho Excel Nrog 'Qhib thiab Kho' feature
• Part 4: Yuav ua li cas kom tsis txhob muaj Excel ntaub ntawv tau ncaj

Ib qho yuam kev thiab loj zoo xws li cov nyob rau hauv cov xwm tshwm li tog twg los ntawm cov nram qab no cov lus:

• Cov ntaub ntawv npe siv tsis tau
• Cov ntaub ntawv yuav tsis tsum accessed.
• Txoj kev uas koj nkag mus hauv, '<filename>', yog dhau lawm ntev.
• <Filename> yuav tsis tsum pom.
• '<Filename>. <Extension>' yuav tsis tsum pom (pom nyob rau hauv Excel 2000).

'Ntaub ntawv lub npe yog tsis siv tau': thaum tsim thiab txuag, los yog qhib ib lub Excel ntaub ntawv xws yuam kev tej zaum yuav txhais tau li cas ib tug ntawm cov nram qab no yog vim li cas:

1. Kab ntawm cov ntaub ntawv xws li cov ntaub ntawv npe yuav ntau tshaj 218 tus naj npawb ntawm cov cim txwv
2. Cov ntaub ntawv npe tej zaum yuav tsis yog
3. Kev tej zaum yuav tsis tsim nyog
4. Cov ntaub ntawv chaw nyob los yog tsav tej zaum yuav tsis tau raug muab
5. Txwv ntawm cov cim nyob rau hauv lub npe ntawm nplaub tshev
6. Backslash ntawm folders
7. Cim nyob rau hauv cov ntaub ntawv npe
8. Cov ntaub ntawv npe tej zaum yuav muaj tseeb tab sis tau renamed los yog tsiv mus nyob rau lwm qhov chaw los yog tau accidently deleted.

Cov teeb meem nyob rau hauv kev tsim ib qhov txuas mus rau lwm lub excel ntaub ntawv tshwm sim los ntawm cov kev txwv ntawm 256 cim. Whereas 218 cim txwv rau defining txoj kev yog raws li raws li:

• Excel ntawv lub npe, nyiaj pab ntau tshaj 31 cim.
• Nkhaus thiab Apostrophes yog siv los qhia tias phau npe.
• Ib tug exclamation kos npe rau.
• Reference ntawm lub cell.

Qhov no qhov teeb meem yog, txawm li cas los, tej yam yooj yim mus rau raws li ib tug tej zaum yuav yog rename ntaub ntawv los sis nplaub tshev siv ib tug luv luv lub npe (tsis tshaj 218 cim) los yog mus rau cov ntaub ntawv mus rau ib tug luv luv lub npe nplaub tshev. Tab sis qhov teeb meem tshwm sim thaum mus zoo ua ntaub ntawv thov tau corrupted los yog puas ntsoog.

Part 1: Qhov zoo tshaj plaws Excel ntaub ntawv Kho Tool

Yuav kom kho corrupted Excel ntaub ntawv ntau Excel kho yam cuab yeej thiab Excel ntaub ntawv kho software yog muaj nyob rau. Stellar Excel Kho Tool tau ko tsis xws li "tsis tau nyeem cov ntaub ntawv" los yog "cov ntaub ntawv yog corrupt thiab tsis tau muab qhib". Nws tau ko tag nrho cov Excel versions tab sis mus txog Excel 2003. txhawb tag nrho cov XLS versions.

Part 2: Yuav ua li cas Kho ncaj Excel ntaub ntawv

Tom qab ib theem zuj zus ntawm kev tshuaj ntsuam qhia (rau Yeej xwb) nrawm pab tsiv mus kauj ruam yog kauj ruam kho thiab recovering Excel ntaub ntawv uas yog corrupted los yog puas ntsoog. Xaiv rau Mac piv tej zaum yuav siv tau.

Kauj ruam 1 Launch Excel ntaub ntawv kho , thiab xaiv corrupt Excel ntaub ntawv los ntawm lub zos tsav thiab nrhiav.

Kauj ruam 2 Nyob rau hauv lub tshawb nrhiav tshwm sim seem tso saib tag nrho cov corrupt Excel ntaub ntawv, xaiv ib tug los yog tag nrho pib kho cov txheej txheem

Kauj ruam 3 Previewing lub kho cov ntaub ntawv xaiv los ntawm sab laug bar.

Kauj ruam 4 Txuag kho Excel ntaub ntawv mus rau ib tug lo lus uas peb qhov chaw.

Part 3: Kho Excel Nrog 'Qhib thiab Kho' feature

MS Excel nta pab txhawb ib qho tsis siv neeg rov qab txoj kev nyob rau hauv rooj plaub no nws ntes ib tug corrupted Excel ntaub ntawv. Txawm li cas los, Yog hais tias hom rov qab tsis pib neeg siv yuav sim rov qab manually raws li qhia hauv qab no.

Kauj ruam 1. Nyem ntaub ntawv> Qhib.

Kauj ruam 2. Nyem nplaub tshev uas muaj cuam tshuam ntawv, thiab qhov chaw

Kauj Ruam 3. Xaiv nyob rau hauv dialog box lub corrupted ntaub ntawv

Kauj ruam 4. Xovxwm xub nyob ze qhib khawm

Kauj ruam 5. Nyem qhib & kho raws li tseem ceeb ntawm no.

Lub tswv yim:

Sib nrug los ntawm kev siv lub thib peb tog Excel Kho Tool los yog Excel ntaub ntawv kho software, ib tug ob peb lub tswv yim yuav pab tau tus neeg siv yuav rov qab los yog kev kho corrupted Excel ntaub ntawv.

Case 1. Yog hais tias Excel yuav tsis qhib cov ntaub ntawv sim nram qab no kom daws tau qhov teeb meem koj tus kheej.

1. Luam corrupt cov ntaub ntawv rau koj nyuaj-tsav hais tias nws tau tshwm sim rau muag nthas.
2. Sim nrhiav .xlb ntaub ntawv kom ib tug thaub qab kom zoo. Tam sim no rho tawm .xlb thiab pib dua Excel.
3. Sim qhib cov ntaub ntawv nyob rau hauv MS lo lus los yog Notepad uas tej zaum yuav qhia rau koj rov qab cov ntaub ntawv, tiam sis tsis formatting.
4. MS Excel 97/2000 tuav tej zaum yuav qhia rau koj saib cov ntaub ntawv thiab cov ntawv luam. Qhib ntaub ntawv uas siv pub dawb no pab cuam rov qab cov ntaub ntawv. Qhov kev pab no tej zaum yuav rov qab txawm formatting raws li cell qhov tseem ceeb.
5. Siv Excel XP uas muaj kev zoo dua qub rau rov qab.

Case 2. Yog hais tias Excel ntaub ntawv no yog qhib zaug nram qab no kom daws tau qhov teeb meem koj tus kheej.

1. Sim ib yam txawv computer
2. Tsis txhob khiav Excel los ntawm ib tug muag nthas
3. Hloov tshem pib txuag
4. Tua cov ntaub ntawv xyaum sib faib khoom xaiv
5. Txuag tau cov ntaub ntawv raws li ib tug web page thiab rov qhib nws raws li Excel ntaub ntawv.

Part 4: Yuav ua li cas kom tsis txhob muaj Excel ntaub ntawv tau ncaj

• Xyuas kom system yog kaw cia kom zoo. Rau qhov teeb meem kaw tag nrho cov daim ntawv thov ua ntej kaw cia. Txawm li cas los, vim muaj tshwm sim lawm tsis muaj neeg tswj zoo li tam sim ntawd disconnection ntawm lub hwj huam mov tej zaum yuav ua cov ntaub ntawv kev noj nyiaj txiag vim kev kaw ntawm daim ntaub ntawv.
• Sim rau nruab qhov tseeb anti-virus kom koj tshuab pub dawb los ntawm siab phem tawm tsam. Kab mob yeej ib txwm ua tau zoo ua ntaub ntawv thov raug rau kev noj nyiaj txiag
• Sim ua kom koj qhov chaw cia li ntau li ntau tau tej kev phem kev sector txoj kev zoo ua ntaub ntawv thov kev noj nyiaj txiag muaj yog tias cov ntaub ntawv yog rua ntawm ib tug phem sector.
• Sim txheeb tawm tej teeb meem tam sim no nyob rau hauv MS Excel daim ntawv thov. Kev thiab npaj txhij txog shutting ntawm excel ntawv ua ntaub ntawv kev noj nyiaj txiag.
• Sim lis me me cov ntaub ntawv thaum uas soj ntsuam txog excel cov ntaub ntawv. Enormous cov ntaub ntawv nyob rau hauv excel ntawv yog ib leading ua cov ntaub ntawv kev noj nyiaj txiag.