Kuenderana modhi muExcel. Kushanda neMagwaro muKuenderana Maonero

Zvirongwa zvekombuta zvinogara zvichivandudzwa, zvitsva uye zvakavandudzwa shanduro dzinoburitswa. Saka, nhasi, vashandisi vanogona kutoedza iyo Excel-2019 chirongwa. Pamwe chete nekuvandudzwa, kunewo matambudziko akadai sekuenderana, ndiko kuti, gwaro rakagadzirwa pane imwe komputa rinogona kusavhura pane imwe.

Chii chinonzi Compatibility Mode muMicrosoft Excel

Iyo "Compatibility Mode" basa seti yezvikamu zvinokutendera kuti ushande nemagwaro zvisinei neshanduro yechirongwa. Ndokumbira utarise kuti mamwe marongero uye maficha anogona kuvharwa kana kushomeka. Semuenzaniso, kana ukaedza kuvhura spreadsheet yakagadzirwa muExcel 2000, chete mirairo iri mushanduro iyoyo ndiyo ichave iripo yekugadzirisa, kunyangwe gwaro rakavhurwa muExcel 2016.

Zvisina kushanda zvicharatidzwa pabhara rebasa, asi hazvigone kushandiswa. Kuti utangezve kuwana kune ese angangoita maficha eExcel, unofanirwa kutanga washandura bhuku rebasa rakasarudzwa kune rakakodzera, rakakodzera fomati. Asi kana imwezve basa negwaro pane dzakasakara shanduro dzinofungidzirwa, saka zviri nani kurega kutendeuka.

Sei uchida kuenderana mode

Yekutanga inoshanda shanduro yeExcel yakaunzwa muna 1985. Iyo yakanyanya kugadziridzwa yepasi rose yakaburitswa muna 2007. Nhamba huru yezvinhu zvinobatsira uye zvinogoneka zvakaonekwa kusvika kune nyowani yekutanga fomati. Saka, pachinzvimbo chenguva dzose .xls extension, .xlsx ikozvino yawedzerwa kuzita regwaro.

Iyo vhezheni itsva inoita basa rakakura rekushanda nekugadzirisa magwaro akagadzirwa mune dzakapfuura shanduro dzeExcel. Nehurombo, kuenderana kumashure hakuna kubudirira. Panyaya iyi, magwaro ane .xlsx extension anogona kusavhura kana, semuenzaniso, shanduro yeExcel 2000 yakaiswa pakombiyuta.

Zvinogoneka zvakare kuti gwaro rakachengetwa muExcel 2000 rakagadziridzwa muExcel 2016 uye rakazovhurwa zvakare muchirongwa chechinyakare, mune izvo zvimwe shanduko dzinogona kusaratidzwa kana faira ringave risipo zvachose.

Izvo ndezvesarudzo dzakadaro kuti kune yakaderedzwa mashandiro kana kuenderana modhi. Chinhu cheiyo modhi ndechekupa kugona kushanda nemafaira mune dzakasiyana shanduro dzechirongwa, asi nekuchengetedza kushanda kweiyo yekutanga vhezheni yeExcel..

Kuenderana nyaya

Dambudziko guru neCompatibility Mode muExcel nderekuti inogoneswa otomatiki. Izvi zvinovimbisa kuti data inochengetedzwa kana uchiendesa mafaira kubva kune imwe komputa kuenda kune imwe. Nekuda kweizvi, haufanirwe kutya kuti mushure mekugadzirisa faira haizovhurike kana kukuvadzwa.

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

Iwe unogona kuona zvinogona kuenderana nyaya kana uchishandisa Excel-2010 kana Excel-2013. Kuti uite izvi, enda kumenyu ye "Faira", mu "Information" parameter, shandisa bhatani re "Check for problems", uye sarudza "Tarisa kuenderana". Mushure mekuita izvi, Excel ichaongorora gwaro, ichipa rondedzero yakadzama padambudziko rega rega ne "Tsvaga" link, kana iwe ukadzvanya pairi, dambudziko maseru anozoratidzwa.

Mode activation

Haufanire kuita chero chinhu kuti utange Compatibility Mode. Semutemo, chirongwa chinozozvimiririra chichiziva vhezheni inochengeterwa gwaro uye, kana zvichidikanwa, inogonesa kuderedzwa kwemaitiro maitiro. Iwe unogona kuona kuti iyo modhi inogadziriswa kubva kumusoro weiyo yakavhurika faira hwindo. Iyo meseji "Compatibility Mode" ichaonekwa mumaparentheses padivi pezita regwaro. Sezvo mutemo, kunyorwa kwakadaro kunowanikwa paunenge uchishanda nemafaira akachengetwa muExcel isati yasvika 2003, kureva, kusati kwasvika .xlsx format.

Mode deactivation

Kwete nguva dzose mune yakaderedzwa functionality mode inodiwa. Semuenzaniso, kushanda pafaira rekutanga richaenderera mberi muExcel yakagadziridzwa uye haizodzoserwe kune imwe komputa.

1. Kuti udzimise, unofanirwa kuenda kune iyo tab inonzi "Faira". Muhwindo iri, kurudyi, sarudza block inonzi "Restricted functionality mode". Dzvanya bhatani rekuti "Shandura".

2. Hwindo richaonekwa richikuzivisa kuti bhuku idzva rebasa richagadzirwa iro richachengeta zvese zvimiro uye zvimiro zveimwe shanduro yemazuva ano yeExcel. Panguva yekugadzirwa kwebhuku idzva reExcel, faira rekare richadzimwa. Usazvidemba - tinya "OK".

3. Mushure mechinguva, hwindo rine ruzivo "Shanduro yapera" ichaonekwa. Kuti uchengetedze shanduko dzese uye kudzima nzira yekuenderana, gwaro rinofanira kutangwazve.

Mushure mekuvhurazve faira rakashandurwa, sarudzo dzese dziripo dzichashanda.

Compatibility mode paunenge uchigadzira zvinyorwa zvitsva

Sezvambotaurwa, paunovhura faira mune nyowani shanduro dzeExcel, Compatibility Mode inovhurwa. Asi iyi modhi inogona zvakare kugoneswa kana autosave yakaiswa kune .xls faira fomati, ndiko kuti, kuchengetedza mushanduro 97-2003. Kuti ugadzirise mamiriro ezvinhu aya uye ushandise huwandu hwakazara hwemabasa epurogiramu paunenge uchishanda nematafura, unoda kugadzirisa kuchengetedza faira mune yakakodzera .xlsx format.

1. Enda kune "Faira" menyu, shandisa chikamu che "Options".

2. Mu "Chengetedza" parameter, sarudza "Chengetedza mabhuku". Iko kukosha kwekutanga pano iExcel 97-2003 Workbook (*.xls). Chinja kukosha uku kune imwe fomati "Excel Book (*.xlsx)". Kuti uchengetedze shanduko, tinya "OK".

Iye zvino mafaera ese eExcel achagadzirwa uye kuchengetwa mufomati chaiyo pasina kumisikidza Compatibility Mode. Nekuda kweizvi, iwe unogona ikozvino kushanda nechero vhezheni yeExcel usinganetseki nekurasikirwa nedata kana kukanganisa maverengero akabuda uye maverengero. Panguva imwecheteyo, kana zvichidiwa, iyo mode inogona kuvharwa, iyo inokubvumira kushanda negwaro uchishandisa zvose zvemazuva ano zvepurogiramu.

Chengetedza nenzira kwayo

Pane imwe nzira yekudzima yakaderedzwa mashandiro ekuita kuti uenderere mberi uchishanda mune nyowani vhezheni yeExcel. Zvakakwana kuchengetedza faira mune imwe nzira.

1. Enda kune sarudzo inonzi "Save As", iyo inogona kuwanikwa mu "Faira" tab.

2. Muhwindo rinoonekwa, tinya bhatani re "Browse".
3. Hwindo rekuchengetedza gwaro richaonekwa. Muchikamu che "Faira remhando", sarudza "Excel workbook (.xlsx). Kazhinji, iyi sarudzo iri pamusoro pechinyorwa.

4. Mumutsara "Zita refaira" tinonyora zita regwaro uye tinya "Chengetedza".
5. Mushure mekuchengetedza, zvakanyorwa mumusoro wefaira "Compatibility Mode" zvichiripo, asi izvi hazvireve kuti inoshanda. Mamiriro ebhuku haachinje kana uchichengetedza, saka inotemwa chete kana iyo faira yatangwazve.

Mushure mekuvhara gwaro nekurivhurazve, zvakanyorwa kuti iyo yekuenderana modhi yakagadziriswa ichanyangarika, uye ese mabasa uye zvivakwa zvechirongwa zvichave zvakagadzirira kushandiswa.

Teerera! Paunochengeta gwaro mune imwe nzira, gwaro idzva rinogadzirwa. Ikozvino kuchave nemagwaro maviri eExcel muforodha ine zita rimwechete, asi akasiyana ekuwedzera (fomati).

Kushandurwa kwegwaro

Kuti uite basa rakazara muExcel, unogona kushandisa nzira yekushandura gwaro.

1. Shandisa iyo "Converter" icon mu "Faira" menyu.
2. Yambiro ichaonekwa yekuti gwaro racho zvino rave kushandurwa, ndiko kuti, kuchinjirwa kune zviyero zveiyo yakaiswa vhezheni yeExcel. Ndapota cherechedza kuti semugumisiro wekutendeuka, iyo yepakutanga faira ichatsiviwa pasina mukana wekudzorerwa kwayo.
3. Muwindo reyambiro, tinya "OK".
4. Mushure meizvozvo, meseji ine chekuita nemhedzisiro yekutendeuka ichaonekwa. Muhwindo rimwe chete, pane chirevo chekuvhara meseji iyi uye kuvhura gwaro rakatovandudzwa. Tinobvumirana - tinya "OK".

Mugwaro rakavhurwa, ese maturusi eExcel ave kuita maitiro, anogona kushandiswa kugadzirisa nekuchengetedza data.

Kushandurwa kwebhuku

Pane zvakare nzira yekushandura bhuku reExcel kuti rishandise zvachose kuita kwechirongwa. Nechinangwa ichi, zvinodikanwa kushandura chimiro chegwaro kune iyo yakakodzera shanduro.

1. Vhura iyo "Faira" tab.
2. Pano tinosarudza "Shandura" murairo.
3. Muhwindo rinobuda, tinya "OK" kuratidza shanduko yefaira.
4. Nekuda kwezviito izvi, bhuku rekushanda reExcel rava kushanda mufomati inodiwa. Izvi zvinodzima kuenderana modhi.

Zvinokosha! Munguva yekushandura, hukuru hwefaira hwepakutanga hunogona kuchinja.

Dzidza zvakawanda nezve Kuenderana Mode muExcel

Pamaforamu, iwe unogona kazhinji kuwana mibvunzo ine chekuita nekugona kushoma kweExcel. Saka, paunovhura gwaro, meseji "Compatibility mode" inobuda padivi pezita. Chikonzero cheizvi chinogona kunge chiri kusawirirana pakati peshanduro dzeExcel paunenge uchigadzira faira uye mukuita kurigadzirisa. Kana iyo tafura yakagadzirwa muExcel-2003, zvino kana uchiendesa gwaro kune komputa ine Excel-2007, zvichave zvakanyanya kuoma kuita chero zvigadziriso pamatafura. Pane nzira dzakawanda dzekubuda mumamiriro aya:

1. Пересохранение документа в формате .xlsx.
2. Shandura iyo faira kuita iyo nyowani Excel fomati.
3. Deactivate compatibility mode kuti uwedzere kushanda negwaro.

Imwe neimwe yesarudzo ine zvayakanakira nezvayakaipira. Sarudzo inoenderana nezvido zvemushandisi uye ramangwana reExcel gwaro pacharo.

Vhidhiyo kuraira

Kuti unzwisise zviri nani kudiwa uye misimboti yekuenderana modhi kana kuderedzwa kwekuita maitiro, unogona kuona akati wandei mavhidhiyo mirairo inowanikwa pachena paYouTube vhidhiyo yekutambira. Heano mashoma acho:

Aya mavhidhiyo mapfupi ane ruzivo rwakakwana kuti unzwisise kuti Compatibility Mode inoshanda sei uye nekuidzima.

mhedziso

Kuenderana modhi muExcel mafaera chinhu chinobatsira chinokutendera kuti ubvise kupokana uye zvikanganiso pakati pezvirongwa pamakomputa akasiyana kana uchigadzira gwaro rimwe chete mushanduro dzakasiyana dzechirongwa. Iri basa rinoita kuti zvikwanise kushanda nemafaira mune imwechete tekinoroji nzvimbo.

Muchiitiko ichi, mushandisi anogona kudzima iyo yekuenderana modhi chero nguva kuti awedzere kushanda kwesoftware. Nekudaro, iwe unofanirwa kuziva zvimwe zvipimo zvine chekuita nezvinetso zvinogona kuitika kana uchiendesa faira kune komputa ine yekare vhezheni yeExcel.