Compatibility hom hauv Excel. Ua hauj lwm nrog cov ntaub ntawv hauv Compatibility View

Cov khoos phis tawj tau hloov kho tas li, cov tshiab thiab txhim kho ntau dua tau tso tawm. Yog li, niaj hnub no, cov neeg siv tuaj yeem sim Excel-2019 program. Nrog rau kev txhim kho, kuj tseem muaj teeb meem xws li kev sib raug zoo, uas yog, cov ntaub ntawv tsim los ntawm ib lub computer yuav tsis qhib rau lwm qhov.

Dab tsi yog Compatibility Hom hauv Microsoft Excel

Qhov "Compatibility Mode" muaj nuj nqi yog cov txheej txheem uas tso cai rau koj los ua haujlwm nrog cov ntaub ntawv tsis hais lub version ntawm qhov program. Thov nco ntsoov tias qee qhov chaw thiab cov yam ntxwv yuav raug kaw lossis txwv. Piv txwv li, yog tias koj sim qhib ib daim ntawv nthuav qhia tsim hauv Excel 2000, tsuas yog cov lus txib uas muaj nyob rau hauv cov ntawv ntawd yuav muaj rau kev kho, txawm tias cov ntaub ntawv qhib hauv Excel 2016.

Cov haujlwm tsis ua haujlwm yuav raug tso tawm ntawm lub taskbar, tab sis lawv tsis tuaj yeem siv. Txhawm rau rov pib nkag mus rau tag nrho cov peev txheej ntawm Excel, koj yuav tsum xub hloov cov ntawv ua haujlwm uas tau xaiv rau qhov tsim nyog, tsim nyog dua. Tab sis yog tias ua hauj lwm ntxiv nrog rau cov ntaub ntawv ntawm cov versions tsis siv lawm, ces nws yog qhov zoo dua kom tsis txhob hloov pauv.

Yog vim li cas koj xav tau hom compatibility

Thawj qhov kev ua haujlwm ntawm Excel tau tshaj tawm hauv xyoo 1985. Qhov hloov tshiab tshaj plaws thoob ntiaj teb tau tso tawm xyoo 2007. Ntau tus lej ntawm cov txiaj ntsig zoo thiab muaj peev xwm tau tshwm sim rau cov qauv tshiab. Yog li, es tsis txhob ntawm .xls ib txwm txuas ntxiv, .xlsx yog tam sim no ntxiv rau cov ntaub ntawv npe.

Tus tshiab version ua tau zoo heev ntawm kev ua hauj lwm thiab kho cov ntaub ntawv tsim nyob rau hauv yav dhau los versions ntawm Excel. Hmoov tsis zoo, rov qab compatibility tsis zoo li. Hauv qhov no, cov ntaub ntawv nrog .xlsx txuas ntxiv yuav tsis qhib yog, piv txwv li, ib qho version ntawm Excel 2000 tau teeb tsa hauv lub computer.

Nws kuj tseem muaj peev xwm hais tias cov ntaub ntawv khaws tseg hauv Excel 2000 tau hloov kho hauv Excel 2016 thiab tom qab ntawd rov qhib dua hauv qhov kev pab cuam qub, qhov twg qee qhov kev hloov pauv yuav tsis tshwm sim lossis cov ntaub ntawv yuav tsis muaj txhua.

Nws yog rau cov kev xaiv uas muaj ib tug txo functionality los yog compatibility hom. Lub ntsiab ntawm hom yog muab lub peev xwm los ua hauj lwm nrog cov ntaub ntawv nyob rau hauv txawv versions ntawm qhov kev pab cuam, tab sis nrog preservation ntawm functionality ntawm thawj version ntawm Excel..

Cov teeb meem kev sib raug zoo

Qhov teeb meem tseem ceeb nrog Compatibility Hom hauv Excel yog tias nws tau txais kev tso cai. Qhov no ua kom cov ntaub ntawv khaws cia thaum hloov cov ntaub ntawv los ntawm ib lub computer mus rau lwm qhov. Ua tsaug rau qhov no, koj yuav tsum tsis txhob ntshai tias tom qab kho cov ntaub ntawv yuav tsis qhib lossis yuav puas.

Несовместимость может привести к незначительной потере точности или к довольно сунестовенной утрат. Например, в новых версиях больше стилей, параметров и даже функций. Piv txwv li, nyob rau hauv Excel 2010 появилась функция AGGREGATE, которая недоступна в устаревших версиях.

Koj tuaj yeem txheeb xyuas cov teeb meem sib raug zoo thaum siv Excel-2010 lossis Excel-2013. Txhawm rau ua qhov no, mus rau "Cov Ntaub Ntawv" cov ntawv qhia zaub mov, hauv "Cov Ntaub Ntawv" parameter, qhib lub pob "Xaiv cov teeb meem", tom qab ntawd xaiv "Xaiv qhov sib xws". Tom qab cov kev hloov pauv no, Excel yuav txheeb xyuas cov ntaub ntawv, muab cov lus qhia ntxaws ntxaws ntawm txhua qhov teeb meem nrog "Nrhiav" txuas, thaum koj nyem rau ntawm nws, cov teeb meem hlwb yuav tshwm sim.

Hom kev qhib

Koj tsis tas yuav ua dab tsi los pib Compatibility Hom. Raws li txoj cai, qhov kev zov me nyuam yuav paub txog tus kheej ntawm cov ntawv uas tau txais kev cawmdim thiab, yog tias tsim nyog, cia li ua kom txo qis kev ua haujlwm. Koj tuaj yeem pom tias hom yog qhib los ntawm header ntawm lub qhov rais qhib cov ntaub ntawv. Cov lus "Compatibility Mode" yuav tshwm nyob rau hauv kab lus ntawm ib sab ntawm cov ntaub ntawv npe. Raws li txoj cai, cov ntawv sau zoo li no tshwm sim thaum ua haujlwm nrog cov ntaub ntawv khaws tseg hauv Excel ua ntej version 2003, uas yog, ua ntej qhov tshwm sim ntawm .xlsx hom.

Hom deactivated

Tsis tas li nyob rau hauv txo functionality yog tsim nyog. Piv txwv li, ua haujlwm ntawm cov ntaub ntawv qub yuav txuas ntxiv hauv Excel tshiab thiab yuav tsis rov xa mus rau lwm lub computer.

1. Txhawm rau deactivate, koj yuav tsum mus rau lub tab hu ua "File". Nyob rau hauv lub qhov rais no, nyob rau sab xis, xaiv lub thaiv hu ua "Restricted functionality mode". Nyem qhov "Hloov" khawm.

2. Lub qhov rais yuav tshwm sim qhia koj tias phau ntawv ua haujlwm tshiab yuav raug tsim uas yuav khaws tag nrho cov yam ntxwv thiab cov khoom ntawm Excel niaj hnub version. Thaum lub sij hawm tsim ib phau ntawv Excel tshiab, cov ntaub ntawv qub yuav raug muab tshem tawm. Tsis txhob khuv xim nws - nyem "OK".

3. Tom qab ib pliag, lub qhov rais nrog cov ntaub ntawv "Kev hloov pauv tiav" yuav tshwm sim. Txhawm rau txuag txhua qhov kev hloov pauv thiab lov tes taw hom kev sib raug zoo, daim ntawv yuav tsum tau rov pib dua.

Tom qab rov qhib cov ntaub ntawv hloov dua siab tshiab, tag nrho cov kev xaiv muaj yuav ua haujlwm.

Compatibility hom thaum tsim cov ntaub ntawv tshiab

Raws li tau hais dhau los, thaum koj qhib cov ntaub ntawv hauv cov ntawv tshiab ntawm Excel, Cov Hom Sib Haum tau qhib. Tab sis hom no tseem tuaj yeem qhib tau yog tias autosave tau teeb tsa rau .xls cov ntaub ntawv, uas yog, txuag hauv versions 97-2003. Txhawm rau kho qhov teeb meem no thiab siv tag nrho cov haujlwm ntawm qhov kev zov me nyuam thaum ua haujlwm nrog cov ntxhuav, koj yuav tsum teeb tsa cov ntaub ntawv khaws cia hauv hom ntawv tsim nyog .xlsx.

1. Mus rau "Cov ntaub ntawv" zaub mov, qhib qhov "Options" seem.

2. Hauv "Txuag" parameter, xaiv "Txuag phau ntawv" chaw. Lub neej ntawd tus nqi ntawm no yog Excel 97-2003 Workbook (*.xls). Hloov tus nqi no mus rau lwm hom "Excel Book (*.xlsx)". Txhawm rau txuag cov kev hloov pauv, nyem "OK".

Tam sim no tag nrho cov ntaub ntawv Excel yuav raug tsim thiab khaws cia rau hauv cov hom kom raug yam tsis muaj kev ua kom muaj kev sib haum xeeb. Ua tsaug rau qhov no, tam sim no koj tuaj yeem ua haujlwm nrog txhua yam ntawm Excel yam tsis muaj kev txhawj xeeb txog kev poob cov ntaub ntawv lossis cuam tshuam cov txiaj ntsig thiab kev suav. Nyob rau tib lub sijhawm, yog tias tsim nyog, hom tuaj yeem raug muab tua, uas tso cai rau koj ua haujlwm nrog cov ntaub ntawv siv tag nrho cov yam ntxwv niaj hnub ntawm qhov program.

Txuag nyob rau hauv txoj cai hom

Muaj lwm txoj hauv kev los tua cov kev ua haujlwm txo qis kom ua haujlwm ntxiv hauv Excel tshiab. Nws yog txaus kom txuag tau cov ntaub ntawv nyob rau hauv ib tug txawv hom ntawv.

1. Mus rau qhov kev xaiv hu ua "Save As", uas tuaj yeem pom hauv "Cov Ntaub Ntawv" tab.

2. Nyob rau hauv lub qhov rai uas tshwm, nyem lub pob "Xaiv" khawm.
3. Lub qhov rais rau txuag cov ntaub ntawv yuav tshwm sim. Hauv qeb "Cov ntaub ntawv" xaiv "Excel workbook (.xlsx). Feem ntau, qhov kev xaiv no yog nyob rau sab saum toj ntawm daim ntawv teev npe.

4. Hauv kab "Cov ntaub ntawv npe" peb sau lub npe ntawm cov ntaub ntawv thiab nyem "Txuag".
5. Tom qab txuag, cov ntawv sau nyob rau hauv header ntawm cov ntaub ntawv "Compatibility Mode" tseem nyob, tab sis qhov no tsis txhais hais tias nws yog active. Cov xwm txheej ntawm phau ntawv tsis hloov thaum txuag, yog li nws tsuas yog txiav txim siab thaum cov ntaub ntawv rov pib dua.

Tom qab kaw cov ntaub ntawv thiab rov qhib nws, cov ntawv sau hais tias hom kev sib raug zoo tau qhib yuav ploj mus, thiab tag nrho cov haujlwm thiab cov khoom ntawm qhov kev zov me nyuam yuav npaj siv.

Ua tib zoo mloog! Thaum koj khaws ib daim ntawv nyob rau hauv ib hom ntawv, ib daim ntawv tshiab yog tsim. Tam sim no yuav muaj ob daim ntawv Excel hauv daim nplaub tshev nrog tib lub npe, tab sis txawv txuas ntxiv (hom ntawv).

Hloov ntaub ntawv

Rau kev ua haujlwm puv ntoob hauv Excel, koj tuaj yeem siv cov ntaub ntawv hloov dua siab tshiab.

1. Qhib lub "Hloov" icon nyob rau hauv "Cov ntaub ntawv" ntawv qhia zaub mov.
2. Cov lus ceeb toom yuav tshwm sim tias cov ntaub ntawv tam sim no yuav raug hloov dua siab tshiab, uas yog, yoog raws li cov qauv ntawm cov teeb tsa ntawm Excel. Thov nco ntsoov tias raws li qhov tshwm sim ntawm kev hloov dua siab tshiab, cov ntaub ntawv qub yuav raug hloov pauv yam tsis muaj peev xwm rov qab tau.
3. Hauv qhov rai ceeb toom, nyem "OK".
4. Tom qab ntawd, cov lus hais txog cov txiaj ntsig ntawm kev hloov dua siab tshiab yuav tshwm sim. Nyob rau hauv tib lub qhov rais, muaj ib lub tswv yim los kaw cov lus no thiab qhib ib tug twb tshiab ntaub ntawv. Peb pom zoo - nyem "OK".

Hauv cov ntaub ntawv qhib, tag nrho cov cuab yeej Excel tam sim no nyob rau hauv hom nquag, lawv tuaj yeem siv los kho thiab txuag cov ntaub ntawv.

Phau ntawv hloov dua siab tshiab

Kuj tseem muaj txoj hauv kev los hloov phau ntawv ua haujlwm Excel kom siv tag nrho cov haujlwm ntawm qhov program. Rau lub hom phiaj no, nws yog ib qhov tsim nyog los hloov cov ntaub ntawv hom ntawv mus rau qhov tsim nyog version.

1. Qhib "Cov ntaub ntawv" tab.
2. Ntawm no peb xaiv "Hloov" hais kom ua.
3. Hauv qhov rai pop-up, nyem "OK" kom paub meej tias cov ntaub ntawv hloov pauv.
4. Raws li qhov tshwm sim ntawm cov haujlwm no, Excel phau ntawv ua haujlwm tam sim no yuav ua haujlwm hauv hom ntawv xav tau. Qhov no disables hom compatibility.

Tseem ceeb! Thaum lub sij hawm hloov dua siab tshiab, thawj cov ntaub ntawv loj yuav hloov.

Kawm ntxiv txog Compatibility Hom hauv Excel

Hauv cov rooj sab laj, koj tuaj yeem nrhiav cov lus nug ntsig txog qhov tsis muaj peev xwm ntawm Excel. Yog li, thaum koj qhib ib daim ntawv, cov lus "Compatibility hom" tshwm nyob ib sab ntawm lub npe. Yog vim li cas rau qhov no tej zaum yuav yog ib tug mismatch ntawm Excel versions thaum tsim ib cov ntaub ntawv thiab nyob rau hauv tus txheej txheem ntawm kho nws. Yog tias lub rooj tau tsim hauv Excel-2003, tom qab ntawd thaum hloov cov ntaub ntawv mus rau lub computer nrog Excel-2007, nws yuav nyuaj heev los kho cov ntxhuav. Muaj ntau txoj hauv kev kom tawm ntawm qhov xwm txheej no:

1. Пересохранение документа в формате .xlsx.
2. Hloov cov ntaub ntawv mus rau Excel hom tshiab.
3. Deactivate compatibility hom rau kev ua hauj lwm ntxiv nrog cov ntaub ntawv.

Txhua qhov kev xaiv muaj nws qhov zoo thiab qhov tsis zoo. Qhov kev xaiv nyob ntawm qhov nyiam ntawm tus neeg siv thiab txoj hmoo yav tom ntej ntawm Excel daim ntawv nws tus kheej.

Kev qhia video

Rau kev nkag siab zoo dua ntawm qhov xav tau thiab cov hauv paus ntsiab lus ntawm hom kev sib raug zoo lossis kev ua haujlwm txo qis, koj tuaj yeem saib ob peb cov lus qhia video uas muaj dawb hauv YouTube video hosting. Nov yog qee qhov ntawm lawv:

Cov yeeb yaj kiab luv luv no muaj cov ntaub ntawv txaus kom nkag siab tias Compatibility Mode ua haujlwm li cas thiab yuav ua li cas tua nws.

xaus

Hom kev sib raug zoo hauv Excel cov ntaub ntawv yog qhov muaj txiaj ntsig zoo uas tso cai rau koj kom tshem tawm cov kev tsis sib haum xeeb thiab qhov tsis raug ntawm cov kev pab cuam ntawm cov khoos phis tawj sib txawv thaum ua cov ntaub ntawv tib yam hauv ntau hom kev pab cuam. Qhov kev ua haujlwm no ua rau nws tuaj yeem ua haujlwm nrog cov ntaub ntawv hauv ib qho chaw thev naus laus zis.

Hauv qhov no, tus neeg siv tuaj yeem lov tes taw hom kev sib raug zoo txhua lub sijhawm los nthuav cov software ua haujlwm. Txawm li cas los xij, koj yuav tsum paub txog qee qhov kev txwv ntsig txog cov teeb meem uas yuav tshwm sim thaum hloov cov ntaub ntawv mus rau lub khoos phis tawj nrog cov laus ntawm Excel.