Njira yofananira mu Excel. Kugwira ntchito ndi Documents mu Compatibility View

Mapulogalamu apakompyuta amasinthidwa nthawi zonse, matembenuzidwe atsopano ndi abwino kwambiri amatulutsidwa. Chifukwa chake, lero, ogwiritsa ntchito amatha kuyesa kale pulogalamu ya Excel-2019. Pamodzi ndi zosinthazi, palinso zovuta monga kuyanjana, ndiko kuti, chikalata chopangidwa pakompyuta imodzi sichingatsegulidwe pa china.

Kodi Compatibility Mode mu Microsoft Excel ndi chiyani

Ntchito ya "Compatibility Mode" ndi gulu lazigawo zomwe zimakulolani kuti mugwiritse ntchito zikalata mosasamala mtundu wa pulogalamuyo. Chonde dziwani kuti zosintha zina ndi zina zitha kuzimitsidwa kapena zochepa. Mwachitsanzo, ngati mutayesa kutsegula spreadsheet yopangidwa mu Excel 2000, malamulo okha omwe ali mumtunduwu ndi omwe angapezeke kuti asinthe, ngakhale chikalatacho chitsegulidwe mu Excel 2016.

Ntchito zosagwira zidzawonetsedwa pa taskbar, koma sizingagwiritsidwe ntchito. Kuti muyambirenso kupeza zonse zomwe zingatheke mu Excel, choyamba muyenera kutembenuza buku losankhidwa kukhala loyenera, loyenera. Koma ngati ntchito yowonjezereka ndi chikalatacho pamatembenuzidwe achikale akuyenera, ndiye kuti ndibwino kupeŵa kutembenuza.

Chifukwa chiyani mukufunikira mode yofananira

Mtundu woyamba wa Excel udayambitsidwa mu 1985. Kusintha kwapadziko lonse lapansi kudatulutsidwa mu 2007. Zambiri zothandiza ndi kuthekera zawonekera mpaka mawonekedwe atsopano. Kotero, m'malo mwachizoloŵezi chowonjezera cha .xls, .xlsx tsopano yawonjezedwa ku dzina lachikalata.

Mtundu watsopanowu umachita ntchito yabwino kwambiri yogwira ntchito ndikusintha zolemba zomwe zidapangidwa m'mitundu yam'mbuyomu ya Excel. Tsoka ilo, kuyanjana chakumbuyo sikuli kopambana. Pachifukwa ichi, zolemba zokhala ndi .xlsx zowonjezera sizingatseguke ngati, mwachitsanzo, mtundu wa Excel 2000 waikidwa pa kompyuta.

Ndizothekanso kuti chikalata chosungidwa mu Excel 2000 chinasinthidwa mu Excel 2016 ndipo pambuyo pake chinatsegulidwanso mu pulogalamu yachikale, momwemo zosintha zina sizingawonekere kapena fayilo silikupezeka konse.

Ndi zosankha zotere zomwe zimakhala ndi magwiridwe antchito kapena mawonekedwe ofanana. Chofunikira cha mawonekedwewa ndikupereka kuthekera kogwira ntchito ndi mafayilo mumitundu yosiyanasiyana ya pulogalamuyo, koma ndikusunga magwiridwe antchito a mtundu woyamba wa Excel..

Nkhani zogwirizana

Vuto lalikulu ndi Compatibility Mode mu Excel ndikuti imayatsidwa yokha. Izi zimatsimikizira kuti deta imasungidwa posamutsa mafayilo kuchokera pa kompyuta kupita ku ina. Chifukwa cha izi, musachite mantha kuti mutatha kusintha fayilo silidzatsegulidwa kapena lidzawonongeka.

Несовместимость может привести к незначительной потере точности или к довольно существенной утрате функциональности. Mwachitsanzo, mu новых версиях больше стилей, параметров ndi даже функций. Ndiko kuti, mwachitsanzo mu Excel 2010 poyaвилась функция AGGREGATE, которая недоступна mu устаревших версиях.

Mutha kuzindikira zovuta zomwe zingagwirizane mukamagwiritsa ntchito Excel-2010 kapena Excel-2013. Kuti muchite izi, pitani ku menyu ya "Fayilo", mu "Information" parameter, yambitsani batani la "Check for problems", kenako sankhani "Check compatibility". Pambuyo pa izi, Excel idzasanthula chikalatacho, ndikupereka lipoti latsatanetsatane pavuto lililonse ndi ulalo wa "Pezani", mukadina, ma cell amavuto adzawonetsedwa.

Kutsegula mode

Simufunikanso kuchita chilichonse kuti muyambitse Compatibility Mode. Monga lamulo, pulogalamuyo idzazindikira mwaokha mtundu womwe chikalatacho chimasungidwa ndipo, ngati kuli kofunikira, imathandizira kuti magwiridwe antchito achepetse. Mukhoza kupeza kuti akafuna adamulowetsa kuchokera pamutu wa lotseguka wapamwamba zenera. Uthenga "Compatibility Mode" udzawoneka m'mabokosi pafupi ndi dzina lachikalata. Monga lamulo, kulembedwa koteroko kumawonekera pogwira ntchito ndi mafayilo omwe anasungidwa mu Excel pamaso pa mtundu wa 2003, ndiko kuti, pamaso pa kubwera kwa mtundu wa .xlsx.

Kuletsa mode

Osati nthawi zonse mumayendedwe ocheperako ndikofunikira. Mwachitsanzo, ntchito pafayilo yoyambirira idzapitilira mu Excel yomwe yasinthidwa ndipo sidzatumizidwanso ku kompyuta ina.

1. Kuti mutsegule, muyenera kupita ku tabu yotchedwa "Fayilo". Pazenera ili, kumanja, sankhani chipika chotchedwa "Zoletsa magwiridwe antchito". Dinani batani "Convert".

2. Padzawoneka zenera lakudziwitsani kuti buku lantchito latsopano lidzapangidwa lomwe lidzasunga zonse ndi mawonekedwe amtundu wamakono wa Excel. Pakupanga buku latsopano la Excel, fayilo yakale idzachotsedwa. Osanong'oneza bondo - dinani "Chabwino".

3. Patapita kanthawi, zenera ndi mfundo "Kutembenuka anamaliza" adzaoneka. Kuti musunge zosintha zonse ndikuletsa mawonekedwe ofananira, chikalatacho chiyenera kuyambiranso.

Pambuyo potsegulanso fayilo yosinthidwa, zosankha zonse zomwe zilipo zidzakhala zogwira ntchito.

Compatibility mode popanga zikalata zatsopano

Monga tanena kale, mukatsegula fayilo m'mitundu yatsopano ya Excel, Compatibility Mode imatsegulidwa. Koma mawonekedwewa athanso kuyatsidwa ngati autosave yakhazikitsidwa ku mtundu wa fayilo wa .xls, ndiko kuti, kusunga mumitundu 97-2003. Kuti mukonze izi ndikugwiritsa ntchito ntchito zonse za pulogalamuyo mukamagwira ntchito ndi matebulo, muyenera kukonza zosunga fayilo mumtundu woyenera wa .xlsx.

1. Pitani ku "Fayilo" menyu, yambitsani gawo la "Zosankha".

2. Mu gawo la "Sungani", sankhani "Sungani mabuku". Mtengo wokhazikika pano ndi Excel 97-2003 Workbook (*.xls). Sinthani mtengowu kukhala mtundu wina "Excel Book (*.xlsx)". Kuti musunge zosintha, dinani "Chabwino".

Tsopano mafayilo onse a Excel apangidwa ndikusungidwa m'njira yoyenera popanda kuyambitsa Compatibility Mode. Chifukwa cha izi, tsopano mutha kugwira ntchito ndi mtundu uliwonse wa Excel osadandaula za kutaya deta kapena kusokoneza mawerengedwe ndi mawerengedwe ake. Panthawi imodzimodziyo, ngati kuli kofunikira, mawonekedwewo akhoza kuzimitsidwa, zomwe zimakulolani kuti mugwiritse ntchito chikalatacho pogwiritsa ntchito zinthu zonse zamakono za pulogalamuyi.

Sungani m'njira yoyenera

Palinso njira ina yozimitsa magwiridwe antchito kuti mupitirize kugwira ntchito mu mtundu watsopano wa Excel. Ndikokwanira kusunga fayilo mumtundu wina.

1. Pitani ku njira yotchedwa "Save As", yomwe imapezeka mu "Fayilo" tabu.

2. Pazenera lomwe likuwoneka, dinani batani "Sakatulani".
3. Zenera losungira chikalatacho lidzawonekera. Mugawo la "Mtundu wa Fayilo", sankhani "Buku lantchito la Excel (.xlsx). Nthawi zambiri, njirayi ili pamwamba pamndandanda.

4. Mu mzere "Dzina lafayilo" timalemba dzina la chikalatacho ndikudina "Sungani".
5. Pambuyo populumutsa, zolembedwa pamutu wa fayilo "Compatibility Mode" zikadalipo, koma izi sizikutanthauza kuti zikugwira ntchito. Mkhalidwe wa bukhuli susintha mukasunga, chifukwa chake zimatsimikiziridwa pokhapokha fayiloyo ikayambiranso.

Pambuyo potseka chikalatacho ndikuchitsegulanso, zolembedwa zosonyeza kuti njira yolumikizirana yayatsidwa idzazimiririka, ndipo ntchito zonse ndi zida za pulogalamuyo zidzakhala zokonzeka kugwiritsidwa ntchito.

Tcherani khutu! Mukasunga chikalata mumtundu wina, chikalata chatsopano chimapangidwa. Tsopano padzakhala zikalata ziwiri za Excel mufoda yokhala ndi dzina lomwelo, koma zowonjezera (mawonekedwe).

Kutembenuka kwa zolemba

Pantchito yokwanira mu Excel, mutha kugwiritsa ntchito njira yosinthira chikalata.

1. Yambitsani chizindikiro cha "Converter" mu "Fayilo" menyu.
2. Chenjezo likuwoneka kuti chikalatacho chisinthidwa, ndiko kuti, kusinthidwa malinga ndi mtundu womwe wakhazikitsidwa wa Excel. Chonde dziwani kuti chifukwa cha kutembenuka, fayilo yoyambirira idzasinthidwa popanda mwayi wochira.
3. Pazenera lochenjeza, dinani "Chabwino".
4. Pambuyo pake, uthenga wokhudza zotsatira za kutembenuka udzawonekera. Pawindo lomwelo, pali lingaliro lotseka uthengawu ndikutsegula chikalata chosinthidwa kale. Timavomereza - dinani "Chabwino".

M'chikalata chotsegulidwa, zida zonse za Excel tsopano zikugwira ntchito, zitha kugwiritsidwa ntchito kusintha ndikusunga deta.

Kutembenuka kwa buku

Palinso njira yosinthira bukhu la Excel kuti ligwiritse ntchito magwiridwe onse a pulogalamuyi. Pachifukwa ichi, m'pofunika kusintha mawonekedwe a chikalata kuti akhale oyenera.

1. Tsegulani "Fayilo" tabu.
2. Apa ife kusankha "Convert" lamulo.
3. Mu tumphuka zenera, alemba "Chabwino" kutsimikizira wapamwamba mtundu kusintha.
4. Chifukwa cha zochita izi, buku la Excel lidzagwira ntchito m'njira yofunikira. Izi zimayimitsa mawonekedwe ogwirizana.

Zofunika! Pa kutembenuka, choyambirira wapamwamba makulidwe angasinthe.

Dziwani zambiri za Compatibility Mode mu Excel

Pamabwalo, nthawi zambiri mumatha kupeza mafunso okhudzana ndi kuthekera kochepa kwa Excel. Chifukwa chake, mukatsegula chikalata, uthenga wakuti "Compatibility mode" umawonekera pafupi ndi dzinalo. Chifukwa chake chikhoza kukhala kusagwirizana pakati pa mitundu ya Excel popanga fayilo ndikusintha. Ngati tebulo lidapangidwa mu Excel-2003, ndiye posamutsa chikalatacho ku kompyuta ndi Excel-2007, zidzakhala zovuta kwambiri kukonza patebulo. Pali njira zingapo zothetsera vutoli:

1. Пересохранение документа в формате .xlsx.
2. Sinthani fayilo kukhala mtundu watsopano wa Excel.
3. Tsitsani mawonekedwe ofananira kuti mugwirenso ntchito ndi chikalatacho.

Iliyonse mwazosankha ili ndi zabwino ndi zoyipa zake. Kusankha kumatengera zomwe wogwiritsa ntchito amakonda komanso tsogolo la chikalata cha Excel palokha.

Malangizo apakanema

Kuti mumvetse bwino kufunikira ndi mfundo zamachitidwe ofananira kapena kuchepetsedwa kwamachitidwe, mutha kuwona malangizo angapo amakanema omwe amapezeka mwaulele pa kuchititsa makanema a YouTube. Nawa ochepa mwa iwo:

Makanema achidulewa ali ndi chidziwitso chokwanira kumvetsetsa momwe Compatibility Mode imagwirira ntchito komanso momwe mungazimitse.

Kutsiliza

Mawonekedwe ofananira m'mafayilo a Excel ndi gawo lothandiza lomwe limakupatsani mwayi wochotsa mikangano ndi zolakwika pakati pa mapulogalamu pamakompyuta osiyanasiyana mukakonza chikalata chomwecho m'mitundu yosiyanasiyana ya pulogalamuyo. Ntchitoyi imapangitsa kuti zitheke kugwira ntchito ndi mafayilo pamalo amodzi aukadaulo.

Pankhaniyi, wosuta akhoza kuletsa ngakhale akafuna nthawi iliyonse kuwonjezera mapulogalamu ntchito. Komabe, muyenera kudziwa malire okhudzana ndi zovuta zomwe zingachitike mukasamutsa fayilo ku kompyuta yokhala ndi mtundu wakale wa Excel.