Imodi yokuhambisana ku-Excel. Ukusebenza Ngamadokhumenti Ekubukweni Okuhambelanayo

Izinhlelo zekhompyutha zivuselelwa njalo, izinguqulo ezintsha nezithuthukisiwe zikhishwa. Ngakho-ke, namuhla, abasebenzisi sebengakwazi kakade ukuhlola uhlelo lwe-Excel-2019. Kanye nokuthuthukiswa, kukhona nezinkinga ezifana nokuhambisana, okungukuthi, idokhumenti edalwe kukhompyutha eyodwa ingase ingavuli kwenye.

Iyini i-Compatibility Mode ku-Microsoft Excel

Umsebenzi we-“Compatibility Mode” uyisethi yezingxenye ezikuvumela ukuthi usebenze ngamadokhumenti ngokunganaki inguqulo yohlelo. Sicela uqaphele ukuthi ezinye izilungiselelo nezici zingase zikhutshazwe noma zibe nomkhawulo. Isibonelo, uma uzama ukuvula isipredishithi esidalwe ku-Excel 2000, imiyalo equkethwe kuleyo nguqulo kuphela ezotholakala ukuze ihlelwe, ngisho noma idokhumenti ivulwe ku-Excel 2016.

Imisebenzi engasebenzi izovezwa kubha yomsebenzi, kodwa ngeke isetshenziswe. Ukuze uqalise kabusha ukufinyelela kuzo zonke izici ezingase zibe khona ze-Excel, kufanele uqale uguqule incwadi yokusebenza ekhethiwe ibe yifomethi efanelekile nefanele. Kodwa uma umsebenzi owengeziwe nedokhumenti ezinguqulweni eziphelelwe yisikhathi kuthiwa kufanele, ngakho-ke kungcono ukuyeka ukuguqula.

Kungani udinga imodi ehambisanayo

Inguqulo yokuqala esebenzayo ye-Excel yethulwa ngo-1985. Isibuyekezo somhlaba wonke sakhululwa ngo-2007. Inani elikhulu lezici eziwusizo namakhono avele kufomethi entsha eyisisekelo. Ngakho, esikhundleni sesandiso esivamile se-.xls, i-.xlsx manje yengezwa egameni ledokhumenti.

Inguqulo entsha yenza umsebenzi omuhle kakhulu wokusebenza nokuhlela amadokhumenti adalwe ezinguqulweni zangaphambilini ze-Excel. Ngeshwa, ukuhambisana emuva akuphumelelanga kangako. Mayelana nalokhu, amadokhumenti anesandiso se-.xlsx angase angavuleki uma, isibonelo, inguqulo ye-Excel 2000 ifakiwe kukhompuyutha.

Kungenzeka futhi ukuthi idokhumenti elondolozwe ku-Excel 2000 yahlelwa ku-Excel 2016 futhi kamuva yavulwa kabusha ngohlelo oluphelelwe yisikhathi, lapho ezinye izinguquko zingase zingavezwa noma ifayela lingase lingatholakali nhlobo.

Kungenxa yezinketho ezinjalo lapho kuba khona ukusebenza okuncishisiwe noma imodi ehambisanayo. Ingqikithi yemodi ukuhlinzeka ngekhono lokusebenza ngamafayela ezinguqulweni ezahlukene zohlelo, kodwa ngokulondolozwa kokusebenza kwenguqulo yokuqala ye-Excel..

Izinkinga zokuhambisana

Inkinga enkulu nge-Compatibility Mode ku-Excel ukuthi ivulwa ngokuzenzakalelayo. Lokhu kuqinisekisa ukuthi idatha iyagcinwa lapho kudluliswa amafayela kusuka kwenye ikhompyutha kuya kwenye. Ngenxa yalokhu, akufanele wesabe ukuthi ngemva kokuhlela ifayela ngeke livuleke noma lonakaliswe.

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

Ungakwazi ukuhlonza izinkinga zokuhambisana okungenzeka uma usebenzisa i-Excel-2010 noma i-Excel-2013. Ukuze wenze lokhu, iya kumenyu ethi "Ifayela", kupharamitha ethi "Ulwazi", vula inkinobho ethi "Hlola izinkinga", bese ukhetha okuthi "Hlola ukuhambisana". Ngemuva kwalokhu kukhohlisa, i-Excel izohlaziya idokhumenti, inikeze umbiko onemininingwane ngenkinga ngayinye ngesixhumanisi esithi "Thola", uma uchofoza kuso, amaseli enkinga azovezwa.

Ukwenza kusebenze imodi

Awudingi ukwenza noma yini ukuze uqale i-Compatibility Mode. Njengomthetho, uhlelo luzoqaphela ngokuzimela inguqulo lapho idokhumenti igcinwa khona futhi, uma kunesidingo, ivumela ngokuzenzakalelayo imodi yokusebenza encishisiwe. Ungathola ukuthi imodi icushiwe kusukela kunhlokweni yewindi lefayela elivuliwe. Umlayezo othi “Indlela Evumelanayo” uzovela kubakaki eduze kwegama ledokhumenti. Njengomthetho, umbhalo onjalo uvela lapho usebenza namafayela agcinwe ku-Excel ngaphambi kwenguqulo 2003, okungukuthi, ngaphambi kokufika kwefomethi ye-.xlsx.

Ukuvalwa kwemodi

Akudingekile njalo kumodi yokusebenza encishisiwe. Isibonelo, ukusebenza kufayela lokuqala kuzoqhubeka ku-Excel ebuyekeziwe futhi ngeke kuphinde kudluliselwe kwenye ikhompuyutha.

1. Ukuze uvale, udinga ukuya kuthebhu ebizwa ngokuthi "Ifayela". Kuleli windi, ngakwesokudla, khetha ibhulokhi ebizwa ngokuthi "Imodi yokusebenza ekhawulelwe". Chofoza inkinobho ethi "Guqula".

2. Kuzovela iwindi elikwazisa ukuthi kuzokwakhiwa ibhuku elisha elizogcina zonke izici nezakhiwo zenguqulo yesimanjemanje ye-Excel. Ngesikhathi sokwenziwa kwencwadi yokusebenzela ye-Excel entsha, ifayela elidala lizosuswa. Ungazisoli - chofoza "KULUNGILE".

3. Ngemva kwesikhashana, kuzovela iwindi elinemininingwane ethi “Ukuguqulwa kuqediwe”. Ukuze ulondoloze zonke izinguquko futhi ukhubaze imodi yokuhambisana, idokhumenti kufanele iqalwe kabusha.

Ngemva kokuvula kabusha ifayela eliguquliwe, zonke izinketho ezitholakalayo zizosebenza.

Imodi yokuvumelana lapho udala amadokhumenti amasha

Njengoba kushiwo ngaphambili, uma uvula ifayela ezinguqulweni ezintsha ze-Excel, i-Compatibility Mode iyasebenza. Kodwa le modi ingaphinda inikwe amandla uma ukulondoloza ngokuzenzakalelayo kusethelwe kufomethi yefayela le-.xls, okungukuthi, ukulondoloza ngezinguqulo 97-2003. Ukuze ulungise lesi simo futhi usebenzise uhla olugcwele lwemisebenzi yohlelo lapho usebenza namathebula, udinga ukulungisa ukulondoloza ifayela ngefomethi efanele .xlsx.

1. Iya kumenyu ethi "Ifayela", vula isigaba "Izinketho".

2. Kupharamitha ethi "Londoloza", khetha izilungiselelo "Londoloza izincwadi". Inani elizenzakalelayo lapha yi-Excel 97-2003 Workbook (*.xls). Shintsha leli nani liye kwenye ifomethi ethi “Excel Book (*.xlsx)”. Ukuze ulondoloze izinguquko, chofoza "KULUNGILE".

Manje wonke amafayela e-Excel azokwakhiwa futhi alondolozwe ngefomethi efanele ngaphandle kokuvula Imodi Evumelanayo. Ngenxa yalokhu, usungakwazi manje ukusebenza nganoma iyiphi inguqulo ye-Excel ngaphandle kokukhathazeka ngokulahlekelwa idatha noma ukuhlanekezela izibalo eziwumphumela nokubala. Ngesikhathi esifanayo, uma kunesidingo, imodi ingavalwa, okuvumela ukuthi usebenze nedokhumenti usebenzisa zonke izici zesimanje zohlelo.

Londoloza ngefomethi efanele

Kukhona enye indlela yokuvala imodi yokusebenza encishisiwe ukuze uqhubeke usebenza kunguqulo entsha ye-Excel. Kwanele ukulondoloza ifayela ngefomethi ehlukile.

1. Iya kunketho ebizwa ngokuthi "Gcina Njengo", engatholakala kuthebhu "Ifayela".

2. Ewindini elivelayo, chofoza inkinobho ethi "Phequlula".
3. Kuzovela iwindi lokulondoloza idokhumenti. Esigabeni esithi “Uhlobo lwefayela”, khetha “Ibhuku lokusebenzela le-Excel (.xlsx). Ngokuvamile, le nketho iphezulu ohlwini.

4. Emgqeni othi "Igama lefayela" sibhala igama ledokhumenti bese uchofoza "Londoloza".
5. Ngemva kokulondoloza, umbhalo osekhanda lefayela elithi "Indlela Yokuhambisana" usasele, kodwa lokhu akusho ukuthi iyasebenza. Isimo sebhuku asishintshi uma ulondoloza, ngakho sinqunywa kuphela uma ifayela liqalwa kabusha.

Ngemuva kokuvala idokhumenti futhi uyivule kabusha, umbhalo othi imodi yokuhambisana icushiwe uzonyamalala, futhi yonke imisebenzi nezakhiwo zohlelo zizobe sezilungele ukusetshenziswa.

Nakani! Uma ugcina idokhumenti ngefomethi ehlukile, kwakhiwa idokhumenti entsha. Manje kuzoba nemibhalo emibili ye-Excel kufolda enegama elifanayo, kodwa isandiso esihlukile (ifomethi).

Ukuguqulwa kwedokhumenti

Ngomsebenzi ogcwele ku-Excel, ungasebenzisa indlela yokuguqula idokhumenti.

1. Yenza kusebenze isithonjana "Isiguquli" kumenyu ethi "Ifayela".
2. Kuzovela isixwayiso sokuthi idokhumenti manje izoguqulwa, okungukuthi, iguqulelwe kumazinga enguqulo efakiwe ye-Excel. Sicela uqaphele ukuthi ngenxa yokuguqulwa, ifayela langempela lizoshintshwa ngaphandle kokutholakala kwalo.
3. Ewindini lesexwayiso, chofoza "Kulungile".
4. Ngemuva kwalokho, kuzovela umlayezo omayelana nemiphumela yokuguqulwa. Ewindini elifanayo, kunesiphakamiso sokuvala lo mlayezo futhi uvule idokhumenti esivele ibuyekeziwe. Siyavuma - chofoza "KULUNGILE".

Embhalweni ovuliwe, wonke amathuluzi e-Excel manje akwimodi esebenzayo, angasetshenziswa ukuhlela nokugcina idatha.

Ukuguqulwa kwencwadi

Kukhona futhi indlela yokuguqula incwadi yokusebenzela ye-Excel ukuze isebenzise ngokuphelele yonke imisebenzi yohlelo. Ngale njongo, kuyadingeka ukushintsha ifomethi yedokhumenti ibe inguqulo efanele.

1. Vula ithebhu "Ifayela".
2. Lapha sikhetha umyalo othi "Guqula".
3. Efasiteleni le-pop-up, chofoza "KULUNGILE" ukuze uqinisekise ushintsho lwefomethi yefayela.
4. Njengomphumela walezi zenzo, ibhuku lokusebenzela le-Excel selizosebenza ngefomethi edingekayo. Lokhu kukhubaza imodi yokuhambisana.

Kubalulekile! Ngesikhathi sokuguqulwa, osayizi bamafayela bangempela bangashintsha.

Funda kabanzi mayelana ne-Compatibility Mode ku-Excel

Kumaforamu, ungathola imibuzo ehlobene namandla anomkhawulo we-Excel. Ngakho-ke, lapho uvula idokhumenti, umlayezo othi "Imodi yokuhambisana" uvela eduze kwegama. Isizathu salokhu kungase kube ukungafani phakathi kwezinguqulo ze-Excel lapho udala ifayela kanye nenqubo yokulihlela. Uma ithebula ladalwa ku-Excel-2003, lapho-ke lapho udlulisela idokhumenti kukhompyutha ene-Excel-2007, kuzoba nzima kakhulu ukwenza noma yiziphi izilungiso ematafuleni. Kunezindlela ezimbalwa zokuphuma kulesi simo:

1. Пересохранение документа в формате .xlsx.
2. Guqula ifayela libe yifomethi entsha ye-Excel.
3. Vala imodi yokuhambisana ukuze uqhubeke nomsebenzi ngedokhumenti.

Ngayinye yezinketho inezinzuzo nezingozi zayo. Ukukhetha kuncike kulokho okuthandwa ngumsebenzisi kanye nesiphetho sesikhathi esizayo sedokhumenti ye-Excel ngokwayo.

Imiyalo yevidiyo

Ukuze uqonde kangcono isidingo nezimiso zemodi yokuhambisana noma imodi yokusebenza encishisiwe, ungabuka imiyalo embalwa yevidiyo etholakala mahhala ekusingatheni amavidiyo we-YouTube. Nazi ezimbalwa zazo:

Lawa mavidiyo amafushane aqukethe ulwazi olwanele lokuqonda ukuthi i-Compatibility Mode isebenza kanjani nokuthi uyivala kanjani.

Isiphetho

Imodi yokuhambisana kumafayela e-Excel iyisici esiwusizo kakhulu esikuvumela ukuthi ukhiphe izingxabano namaphutha phakathi kwezinhlelo ezikumakhompyutha ahlukene lapho ucubungula idokhumenti efanayo ezinguqulweni ezihlukene zohlelo. Lo msebenzi wenza kube nokwenzeka ukusebenza ngamafayela endaweni eyodwa yobuchwepheshe.

Kulesi simo, umsebenzisi angakhubaza imodi yokuhambisana nganoma yisiphi isikhathi ukuze andise ukusebenza kwesofthiwe. Nokho, kufanele uqaphele eminye imikhawulo ehlobene nezinkinga ezingase zenzeke lapho udlulisela ifayela kukhompyutha enenguqulo endala ye-Excel.