Fariinta qaladka ah ee caadiga ah ee badanaa dhacda marka qof isku dayo inuu furo faylka Excel gudaha ^(Excel)Windows waa Excel ma furi karo faylka sababtoo ah qaabka faylka ama kordhintu ma shaqeynayo^{(Excel cannot open the file because the file format or extension is not valid)} . Hubi in feylku aanu kharribanayn iyo in fidinta faylka la mid yahay qaabkiisa. Fariintan khaladka ah waxay la kulmaa gaar ahaan marka faylka uusan la socon nooca Excel ama uu xumaado^(corrupted) . Aan isku dayno inaan hagaajino arrintan.

Excel ma furi karo faylka sababtoo ah qaabka faylka ama kordhintu maaha mid sax ah

Fariintan khaladka ah waxa ay la kulantay xaaladaha soo socda:

Faylku wuu xumaaday ama wuu dhaawacmay
Faylku kuma habboona nooca Excel .

Qaladka Excel waxaa lagu hagaajin karaa mid ka mid ah 3da hab ee soo socda ee hoos lagu sharaxay.

Beddel kordhinta faylka
Isticmaal Furaha^(Open) iyo Dayactirka Tilmaamaha^{(Repair Feature)} ee Excel
Beddel ogolaanshaha kooxda

Aynu si faahfaahsan u baadhno hababka kor ku xusan!

1] Beddel kordhinta faylka

Dooro kordhinta XML

Haddii aadan ka furi karin faylka Excel meesha uu ku yaal, si fudud u fur fayl kasta oo Excel ah oo guji File tab.

Ka dib, u tag Open > Browse oo dooro qaladka faylka.

Hoosta magaca faylka^(File) , ka beddel kordhinta '.xlsx' una beddel '.xls' oo badbaadi.

Isku day inaad mar kale furto faylka.

2] Isticmaal^(Use) furaha iyo^(Open) dib u hagaajinta^(Repair) ee Excel

Fur oo dayactir

Ku dhufo File tab oo hoos ugu dhaadhac ikhtiyaarka furan .^(Open)

Dooro badhanka Browse iyo sanduuqa wada hadalka ee soo muuqda, dooro feylka Excel ee muujinaya fariinta khaladka ah.

Hadda, dhagsii badhanka hoos u dhaca oo dooro fur ^(Open)iyo dayactir^{(Open and Repair)} liiska.

Faylkaaga Excel waxaa laga eegi doonaa wixii waxyeelo ah^{(Excel file will be checked for any damage)} ama musuqmaasuq ah oo isla markiiba la hagaajiyaa.

3] Beddel ogolaanshaha kooxda

Midig ku dhufo^{(Right-click)} faylka Excel oo aadan furi karin oo dooro Properties .

Marka uu soo baxo wada-hadalka Guryaha^(Properties) , u beddel dhinaca Ammaanka^(Security) .

Guryaha Faylka ee Excel

Ku dhufo badhanka^(Edit) wax ka beddel si aad u bedesho oggolaanshaha.

Marka uu furmo wada hadalka Oggolaanshaha^{(Permissions)} faylka , raadi oo guji badhanka ku dar^{(Add )} .

Ficilka, marka la xaqiijiyo furi doona cusub Xulo Isticmaalayaasha ama kooxaha^{(Select Users or Groups)} sanduuqa wada hadalka. Hoostiisa, hel badhanka Sare .^(Advanced)

Intaa ka dib, guji Find Now si aad u muujiso dhammaan isticmaalayaasha iyo kooxaha.

Dooro Isticmaalayaasha

Qof kasta^(Everyone) ka dooro liiska, ka dibna riix OK.

Guji OK markale

Hadda, markaad dib ugu noqotid wada hadalka Ogolaanshaha^{(Permissions)} , waxaad ogaan doontaa in kooxda Qof kastaa^(Everyone) lagu lifaaqay liiska isticmaaleyaasha.

Dooro kooxda qof walba^(Everyone) , calaamadee dhammaan sanduuqyada ku hoos jira Oggolow^(Allow) , ka dibna, ku dhufo badhanka Codso^(Apply) si aad u isticmaasho isbeddellada.

Hadda^(Hereafter) ka dib, waa inaad awood u yeelatid inaad furto faylka Excel dhib la'aan.^(Excel)

Excel cannot open the file because the file format or extension is not valid

A common error meѕsage that usually occurs whеn somеone tries tо open an Excel file in Windows is Excel cannot open the file because the file format or extension is not valid. Make sure the file is not corrupted and that the file extension matches its format. This error message is encountered especially when the file is either not compatible with the Excel version or it is corrupted. Let’s try to fix this issue.

This error message is encountered in the following scenarios:

The file has become corrupt or damaged
The file is not compatible with the Excel version.

The error in Excel can be fixed by any one of the following 3 methods described below.

Change the file extension
Use the Open and Repair Feature in Excel
Change group permissions

Let’s explore the above methods in a bit of detail!

1] Change the file extension

Select XML extension

If you cannot open the Excel file from its location, simply open any Excel file and click the File tab.

Then, go to Open > Browse and select the file giving error.

Under the File name field, change the extension from ‘.xlsx’ to ‘.xls’ and save it.

Try opening the file again.

2] Use the Open and Repair feature in Excel

Open and repair

Hit the File tab and scroll down to the Open option.

Select the Browse button and in the dialogue box that appears, choose the excel file that is showing the error message.

Now, click the Open drop-down button and select the Open and Repair option from the list.

Your Excel file will be checked for any damage or corruption and fixed immediately.

3] Change group permissions

Right-click the Excel file that you cannot open and select Properties.

When the Properties dialog shows up, switch to the Security tab.

Excel File Properties

Hit the Edit button to change permissions.

Once the file’s Permissions dialog opens, find and click the Add button.

The action, when confirmed will open a new Select Users or Groups dialog box. Under it, locate the Advanced button.

Thereafter, click Find Now to display all users and groups.

Select Users

Choose Everyone from the list, and then click OK.

Click OK again.

Now, when you go back to the Permissions dialog, you’ll notice that the Everyone group has been attached to the user list.

Select the Everyone group, check all the boxes under Allow, and then, hit the Apply button to apply the changes.

Hereafter, you should be able to open the Excel file without any problems.

Riley Norman

About the author

Waxaan ahay xamaasad Windows Phone ah, oo waxaan ka shaqaynayey horumarinta habab cusub oo loo isticmaalo nidaamka qalliinka in ka badan 10 sano hadda. Waxaan si qoto dheer u fahmay sida Microsoft Office u shaqeeyo, iyo sidoo kale sida ugu badan ee looga faa'iidaysto Edge. Khibradayda taleefannada casriga ah waxay sidoo kale ii ogolaataa inaan horumariyo xiriir adag oo aan la yeesho macaamiisha iyo shaqaalaha aan wada-shaqeynta, taas oo muhiim u ah xirfad kasta.

Excel ma furi karo faylka sababtoo ah qaabka faylka ama kordhintu maaha mid sax ah

Excel ma furi karo faylka sababtoo ah qaabka faylka ama kordhintu maaha mid sax ah

1] Beddel kordhinta faylka

2] Isticmaal^(Use) furaha iyo^(Open) dib u hagaajinta^(Repair) ee Excel

3] Beddel ogolaanshaha kooxda

Excel cannot open the file because the file format or extension is not valid