Xa iifayile zeMicrosoft Excel (.xls, .xlw, .xlsx) zonakele okanye zonakele kwaye zingenakuvulwa, landela la manyathelo ukulungisa ifayile:
Phawula: Ngaphambi kwe-starqwalasela inkqubo yokubuyisela idatha, yenza ugcino lwefayile ye-Excel yoqobo.
- IMicrosoft Excel inomsebenzi wokulungisa eyakhelwe-ngaphakathi. Xa ifumanisa ukuba ifayile yakho ye-Excel yonakele, iya kuzama ukulungisa ifayile yakho. Kwezinye iimeko, ukuba umsebenzi awukho started ngokuzenzekelayo, unokunyanzela i-Excel ukuba ilungise ifayile yakho ngesandla. Thatha iExcel 2013 njengomzekelo, la manyathelo:
- nqakraza vula kwi ifayile menu.
- Kwibhokisi yencoko yababini evulekileyo, khetha ifayile, emva koko ucofe utolo olusecaleni kwe vula iqhosha.
- khetha Vula kwaye ulungise, emva koko ukhethe indlela yokubuyisela kwincwadi yakho yokusebenza.
- khetha Lungisa ukuba gcina ubuninzi bedatha evela ifayile eyonakele.
- If Lungisa iyasilela, sebenzisa Susa idatha ukufumana kwakhona idatha yeselula kunye neefomula.
Iinkqubo zokubuyisa zinokwahluka kancinane phakathi kweenguqulelo ze-Excel.
- Uvavanyo lwethu lubonisa ukuba indlela ye-1 isebenza kakhulu xa ukonakala kwefayile kwenzeka ekupheleni kwefayile. Kodwa ithande ukusilela ukuba urhwaphilizo lwenzeka kwiheader okanye kumacandelo aphakathi efayile.
- Ukuba indlela yoku-1 iyasilela, zama iindlela ezongezelelweyo zokulungisa ngesandla nge-Excel, njengokubhala i-VBA macro encinci. Ulwazi oluninzi lunokufumaneka kwiphepha lenkxaso likaMicrosoft: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
- Ezinye izixhobo zasimahla zomntu wesithathu zinokuvula kwaye zifunde iifayile ze-Excel ezonakeleyo, kubandakanya OpenOffice, LibreOffice, KingSoft Spreadsheets, yaye AmaSpredishithi eGoogle. Ukuba esinye sezi zixhobo sinokuvula ifayile yakho ngempumelelo, yigcine njengefayile entsha engenampazamo.
- Iifayile ze-xlsx zicinezelwe ngokwenene Zip iifayile. Ngoko ke, ngamanye amaxesha, ukuba urhwaphilizo lubangelwa kuphela yi Zip ifayile, zama ukusebenzisa i Zip isixhobo ukulungisa ezifana DataNumen Zip Repair:
- Yithiya ngokutsha ifayile ye-Excel eyonakeleyo (umzekelo, ukusuka kwi-myfile.xlsx ukuya kwifayile yam.zip).
- ukusebenzisa DataNumen Zip Repair ukulungisa ifayile yam.zip kwaye wenze myfile_fixed.zip.
- Yithiye kwakhona myfile_fixed.zip buyela kumyfile_fixed.xlsx.
- Vula myfile_fixed.xlsx kwi-Excel.
Ekuvuleni ifayile elungisiweyo kwi-Excel, usenokufumana izilumkiso ezimbalwa. Ungazihoyi, kwaye i-Excel iya kuzama ukuvula nokulungisa ifayile. Ukuba ifayile ivula ngempumelelo, gcina umxholo wayo kwifayile entsha engenampazamo.
- Ukuba zonke ezi ndlela zingasentla ziyasilela, sebenzisa DataNumen Excel Repair ukusombulula umba. Iya kuskena ifayile eyonakeleyo kwaye ivelise ifayile entsha engenampazamo ngokuzenzekelayo.