Uyilungisa njani iFayile ye-Excel eyonakeleyo okanye eyonakeleyo

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.

  1. 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:
    1. nqakraza vula kwi ifayile menu.
    2. Kwibhokisi yencoko yababini evulekileyo, khetha ifayile, emva koko ucofe utolo olusecaleni kwe vula iqhosha.
    3. khetha Vula kwaye ulungise, emva koko ukhethe indlela yokubuyisela kwincwadi yakho yokusebenza.
    4. khetha Lungisa ukuba gcina ubuninzi bedatha evela ifayile eyonakele.
    5. If Lungisa iyasilela, sebenzisa Susa idatha ukufumana kwakhona idatha yeselula kunye neefomula.

    Iinkqubo zokubuyisa zinokwahluka kancinane phakathi kweenguqulelo ze-Excel.

  2. 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.
  3. 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
  4. 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.
  5. 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:
    1. Yithiya ngokutsha ifayile ye-Excel eyonakeleyo (umzekelo, ukusuka kwi-myfile.xlsx ukuya kwifayile yam.zip).
    2. ukusebenzisa DataNumen Zip Repair ukulungisa ifayile yam.zip kwaye wenze myfile_fixed.zip.
    3. Yithiye kwakhona myfile_fixed.zip buyela kumyfile_fixed.xlsx.
    4. 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.

  6. Ukuba zonke ezi ndlela zingasentla ziyasilela, sebenzisa DataNumen Excel Repair ukusombulula umba. Iya kuskena ifayile eyonakeleyo kwaye ivelise ifayile entsha engenampazamo ngokuzenzekelayo.