Uma amafayela e-Microsoft Excel (.xls, .xlw, .xlsx) onakele noma onakele futhi engakwazi ukuvulwa, landela lezi zinyathelo ukuze ulungise ifayela:
Qaphela: Ngaphambi kuka-starukulinganisa inqubo yokutholwa kwedatha, dala ikhophi yasenqolobaneni yefayela lokuqala elonakele le-Excel.
- I-Microsoft Excel inomsebenzi wokulungisa owakhelwe ngaphakathi. Uma ithola ukuthi ifayela lakho le-Excel lonakele, izozama ukulungisa ifayela lakho. Kwezinye izimo, uma umsebenzi ungeyena u-started ngokuzenzakalelayo, ungaphoqa i-Excel ukuthi ilungise ifayela lakho mathupha. Thatha i-Excel 2013 njengesibonelo, izinyathelo yilezi:
- Chofoza Vula ku Ifayela imenyu.
- Ku-Vula ibhokisi lengxoxo, khetha ifayela, bese uchofoza umcibisholo oseceleni kwe Vula inkinobho.
- Khetha Vula futhi Lungisa, bese ukhetha indlela yokutakula yebhuku lakho lokusebenza.
- Khetha Ukulungisa kuya hlenga inani eliphezulu ledatha kusuka ifayela elikhohlakele.
- If Ukulungisa ehluleka, sebenzisa Khipha idatha ukubuyisa idatha yeselula namafomula.
Izinqubo zokubuyisela zingahluka kancane phakathi kwezinguqulo ze-Excel.
- Ukuhlolwa kwethu kwembula ukuthi indlela 1 isebenza ngokuyinhloko lapho ukonakala kwefayela kwenzeka ekupheleni kwefayela. Kodwa kuvame ukwehluleka uma ukonakala kwenzeka kunhlokweni noma ezigabeni ezimaphakathi zefayela.
- Uma indlela yoku-1 yehluleka, zama izindlela zokulungisa ezengeziwe ngesandla nge-Excel, njengokubhala i-VBA macro encane. Ulwazi olwengeziwe lungatholakala ekhasini losekelo le-Microsoft: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
- Amanye amathuluzi amahhala ezinkampani zangaphandle angavula futhi afunde amafayela onakele e-Excel, okuhlanganisa I-OpenOffice, I-LibreOffice, I-KingSoft Spreadsheets, Futhi AmaSpredishithi e-Google. Uma elinye lalawa mathuluzi lingavula ifayela lakho ngempumelelo, lilondoloze njengefayela elisha elingenaphutha.
- amafayela we-xlsx empeleni acindezelwe Zip amafayela. Ngakho-ke, ngezinye izikhathi, uma inkohlakalo ibangelwa kuphela Zip ifayela, zama ukusebenzisa i-a Zip ukulungisa ithuluzi ezifana DataNumen Zip Repair:
- Qamba kabusha ifayela le-Excel elonakele (isb, ukusuka ku-myfile.xlsx kuya ku-myfile.zip).
- Sebenzisa DataNumen Zip Repair ukulungisa myfile.zip futhi ukhiqize i-myfile_fixed.zip.
- Qamba kabusha i-myfile_fixed.zip buyela ku-myfile_fixed.xlsx.
- Vula myfile_fixed.xlsx ku-Excel.
Lapho uvula ifayela elilungisiwe ku-Excel, usengahlangabezana nezixwayiso ezimbalwa. Ungawanaki, futhi i-Excel izozama ukuvula nokulungisa ifayela. Uma ifayela livuleka ngempumelelo, gcina okuqukethwe kwalo efayelini elisha elingenaphutha.
- Uma zonke izindlela ezingenhla zihluleka, sebenzisa DataNumen Excel Repair ukuxazulula udaba. Izoskena ifayela eyonakele futhi ikhiqize ifayela elisha elingenaphutha ngokuzenzakalelayo.