Ungalivula kanjani ifayela le-XLSM?
Amafayela ane-extensionXLSM adaliwe ku-Microsoft Excel, uhlelo lokusebenza lwesipredishithi oluyingxenye ye-Microsoft Office suite. Lawa mafayela aqukethe ama-macros, okuyiziqondiso zokuhlela ezishintshanisa imisebenzi nemisebenzi efayeleni. Nokho, abanye abasebenzisi bangase bahlangabezane nobunzima bokuvula ifayela le-XLSM uma bengenalo ulwazi lobuchwepheshe noma bengenalo uhlobo olulungile lwe-Excel.
Kulesi sihloko, sizokuchazela isinyathelo ngesinyathelo indlela yokuvula ifayela le-XLSM ngendlela elula nengeyona inkimbinkimbi. Sizokunikeza izinketho ezahlukene kuye ngenguqulo yakho ye-Excel futhi sikunikeze amathiphu engeziwe ukuze siqiniseke ukuthi ifayela lilayisha ngendlela efanele.
Ngaphambi kokuthi uqale: qiniseka ukuthi uyakwazi ukufinyelela inguqulo ye-Microsoft Excel esekela amafayela e-XLSM. Ezinye izinguqulo ezindala ze-Excel zingase zingakwazi ukuvula lolu hlobo lwefayela Ukwengeza, kubalulekile ukuqaphela ukuthi uma ifayela le-XLSM liqukethe ama-macros enza izenzo ezizenzakalelayo, njengokushintsha okuqukethwe kwamaseli noma ukufinyelela kumafayela angaphandle. qaphela lapho uyivula, njengoba ama-macros angabeka izingozi zokuphepha uma evela emithonjeni engaziwa noma engathenjwa.
Inketho 1: Vula nge I-Microsoft Excel: Indlela evamile yokuvula ifayela le-XLSM ukusebenzisa i-Microsoft Excel. Uma unohlelo olufakiwe kukhompyutha yakho, mane uchofoze kabili ifayela le-XLSM futhi i-Excel izolivula ngokuzenzakalelayo. Qiniseka ukuthi unenguqulo efanele ye-Excel nokuthi isesikhathini samanje ukuze ugweme izinkinga zokuhambisana.
Inketho 2: Vula nge ezinye izinhlelo zokusebenza iyahambisana: Uma ungakwazi ukufinyelela inguqulo yakamuva ye-Microsoft Excel noma ungathanda ukusebenzisa enye indlela, kunezinye izinhlelo zokusebenza zesipredishithi ezingavula amafayela e-XLSM, njenge-Google AmaSpredishithi noma i-LibreOffice Calc Lezi zinhlelo zokusebenza zivame ukuhambisana nobubanzi amafomethi ahlukahlukene wefayela, kufaka phakathi i-XLSM.
Amathiphu angeziwe: Ukuze ugweme izinkinga zokuvula ifayela le-XLSM, qiniseka ukuthi ulilanda emthonjeni othembekile kanye nokuthi ikhompuyutha yakho inohlelo oluhle, olusesikhathini samanje lwe-antivirus. Uma ifayela le-XLSM lingavuleki kahle noma uma uhlangabezana nobunzima ngama-macros, ungazama ukunika amandla ama-macros kuzilungiselelo zokuphepha ze-Excel. Uma ungazizwa ukhululekile noma ungazethembi ngokuvula ifayela le-XLSM, kuyalulekwa ukuthi ucele usizo kuchwepheshe wekhompyutha noma uchwepheshe wezobuchwepheshe.
Ungalivula kanjani ifayela le-XLSM
Ifayela le-XLSM liwuhlobo lwefayela le-Microsoft Excel eliqukethe amamakhro anikwe amandla. Lawa ma-macro izinhlelo ezincane ezingasetshenziswa ukwenza imisebenzi ngokuzenzakalelayo futhi kwandiswe ukusebenza kahle ekusebenziseni i-Excel. Uma unefayela le-XLSM futhi ufuna ukulivula, kunezindlela ezimbalwa zokwenza kanjalo.
1. Ukusebenzisa iMicrosoft Excel: Indlela evamile yokuvula ifayela le-XLSM ukusebenzisa isofthiwe ye-Microsoft Excel. Chofoza kabili nje ifayela le-XLSM futhi lizovuleka ku-Excel. Qiniseka ukuthi unenguqulo efanele ye-Excel efakiwe ehambisana nefayela le-XLSM ozama ukulivula.
2. Guqula ifayela le-XLSM libe kwenye ifomethi: Uma ungakwazi ukufinyelela ku-Microsoft Excel noma uma ufuna indlela eguquguqukayo yokuvula ifayela le-XLSM, ungase uthande ukucabanga ukuliguqulela kwenye ifomethi. Kunamathuluzi amaningana aku-inthanethi atholakalayo. lokho angakwaziukwenza lokhu kuguqulwa kwamahhala. Isibonelo, ungakwazi ukuguqula ifayela le-XLSM libe yifomethi ye-XLSX, engavulwa kwezinye izinhlelo zokusebenza eziningi zesipredishithi.
3. Sebenzisa ithuluzi lomuntu wesithathu: Uma ingekho kulezi zindlela ezingenhla esebenza ukuvula ifayela lakho le-XLSM, ungase ucabange ukusebenzisa ithuluzi lenkampani yangaphandle elikhethekile ekuvuleni amafayela e-XLSM. Lawa mathuluzi ngokuvamile ayizinhlelo zesofthiwe eziklanyelwe ngokuqondile ukuphatha amafayela e-XLSM futhi angase anikeze ukuhambisana okukhulu nokusebenza uma kuqhathaniswa nezinye izixazululo. Amanye ala mathuluzi akhokhelwa, kanti amanye amahhala.
Izidingo kanye namathuluzi adingekayo
Ukuvula ifayela le-XLSM, kubalulekile ukuba namathuluzi athile futhi uhlangabezane nezimfuneko ezithile. Ngezansi, sethula okudingayo ukuze wenze le nqubo ngempumelelo:
1.Microsoft Excel: Le softhiwe yesipredishithi ibalulekile ekuvuleni amafayela e-XLSM. Qiniseka ukuthi unenguqulo yakamuva ye-Excel efakwe kudivayisi yakho. Ungayithenga ngokuqondile engosini ye-Microsoft esemthethweni noma usebenzise ukubhalisa ku-inthanethi.
2. Ifayela le-XLSM: Impela, uzodinga ifayela XLSM uqobo ukuze ukwazi ukusebenza nalo. Qiniseka ukuthi unekhophi yefayela elondolozwe kudivayisi yakho noma elondolozwe emafini ngaphambi kokuzama ukuyivula. Uma ungenayo ifayela, cela kumuntu noma ibhizinisi elihambisanayo elikunikeza ikhophi.
3. Isistimu yokusebenza iyahambisana: Qinisekisa lokho uhlelo lwakho lokusebenza ihambisane ne-Microsoft Excel. Amafayela e-XLSM ahambisana nezinguqulo ezihlukahlukene ze- IWindows ne-MacOS, kodwa kubalulekile ukwenza isiqiniseko sokuthi uhlelo lwakho lokusebenza luhlangabezana nezidingo ezidingekayo. Bona imibhalo esemthethweni ye-Microsoft ukuze uqinisekise ukuhambisana.
Ukuhambisana nohlelo lokuvula amafayela e-XLSM
Ifayela le-XLSM yisipredishithi se-Microsoft Excel esiqukethe amamakhro anikwe amandla. Nokho, akuzona zonke izinhlelo zesipredishithi ezihambisana nefomethi ye-XLSM futhi zingase zibe nezinkinga lapho uzama ukuvula lolu hlobo lwefayela. Ngakho-ke, kubalulekile ukusebenzisa uhlelo oluhambisana namafayela e-XLSM ukuze kuqinisekiswe ukuthi angavulwa ngendlela efanele nokuthi ama-macros asebenza ngendlela efanele.
Ngezansi ezinye zezinhlelo ezidume kakhulu ezihambisana namafayela e-XLSM:
I-Microsoft Excel: Njengoba kushiwo ngenhla, i-Microsoft Excel iwuhlelo olusetshenziswa kakhulu ukuvula amafayela e-XLSM. I-Excel ihlinzeka ngayo yonke imisebenzi edingekayo ukuze uvule futhi uhlele Amaspredishithi e-XLSM, okuhlanganisa namamakhro asebenzayo. Kunezinguqulo eziningana ze-Excel ezitholakalayo, kusuka ku-Excel 2007 kuya enguqulweni yakamuva kakhulu, i-Excel 2019. Qiniseka ukuthi unenguqulo efanele ye-Excel efakiwe ehambisana nefayela le-XLSM ozama ukulivula.
I-LibreOffice: I-LibreOffice iyisudi yehhovisi yomthombo wamahhala nevulekile ehlanganisa uhlelo lwesipredishithi olubizwa ngokuthi iCalc esekela amafayela e-XLSM futhi ingawavula kalula. Ine-interface efanayo ne-Excel futhi inikeza izici eziningi ezifanayo nokusebenza. Kodwa-ke, amanye ama-macros ayinkimbinkimbi angase angasebenzi kahle uma uvula ifayela le-XLSM ku-LibreOffice, ngakho-ke kuyanconywa ukuthi uhlole ifayela ngemva kokulivula ku-LibreOffice.
I-Google AmaSpredishithi: I-Google AmaSpredishithi iwuhlelo lokusebenza lwewebhu lwesipredishithi olwakhiwe i-Google. Ihambisana namafayela e-XLSM futhi ikuvumela ukuthi uvule futhi uhlele amaspredishithi ngaphandle kokufaka noma iyiphi isofthiwe eyengeziwe. Nokho, lapho uvula ifayela le-XLSM ku-Google AmaSpredishithi, amanye amamakhro athuthuke kakhulu angase angasebenzi kahle noma asekelwe. Ngakho-ke, kuhle ukuhlola ifayela ngemva kokulivula ku-Google AmaSpredishithi ukuze uqinisekise ukuthi wonke ama-macros asebenza kahle.
Izinyathelo zokuvula ifayela le-XLSM ku-Microsoft Excel
Isinyathelo se-1: Vula i-Microsoft Excel kukhompyutha yakho. Ungathola uhlelo kumenyu yokuqala noma uchofoze isithonjana se-Excel etafuleni uma unayo lapho. Uma ungenayo i-Excel efakiwe, kufanele ulande futhi ufake inguqulo yakamuva ye-Excel. iwebhusayithi Isikhulu seMicrosoft.
Isinyathelo se-2: Lapho iMicrosoft Excel isivuliwe, chofoza inkinobho ethi “Fayela” ekhoneni eliphezulu kwesokunxele kwesikrini. Okulandelayo, khetha okuthi “Vula” kumenyu yokudonsela phansi. Kuzovuleka iwindi lapho kufanele useshe khona bese ukhetha ifayela le-XLSM ofuna ukulivula. Ungasebenzisa ibha yokuzulazula ohlangothini lwesobunxele lwewindi ukuze useshe ifayela endaweni ethile kukhompuyutha yakho.
Isinyathelo se-3: Ngemva kokukhetha ifayela le-XLSM, chofoza inkinobho ethi Vula ekhoneni elingezansi kwesokudla sewindi I-Microsoft Excel izolayisha ifayela le-XLSM futhi ilibonise ekhasini lokusebenza elisha. Manje ungakwenza izinguquko ezidingekayo kanye nezinguquko efayelini. Khumbula ukulondoloza ifayela njalo ukuze ungalahlekelwa izinguquko ezibalulekile.
Nota: Uma ifayela XLSM lingavuleki ngendlela efanele ku-Microsoft Excel, kungase kube nenkinga yokuhambisana noma ukonakalakufayela. Uma kunjalo, ungazama ukuvula ifayela ngenguqulo entsha ye-Excel noma usebenzise ithuluzi lokulungisa ifayela le-Excel ukuze ulungise noma yiziphi izinkinga zenkohlakalo.
Izinyathelo zokuvula ifayela le-XLSM ku-Google AmaSpredishithi
In AmaSpredishithi e-Google, kungenzeka ukuvula amafayela e-Microsoft Excel XLSM ngokulandela izinyathelo ezimbalwa ezilula. I-XLSM amafayela angamafayela ebhuku lokusebenza anikwe amandla amakhulu aqukethe ikhodi ebhalwe ngolimi lokuhlela olubonakalayo Okuyisisekelo Sezinhlelo Zokusebenza (VBA). Nakuba i-Google AmaSpredishithi ingayisekeli i-VBA, usengabuka futhi uhlele idatha kufayela le-XLSM elinemikhawulo ethile.
Isinyathelo sokuqala ukuthi vula i-Google AmaSpredishithi kusiphequluli sakho sewebhu. Uma ungakabi nayo i-akhawunti ye-Google, uzodinga ukuyidala. Uma usungenile, chofoza inkinobho »+ Okusha» ukuze udale a isipredishithi esisha. Kumenyu yokudonsela phansi, khetha okuthi “Layisha ifayela” bese ukhetha ifayela le-XLSM ekhompyutheni yakho. Ifayela lizobe selilayishwa futhi liguqulelwe ifomethi Google AmaSpredishithi.
Ngemva kokuthi ifayela lilayishiwe futhi liguqulwa, ungakwazi buka futhi uhlele idatha kufayela le-XLSM usebenzisa i-Google AmaSpredishithi. Nokho, ama-macros ngeke asebenze ku-Google AmaSpredishithi, ngoba ayisekeli i-VBA. Uzodinga futhiukuqaphela noma yimiphi imisebenzi noma izici okungenzeka azitholakali ku-Google AmaSpredishithi. Kunconywa ukuthi ubuyekeze ifayela eliguquliwe ukuze uqinisekise ukuthi yonke idatha nokufometha kugcinwe ngendlela efanele. Uma usuqedile ukwenza noma yiziphi izinguquko ezidingekayo ungakwazi ukulanda ifayela ulibuyisele ekhompyutheni yakho noma ukwabelana nabanye.
Izinyathelo zokuvula ifayela le-XLSM ku-LibreOffice Calc
Ukuze uvule ifayela le-XLSM ku-LibreOffice Calc, kufanele ulandele lezi zinyathelo:
Isinyathelo se-1: Vula i-LibreOffice Calc kukhompyutha yakho. Ungakwenza lokhu kusukela kumenyu yokuqala noma kusukela kusithonjana kudeskithophu.
Isinyathelo se-2: Lapho i-Calc isivuliwe, chofoza inketho ethi “Ifayela” kubha yemenyu bese ukhetha okuthi “Vula.”
Isinyathelo sesi-3: Ebhokisini lengxoxo le-Open File, phequlula bese ukhetha ifayela le-XLSM ofuna ukulivula. Ungasebenzisa ibha yokuzulazula ukuze useshe amafolda akho noma ufake ngokuqondile indlela yefayela kubha yekheli. Chofoza okuthi “Vula” uma usukhethile ifayela. I-LibreOffice Calc manje izovula ifayela le-XLSM futhi ungakwazi ukuhlela nokusebenza ngalo njengokungathi elinye ifayela lesipredishithi.
Izinyathelo zokuvula ifayela le-XLSM kokuthi Izinombolo
Kunezinhlelo zokusebenza ezimbalwa zespredishithi ze-Apple. Izinombolo ezingenamandla azikwenzi kahle amafayela we-XLSM wokusekela ama-XLSM, ungenza inqubo elula yokukwazi ukuvula i-VulaandITedit lolu hlobo lwefayela. Okulandelayo, ngizokunikeza izinyathelo ezidingekayo zokufeza lokhu:
1. Shintsha isandiso sefayela: Isinyathelo sokuqala ukushintsha isandiso sefayela le-XLSM. Ukuze wenze lokhu, chofoza kwesokudla ifayela le-XLSM bese ukhetha "Qamba kabusha". Okulandelayo, buyisela isandiso se-".xlsm" nge-".xlsx" bese ucindezela ukhiye u-Enter ukuze ulondoloze izinguquko. Lokhu kuguqulwa kuzovumela izinombolo ukuthi zibone futhi zikwazi ukuvula ifayela.
2. Vula Izinombolo: Uma usushintshe isandiso sefayela le-XLSM, vula uhlelo lokusebenza lwezinombolo ku-Mac yakho Ungaluthola kufolda Yezinhlelo zokusebenza noma ngokusisesha kubha yokusesha esobala. Izinombolo zizovuleka ngefasitela elingenalutho, elilungele ukudala noma ukuvula ifayela.
3. Ngenisa ifayela: Ukuze ungenise ifayela XLSM kokuthi Izinombolo, khetha inketho ethi "Ngenisa" efasiteleni lasekhaya Lezinombolo Okulandelayo, thola futhi ukhethe ifayela le-XLSM ofuna ukulivula. Izinombolo zizongenisa ifayela ngokuzenzakalelayo futhi ziliveze kusipredishithi esisha. Manje usuzokwazi ukubuka futhi uhlele okuqukethwe kwefayela le-XLSM kokuthi Izinombolo.
Izinyathelo zokuvula ifayela le-XLSM eHhovisi le-WPS
Kulokhu okuthunyelwe, sizokukhombisa izinyathelo ezidingekayo zokuvula nokusebenza ngamafayela e-XLSM eHhovisi le-WPS.
Isinyathelo se-1: Vula Ihhovisi le-WPS kudivayisi yakho Ungakwenza lokhu ngokuchofoza isithonjana esihambisanayo kudeskithophu yakho noma ngemenyu yasekhaya Uma uhlelo seluvuliwe, uzokwazi ukubona ukusebenzelana komsebenzisi.
Isinyathelo se-2: Uma usukwi-interface yomsebenzisi ye-WPS Office enkulu, khetha ithebhu ethi “Ifayela” phezulu kwesokunxele ewindini. Lokhu kuzovula imenyu yokudonsela phansi enezinketho ezimbalwa.
Isinyathelo se-3: Kumenyu yokudonsela phansi ethi “Ifayela”, chofoza okuthi “Vula.” Lokhu kuzovula isihloli sefayela lapho ungaphequlula khona bese ukhetha ifayela le-XLSM ofuna ukulivula Zulazulela endaweni yefayela bese uchofoza kuyo ukuze uyikhethe. Bese, uchofoza inkinobho “Vula” ekhoneni elingezansi kwesokudla sewindi ukuze uvule ifayela le-XLSM ku-WPS Office.
Nota: Khumbula ukuthi amafayela e-XLSM angamafayela anikwe amandla amakhulu, okusho ukuthi angaqukatha amakhodi asebenzisekayo.
Okucatshangelwayo ukuze uvule kahle ifayela le-XLSM
Lapho uvula ifayela le-XLSM, kubalulekile ukugcina ukucatshangelwa okumbalwa ukuze uqinisekise ukuthi inqubo iyimpumelelo. Ngezansi ezinye izinyathelo namathiphu angasiza kule nqubo:
Hlola ukuhambisana kohlelo: Ngaphambi kokuzama ukuvula ifayela le-XLSM, kubalulekile ukwenza isiqiniseko sokuthi unohlelo olufakiwe oluhambisana nalolu hlobo lwefayela. I-Microsoft Excel ingenye yezinhlelo esetshenziswa kakhulu ukuvula amafayela e-XLSM, kodwa kukhona nezinye izindlela ezifana ne-Google AmaSpredishithi noma i-LibreOffice Calc. Kubalulekile ukuba nohlelo oluhambisanayo noluthuthukisiwe ukugwema izinkinga lapho uvula ifayela.
Nika amandla amamakhro: Amafayela e-XLSM ngokuvamile aqukethe ama-macros, okuyizinhlelo ezincane noma imibhalo eyenza imisebenzi ku-Excel ngokuzenzakalelayo. Ukuqinisekisa ukuthi ama-macros asebenza kahle lapho uvula ifayela, udinga ukuwavumela. Ku-Excel, Kungenziwa lokhu ngokulandela izinyathelo ezilandelayo: amathuluzi -> amamakhro -> izinketho zokuphepha -> khetha "Vumela wonke amamakhro". Kubalulekile ukukhumbula ukuthi ama-macros angamela ubungozi bokuphepha, ngakho-ke kuyanconywa zinike amandla kuphela uma umthombo wefayela uthenjwa.
Hlola isimo sefayela: Ngaphambi kokuvula ifayela le-XLSM, liyanconywa qinisekisa ukuthi ifayela ayonakele noma lonakele. Lokhu kungenziwa ngokusebenzisa amathuluzi afana nokuhlola Ubuqotho ku-Excel, noma ngokusebenzisa izinhlelo zezinkampani zangaphandle ezikhethekile ekulungiseni amafayela e-Excel Ngaphezu kwalokho, kubalulekile ukuba nekhophi eyisipele yefayela uma kwenzeka kuba khona inkinga lapho uzama vula. Ukuthatha lezi zinyathelo zokuphepha kungasiza ukugwema ukulahleka kwedatha noma izinkinga ezingadingekile..
Izinkinga ezingenzeka zokuvula ifayela le-XLSM nezixazululo zazo
:
Ngezikhathi ezithile, abasebenzisi bangabhekana izinkinga lapho uzama ukuvula ifayela le-XLSM ku-Excel. Lawa mafayela aziwa ngele-“Microsoft Excel Macro-Enabled Workbook” futhi angase aqukathe amamakhro nokusebenza okuthuthukile. Nokho, kunezimo lapho amafayela e-XLSM angase akhiqize amaphutha lapho evulwa.
Enye yezinkinga ezivamile ukungahambisani kwenguqulo. I-Excel ingase ibe nobunzima bokuvula amafayela e-XLSM adalwe enguqulweni entsha noma endala yohlelo. Ukuxazulula lokhu, kuyanconywa buyekeza i-Excel enguqulweni yakamuva etholakalayo ukuze uqinisekise ukuhambisana nefayela le-XLSM elifunekayo. Ngaphezu kwalokho, ungakwazi futhi londoloza ifayela ngefomethi ejwayeleke kakhulu futhi ehambisanayo, njenge-XLSX, uma ungawadingi amandla amakhulu aqondene nefomethi ye-XLSM.
Enye inkinga engase iphakame uma uvula ifayela le-XLSM ukuba khona kwama-macros awonakele noma akhubazekile Ukuxazulula lokhu, ungazama ukunika amandla amamakhro kuzilungiselelo zokuphepha ze-Excel, inqobo nje uma uthemba umthombo wefayela. Uma ama-macros onakele, ungazama ukuvula ifayela endaweni ephephile futhi usebenzise amathuluzi okulungisa ama-macro ukulungisa inkinga.
Ngingu-Sebastián Vidal, unjiniyela wekhompyutha ozifelayo ngobuchwepheshe kanye ne-DIY. Ngaphezu kwalokho, ngingumdali we tecnobits.com, lapho ngabelana khona ngezifundo zokwenza ubuchwepheshe bufinyeleleke kakhudlwana futhi buqonde wonke umuntu.
Amazwana avaliwe.