Sida aad ogtahay, faylka leh .xlsx kordhinta waa faylka Faylka Qaabka XML^{(XML Format Spreadsheet)} ee furan . Caadi ahaan waxa loo isticmaalaa in lagu kaydiyo xogta maaliyadeed iyo in la abuuro qaabab xisaabeed. Mararka qaarkood, waxay tuurtaa khalad aan caadi ahayn. Markaad isku daydo inaad furto, waxay ku tusinaysaa Waxaan ka helnay cilad ku jirta nuxurka^{(We found a problem with some content in filename.xlsx)} fariinta filename.xlsx. Markaad dhowr tillaabo raacdo, waxaad meesha ka saari kartaa dhibaatadan. Bal eeg sida!

Waxaan ka helnay dhibaato ka kooban waxyaabaha ku jira filename.xlsx

Cilada nuxurka waxa ay soo food saartaa marka faylka Excel uu xumaado. ^(Excel)Markaa, si aad u hagaajiso, waxaad u baahan doontaa -

1. Ku qaabbi ikhtiyaarka Xisaabinta ee ^{(Calculation)}Buugga^(Manual)
2. Nuqul ka samee XLS^{(Copy XLS)} si aad meesha uga saarto khaladka^(Content) qoraalka aan la akhriyin
3. U beddelashada qaabka soo kabashada faylka

1] Ku qaabbi^(Configure) ikhtiyaarka Xisaabinta^{(Calculation)} ee Buugga^(Manual)

Haddii ikhtiyaarka xisaabinta loo dejiyay mid toos ah, u beddel buug-gacmeed. Samaynta sidaas waxay sidoo kale ka ilaalin doontaa buugga shaqada inuu dib u xisaabiyo qiyamka tani waxay ka dhigi kartaa faylka la heli karo. Tan awgeed,

Guji ' File' menu of Excel ribbon bar oo dooro 'New' ikhtiyaarka menu-ka bidix ee bidix.

Dooro buugga shaqada 'Blank'. Marka uu furmo buug-shaqeedka cusub ee Excel , mar labaad dooro menu-ka ' ^{(Excel Workbook)}File ' oo markan dooro ' Options '.

Halkan, hoosta qaybta ' Formulas ', ka dooro ' Buugga^(Manual) ' ee xulashada xisaabinta^{(Calculation)} oo guji OK .

Xir shaashadda ' Options ', ku noqo feylka Excel , mar kale guji File menu oo dooro ' Fur^(Open) '.

Intaa ka dib, u gudub buugga shaqada ee musuqmaasuqa ka dibna laba-guji si aad u furto.

2] Nuquli XLS^{(Copy XLS)} si aad meesha uga saarto khaladka qoraalka aan la akhriyin^(Content)

Marka aad hesho "Waxaan ka helnay dhibaato ka kooban waxyaabaha ku jira <filename>" fariinta khaladka ah, waxaad sidoo kale arkaysaa isla markiiba kale oo codsanaya ogolaanshahaaga si aad isugu daydo una soo kabsato intii suurtogal ah? Haddii aad ku kalsoon tahay isha buugga shaqada, waxaad sii wadi kartaa adigoo gujinaya ' Haa^(Yes) ' badhanka.

Kadib, markaad isku dayeyso inaad furto buug- shaqeedka Excel^(Excel) , isku day inaad ka dhigto 'akhri kaliya' si aad u soo ceshato dhammaan nuxurka.

Raac tillaabooyinka-

1. Ku fur buug-shaqeedka Excel qaab ' akhri-kaliya^(read-only) '> isku day inaad koobiyayso waxa ku jira oo dhan.
2. Marka la dhammeeyo, samee buug-hawleed cusub oo ku dheji dhammaan waxa ku jira faylka kharribmay ee aad hadda nuqul ka samaysay faylka cusub.

Inta badan, khiyaanadani way shaqeysaa!

Haddii hababka kor ku xusan ay ku guuldareystaan ​​inay keenaan natiijooyinka la rabay, waxaad u wareegi kartaa Habka Soo kabashada Faylka^{(File Recovery Mode)} oo ah meesha ugu dambeysa.

3] U Beddelka Habka Soo kabashada Faylka

Guji liiska Faylka> Fur.

Ka baadho^(Browse) meesha lagu kaydiyo faylka kharribmay ama xumaaday. Guji

Marka sanduuqa wada-hadalku soo baxo, ku dhufo fallaadha hoos-u-dhaca ee ku dheggan ' Fur^(Open) ' ikhtiyaarka.

Halkan, dooro ikhtiyaarka ' Open and Repair'

Sidoo kale, haddii aad jeclaan lahayd inaad ka soo kabsato xogta buugga shaqada> dooro Data Extract^{(Extract Data)} . Tani waxay ka soo saari doontaa dhammaan qaacidooyinka suurtagalka ah iyo qiyamka buugga shaqada.

Marka la sameeyo, waxaad heli doontaa fariin xaqiijin ah.

Tani ma kuu shaqeysay?^{(Did this work for you?)}

We found a problem with some content in filename.xlsx error in Excel

As you knоw, a file with .xlsx extеnsion іs an open XML Fоrmat Spreadsheet file. It iѕ commonly used to store financial data and to create mathematical models. Sometimes, it throws аn unusual error. When you try to open it, it shows We found a problem with some content in filename.xlsx message. By following few steps, you can override this problem. See how!

We found a problem with some content in filename.xlsx

The content error is faced when the Excel file gets corrupted. So, to fix it, you’ll need to-

1. Configure Calculation option to Manual
2. Copy XLS to Remove Unreadable Content Error
3. Switching to File Recovery mode

1] Configure the Calculation option to Manual

If the calculation option has been set to automatic, change it to manual. Doing so will also prevent the workbook from recalculating the values and this can make file accessible. For this,

Click on ‘File’ menu of Excel ribbon bar and choose ‘New’ option from the left-side bar menu.

Select ‘Blank’ workbook. When the new Excel Workbook opens, again choose the ‘File’ menu and this time, select ‘Options’.

Here, under ‘Formulas’ category, select ‘Manual’ in Calculation options and click on OK.

Close the ‘Options’ screen, go back to the Excel file, click on File menu again and choose ‘Open’.

Thereafter, navigate to the corrupt workbook and then double-click to open.

2] Copy XLS to Remove Unreadable Content Error

When you get “We found a problem with some content in <filename>” error message, you also see another prompt seeking your permission to try and recover as much as possible? If you trust the source of the workbook, you can proceed further by clicking ‘Yes’ button.

Then, while trying to open an Excel workbook, try to make it ‘read only’ to recover its entire content.

Follow the steps-

1. Open Excel workbook in ‘read-only’ mode > try copying its entire contents.
2. Once done, create a new workbook and paste the entire contents from the corrupted file you just copied to the new file.

In most cases, this trick works!

If the above methods fail to yield the desired results, you can switch to File Recovery Mode as your last resort.

3] Switching to File Recovery Mode

Click File menu > Open.

Browse to the location where the corrupted or damaged file is saved. Click it.

When the dialog box appears, hit the drop-down arrow adjacent to ‘Open’ option.

Here, select ‘Open and Repair’ option.

Also, if you would like to recover data from the workbook > choose Extract Data. This will extract the entire possible formula and values from workbook.

Once done, you’ll get a confirmation message.

Did this work for you?

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel