Muab ob daig duab hauv Microsoft Word

Kev tsis ua haujlwm rau kev qhib lub Excel workbook tsis yog li ntawd, tab sis, txawm li ntawd los, lawv kuj tshwm sim. Cov teeb meem zoo li no tuaj yeem tshwm sim los ntawm kev puas tsuaj rau cov ntaub ntawv, thiab kev ua yuam kev ntawm qhov kev pab cuam lossis txawm lub qhov rais system ua ke. Cia peb sim xyuas qhov teeb meem ntawm cov teeb meem nrog qhib cov ntaub ntawv, thiab kuj pom tias yuav kho qhov teeb meem li cas.

Ua rau thiab daws teeb meem

Raws li nyob rau lwm lub sij hawm muaj teeb meem, kev tshawb nrhiav ib txoj kev tawm ntawm qhov teeb meem thaum qhib phau ntawv Excel, lus dag hauv qhov ua rau nws tshwm sim. Yog li no, ua ntej txhua yam, nws tsim nyog los tsim kom muaj cov xwm txheej uas ua rau muaj kev tsis txaus siab ntawm daim ntawv thov.

Kom nkag siab txog hauv paus ua: nyob rau hauv cov ntaub ntawv nws tus kheej los yog hauv cov teeb meem software, sim qhib lwm cov ntaub ntawv hauv tib daim ntawv thov. Yog hais tias lawv qhib, nws muaj peev xwm yuav xaus lus tias lub hauv paus ua rau qhov teeb meem puas tsuaj rau phau ntawv. Yog hais tias tus neeg siv tsis qhib txawm tias, ces qhov teeb meem nyob rau hauv cov teeb meem nrog Excel los yog lub operating system. Koj tuaj yeem ua nws txawv: sim qhib phau ntawv teeb meem ntawm lwm lub tshuab. Hauv qhov no, nws qhov kev vam meej yuav pom tias txhua yam yog los ntawm daim ntawv, thiab cov teeb meem yuav tsum tau ntsia rau hauv ib txoj kev sib txawv.

Taw qhia 1: Cov teeb meem sib thooj

Qhov feem ntau ua rau tsis ua hauj lwm thaum qhib ib qho Excel workbook, yog tias nws tsis dag hauv kev puas tsuaj ntawm daim ntawv nws tus kheej, nws yog ib qhov teeb meem sib xws. Nws tsis yog tshwm sim los ntawm software tsis ua hauj lwm, tab sis thaum siv lub qub version ntawm qhov kev pab cuam rau qhib cov ntaub ntawv uas tau ua nyob rau hauv ib qho newer version. Nyob rau tib lub sijhawm, nws yuav tsum raug sau tseg tias tsis yog txhua daim ntawv tau ua nyob rau hauv phau ntawv tshiab yuav muaj teeb meem qhib rau hauv cov ntawv thov dhau los. Tiam sis, feem ntau lawv yuav pib dua txhua zaus. Tsuas yog qhov tshwj xeeb tshaj yog cov uas cov technologies tau nkag tau hais tias cov qub versions of Excel tsis ua hauj lwm nrog. Piv txwv, thaum ntxov ntawm cov lus hauv no cov lus teb yuav tsis ua haujlwm nrog cov neeg ua pov thawj. Yog li, daim ntawv thov qub yuav tsis muaj peev xwm qhib phau ntawv uas muaj lub caij no, tab sis nws yuav tso tawm feem ntau ntawm lwm cov ntaub ntawv tsim nyob rau hauv phau ntawv tshiab.

Nyob rau hauv cov ntaub ntawv no, yuav muaj ob txoj hauv kev daws teeb meem: qhib cov ntaub ntawv zoo sib xws rau lwm cov computers nrog software tshiab, lossis nruab ib lub tshiab versions of Microsoft Office rau problematic PC tsis txhob outdated.

Tsis muaj dab tsi cuam tshuam thaum qhib qhib cov ntaub ntawv tsim nyob rau hauv lub qub versions ntawm daim ntawv thov nyob rau hauv qhov kev pab cuam tshiab. Yog li, yog tias koj muaj qhov tseeb version of Excel ntsia, ces tsis muaj teeb meem muaj teeb meem ntsig txog kev ywj pheej thaum qhib cov ntaub ntawv ntawm cov kev pab cuam dhau los.

Nyias, nws yuav tsum tau hais txog xlsx hom ntawv. Qhov tseeb yog tias nws yog pib tsuas yog pib los ntawm Excel 2007. Tag nrho cov kev siv yav dhau los tsis tuaj yeem ua haujlwm nrog nws los ntawm vim, vim hais tias lawv yog "hom" hom ntawv xls. Tab sis qhov no, qhov teeb meem nrog kev tso tawm ntawm hom ntawv no yuav daws tau txawm tias tsis tau muab kho dua tshiab rau daim ntawv thov. Qhov no yuav ua tau los ntawm kev txhim kho ib qho tshwj xeeb ntawm Microsoft los ntawm lub qub version ntawm qhov kev zov me nyuam. Tom qab qhov no, cov phau ntawv nrog xlsx yuav qhib tau txhua zaus.

Nrig ib thaj

Reason 2: tsis muaj nqis

Qee lub sij hawm qhov teeb meem thaum qhib ib daim ntawv tuaj yeem yog qhov tsis muaj tseeb ntawm kev teeb tsa ntawm qhov kev pab cuam nws tus kheej. Piv txwv, thaum koj sim qhib cov phau ntawv Excel los ntawm ob npaug rau sab laug nas khawm, cov lus hauv qab no yuav tshwm sim: "Yuam kev thaum xa ib lo lus txib rau ib daim ntawv thov".

Qhov no yuav tso tawm daim ntawv thov, tab sis phau ntawv xaiv tsa yuav tsis qhib. Nyob rau tib lub sij hawm los ntawm tab "Cov Ntaub Ntawv" nyob rau hauv qhov kev pab cuam nws tus kheej, daim ntawv qhib txhua zaus.

Feem ntau, qhov teeb meem no tuaj yeem daws tau raws li hauv qab no.

1. Mus rau lub tab "Cov Ntaub Ntawv". Tom qab, txav mus rau seem "Kev xaiv".



2. Tom qab lub qhov rai tsis tau qhib, nyob hauv nws sab laug mus rau ntawm qhov subsection "Qib Siab". Nyob rau sab xis ntawm lub qhov rais peb tab tom nrhiav rau ib pawg ntawm cov chaw. "General". Nws yuav tsum muaj ib qho parameter "Ignore DDE kev thov los ntawm lwm cov kev siv". Nws yuav tsum tsis xyuas yog tias nws kos. Tom qab ntawd, kom txuag tau qhov teeb meem tam sim no, nias ntawm lub pob "OK" nyob rau hauv qab ntawm lub qhov rais kom nquag plias.

Tom qab ua tiav cov haujlwm no, ib ob-nias sim qhib daim ntawv yuav tsum ua kom tiav tiav.

Vim li cas 3: Configure Mappings

Yog vim li cas koj tsis tuaj yeem ua nws ib txoj hauv kev, uas yog, los ntawm ob npuaj nias ntawm pob nyem khawm, qhib cov ntaub ntawv Excel, los ntawm cov ntaub ntawv tsis raug cai. Ib qho kos npe ntawm qhov no yog, piv txwv li, kev sim muab cov ntaub ntawv tso rau lwm daim ntawv thov. Tab sis qhov teeb meem no kuj muaj peev xwm daws tau yooj yim.

1. Los ntawm cov ntawv qhia zaub mov Pib mus rau Tswj vaj huam sib luag.



2. Tom qab, txav mus rau seem "Cov kev pab cuam".



3. Hauv daim ntawv thov qhov rais qhib qhov rooj, mus hauv qhov khoom "Lub hom phiaj ntawm qhov kev pab cuam qhib cov ntaub ntawv ntawm hom no".



4. Tom qab ntawd, ib daim ntawv yuav tsim los ntawm ntau hom kev tawm tswv yim uas cov ntawv thov qhib rau lawv tau teev tseg. Peb tab tom nrhiav nyob rau hauv daim ntawv no extensions Excel xls, xlsx, xlsb lossis lwm tus uas yuav tsum qhib rau hauv lub program no, tab sis tsis qhib. Thaum koj xaiv txhua yam ntawm cov kev txuas ntxiv rau saum toj ntawm lub rooj yuav tsum yog Microsoft Excel lub npe. Qhov no txhais tau hais tias qhov chaw ntaus ntawv yeej muaj tseeb.

   

   Tab sis, yog tias lwm daim ntawv teev npe thaum sau cov ntaub ntawv raug Excel, qhov no qhia tau hais tias tus txheej txheem tau teeb tsa tsis raug. Txhim kho cov nqis ntawm lub pob "Hloov cov kev pab cuam" nyob rau sab xis sab ntawm lub qhov rais.



5. Feem ntau hauv qhov rais "Kev Xaiv Tsa" Excel lub npe yuav tsum yog cov pab pawg neeg pom zoo. Hauv qhov no, tsuas xaiv lub npe ntawm daim ntawv thov thiab nyem rau ntawm lub pob "OK".

   

   Tab sis, yog vim muaj qee qhov xwm txheej nws tsis nyob hauv daim ntawv, ces qhov no nias rau ntawm lub pob "Ntsuam xyuas ...".



6. Tom qab qhov no, qhov kev qhib qhov rais qhib hauv qhov koj yuav tsum qhia kom meej txog txoj kev mus rau Excel cov ntaub ntawv ncaj qha. Nws nyob hauv daim nplaub tshev ntawm qhov chaw nyob hauv qab no:

   C: Cov ntaub ntawv Microsoft Office Office

   Siv lub cim "Tsis tau" koj yuav tsum qhia tus naj npawb ntawm koj lub Microsoft Office pob. Cov xov xwm ntawm Excel versions thiab Cov Chaw Ua Hauj Lwm cov xov tooj muaj raws li nram no:

   • Excel 2007 - 12;
   • Excel 2010 - 14;
   • Excel 2013 - 15;
   • Excel 2016 - 16.

   Thaum twg koj tau tsiv mus rau qhov ceev tseg, xaiv cov ntaub ntawv EXCEL.EXE (Yog hais tias tsis pom ntxiv, nws yuav raug hu ib tsab EXCEL). Nias lub pob "Qhib".



7. Tom qab no, koj rov qab mus rau qhov kev xaiv xaiv qhov rais, qhov twg koj yuav tsum xaiv lub npe "Microsoft Excel" thiab nias lub pob "OK".



8. Tom qab ntawd daim ntawv thov yuav raug xa rov qab qhib lub hom ntaub ntawv xaiv. Yog tias ob lub Excel txuas ntxiv muaj qhov tsis yog, koj yuav tau ua cov txheej txheem saum toj no rau txhua tus nyias muaj nyias. Tom qab tsis muaj cov mappings tsis meej lawm ua kom tiav ua haujlwm nrog lub qhov rai, nias ntawm lub pob "Kaw".

Tom qab ntawd, Cov phau ntawv Excel yuav tsum qhib kom raug.

Vim li cas 4: ntxiv-ons tsis ua hauj lwm zoo.

Ib qho ntawm cov txheej xwm seb vim li cas ib qho Excel workbook tsis pib yuav tsis ua haujlwm ntawm kev ntxiv, uas sib cuam tshuam nrog ib leeg lossis nrog lub system. Hauv qhov no, txoj kev tawm yog lov tes taw qhov tsis ntxiv.

1. Raws li hauv txoj kev thib ob los daws qhov teeb meem los ntawm tab "Cov Ntaub Ntawv", mus rau qhov tsis muaj qhov rai. Muaj peb tsiv mus rau seem Ntxiv-ons. Hauv qab ntawm qhov rais yog ib daim teb "Kev Tswj". Nias rau nws thiab xaiv qhov parameter COM Ntxiv rau hauv. Peb nias lub khawm "Mus ...".



2. Nyob rau hauv lub qhov rais qhib ntawm daim ntawv teev cov add-ons peb tshem tawm cov checkboxes los ntawm tag nrho cov ntsiab. Peb nias lub khawm "OK". Li ntawd, txhua yam ntxiv-so Com yuav tsis taus.



3. Peb sim qhib cov ntaub ntawv ua ob zaug. Yog hais tias nws tsis qhib, ces qhov teeb meem tsis yog nyob rau hauv ntxiv-ins, koj muaj peev xwm tig lawv tag nrho cov nyob rau hauv dua, tab sis saib rau yog vim li cas nyob rau hauv lwm. Yog hais tias daim ntawv qhib txhua zaus, ces qhov no tsuas yog txhais tau hais tias ib qho ntawm qhov sib ntxiv ntawm qhov tsis ua haujlwm tsis ua haujlwm. Txheeb xyuas ib qho twg, rov qab mus rau lub qhov rais ntxiv, kos ib qho ntawm lawv thiab nias lub khawm "OK".



4. Saib xyuas cov ntaub ntawv qhib li cas. Yog hais tias txhua yam yog zoo, ces tig rau qhov thib ob add-on, thiab lwm yam., Txog thaum peb mus rau ib tug nrog cov xam nrog uas muaj teeb meem nrog lub qhib. Hauv qhov no, nws yuav tsum muab tua thiab tsis qhib rau, lossis zoo dua, los xaiv thiab nias qhov khawm tsim nyog. Tag nrho lwm qhov ntxiv, yog tias tsis muaj teeb meem hauv lawv txoj haujlwm, tuaj yeem ua tau.

Vim li cas 5: kho vajtse acceleration

Cov teeb meem uas qhib cov ntaub ntawv hauv Excel tuaj yeem tshwm sim tau thaum kho tau qhov kho vajtse acceleration. Txawm hais tias qhov zoo li no tsis tas muaj kev khuam siab rau cov ntaub ntawv qhib. Yog li, ua ntej txhua yam, koj yuav tsum tau xyuas seb nws yog qhov ua rau lossis tsis ua li cas.

1. Mus rau qhov kev paub xaiv Excel qhov rai hauv seem "Qib Siab". Nyob rau hauv txoj cai ntawm lub qhov rais peb tab tom nrhiav ib ntu ntawm chaw. "Npo". Nws muaj ib qho parameter "Lov tes taw Image kho acceleration". Teem ib lub checkbox pem lub taub hau nws thiab nyem rau ntawm lub pob. "OK".



2. Saib xyuas cov ntaub ntawv li cas. Yog hais tias lawv qhib nquag, ces tsis hloov cov chaw. Yog hais tias qhov teeb meem no tseem muaj ntxiv, koj tuaj yeem tig rau kev kho vajtse acceleration dua thiab tshawb nrhiav qhov teeb meem.

Vim li cas 6: kev puas tsuaj rau phau ntawv

Raws li hais dhau los, cov ntaub ntawv kuj yuav tsis qhib kuj vim tias nws puas lawm. Qhov no yuav qhia tau tias lwm cov ntawv hauv tib qho kev qhia ntawm qhov kev zov me nyuam yeej khiav tsis tu ncua. Yog tias koj qhib tsis tau cov ntaub ntawv no rau lwm lub tshuab, ces nrog kev ntseeg siab peb tuaj yeem hais tias yog vim li cas hauv nws tus kheej. Hauv qhov no, koj tuaj yeem sim rov qab tau cov ntaub ntawv.

1. Tua tawm Excel spreadsheet processor ntawm desktop shortcut lossis cov ntawv qhia zaub mov Pib. Mus rau lub tab "Cov Ntaub Ntawv" thiab nyem rau ntawm lub pob "Qhib".



2. Cov ntaub ntawv qhib qhov rai yog qhib. Nyob rau hauv nws koj yuav tsum mus rau hauv cov ntaub ntawv uas muaj qhov teeb meem daim ntawv nyob hauv. Xaiv nws. Tom qab ntawd nias ntawm lub cim nyob rau hauv daim ntawv ntawm ib daim duab peb sab ntawm ib sab ntawm lub pob "Qhib". Ib daim ntawv tshwm nyob rau hauv uas koj yuav tsum xaiv "Qhib thiab restore ...".



3. Ib lub qhov rai yog pib uas muaj ntau txoj hau kev xaiv los ntawm. Ua ntej, cia peb sim ua kom yooj yim. Yog li, nyem rau ntawm lub pob "Restore".



4. Txoj kev rov pib dua yog khiav. Nyob rau hauv rooj plaub ntawm nws txoj kev vam meej tiav, ib qhov ncauj lus qhib qhov rais, qhia txog nws. Nws tsuas xav tau lub pob nyem "Kaw". Tom qab ntawd, txuag cov ntaub ntawv khaws tseg rau hauv txoj kev li niaj zaus - los ntawm nias lub khawm hauv daim ntawv ntawm lub tshuab floppy nyob rau sab laug ntawm sab laug ntawm lub qhov rais.



5. Yog hais tias phau ntawv tsis tau tawm los rov qab rau hauv txoj kev no, ces peb rov qab mus rau qhov rai yav dhau los thiab nias rau khawm. "Tshem tawm cov ntaub ntawv".



6. Tom qab ntawd, lwm qhov rais qhib nyob rau hauv uas koj yuav tau txais kev tshoov siab kom hloov cov qauv hauv qhov tseem ceeb lossis rov qab rau lawv. Hauv thawj rooj plaub, tag nrho cov qauv hauv daim ntawv yuav ploj, thiab tsuas yog cov ntsiab lus ntawm cov lus teb yuav nyob. Nyob rau hauv qhov thib ob, ib qho kev sim yuav ua kom txuag tau cov kab zauv, tab sis tsis muaj kev vam meej tau zoo. Peb xaiv, tom qab uas, cov ntaub ntawv yuav tsum tau rov qab los.



7. Tom qab ntawd, txuag lawv raws li nyias muaj nyias cov ntaub ntawv los ntawm txhaj rau lub pob hauv daim ntawv ntawm lub tshuab floppy.

Muaj lwm txoj kev xaiv rau kev nrhiav cov ntaub ntawv los ntawm cov phau ntawv puas. Lawv tau sib tham nyob rau hauv ib lub ntsiab lus txawv.

Tshooj: Yuav ua li cas kho corrupt Excel ntaub ntawv

Vim li cas 7: Kev noj nyiaj txiag hauv kev puas tsuaj

Lwm qhov laj thawj yog vim li cas qhov kev zov me nyuam tuaj yeem tsis qhib cov ntaub ntawv yuav ua rau nws puas tsuaj. Hauv qhov no, koj yuav tsum tau sim rov qab muab dua. Txoj kev rov zoo li nram qab no tsuas yog tsim nyog yog tias koj muaj kev ruaj khov hauv internet.

1. Mus rau Tswj vaj huam sib luag los ntawm khawm Pibraws li yav tas los tau piav. Nyob rau hauv lub qhov rai uas tau qhib qhov khoom "Uninstall ib qhov kev pab cuam".



2. Lub qhov rais qhib nrog ib daim ntawv teev npe ntawm txhua daim ntaub ntawv ntsia hauv computer. Peb tab tom nrhiav ib yam khoom hauv nws "Microsoft Excel"xaiv qhov nkag thiab nias rau ntawm lub pob. "Hloov"nyob rau sab saum toj vaj huam sib luag.



3. Lub qhov rais rau hloov cov installation tam sim no opens. Muab tus tes hloov qhov chaw "Restore" thiab nyem rau ntawm lub pob "Ntxiv mus".



4. Tom qab ntawd, los ntawm kev txuas mus rau hauv Internet, daim ntawv thov yuav raug kho tshiab, thiab cov kev yuam yuav raug muab tshem tawm.

Yog tias koj tsis muaj qhov txuas hauv Internet los yog qee yam koj tsis tuaj yeem siv hom no, ces qhov no koj yuav tsum tau siv cov installation disk.

Vim li cas 8: teeb meem ntawm lub cev

Yog vim li cas rau cov tsis muaj peev xwm qhib cov ntaub ntawv Excel kuj qee zaum ua txoj kev ua txhaum nyob rau hauv qhov system. Hauv qhov no, koj yuav tsum tau ua tej yam ua kom rov qab kho qhov mob ntawm lub qhov rais operating system ua ke.

1. Ua ntej tshaj, luam theej koj lub computer nrog ib qho chaw ua haujlwm tiv thaiv kab mob. Nws yog ntshaw ua qhov no nrog lwm yam khoom siv uas tsis tau lav kom muaj tus kab mob. Nyob rau hauv cov ntaub ntawv ntawm nrhiav tej yam txawv cov khoom ua raws li lub tswv yim ntawm antivirus.



2. Yog hais tias kev tshawb nrhiav thiab tshem tawm kabmob tsis tsimnyog daws qhov teebmeem, ces sim rov qab rau lub cev kom txog thaum kawg rov los. Muaj tseeb, thiaj li yuav tau ua zoo dua ntawm lub sijhawm no, koj yuav tsum tsim nws ua ntej muaj teebmeem tshwm sim.



3. Yog hais tias cov no thiab lwm txoj kev daws teeb meem rau qhov teeb meem tsis tau muab cov txiaj ntsig zoo, ces koj tuaj yeem sim ua haujlwm ntawm kev rov nruab rau kev khiav haujlwm.

Tshooj: Yuav ua li cas los tsim lub qhov rais restore point

Raws li koj tau pom, qhov teeb meem nrog qhib Excel cov phau ntawv tuaj yeem tshwm sim los ntawm ntau yam. Lawv tuaj yeem them rau hauv cov ntaub ntawv kev noj nyiaj txiag, nrog rau cov chaw tsis muaj tseeb los yog cov teeb meem ntawm qhov kev pab cuam nws tus kheej. Qee zaum, qhov teebmeem kuj tseem yog qhov teeb meem ntawm qhov kev khiav hauj lwm. Yog li ntawd, los txhim kho tag nrho kev ua haujlwm tseem ceeb heev los txiav txim ntawm lub hauv paus ua.