Uyibuyisela njani kwakhona iFayile ye-Excel engagcinwanga

Ukuba ulahlekelwa yi-spreadsheet eyinkimbinkimbi ye-Excel ngenxa yokuphazamiseka kweprogram okanye idatha ebhalwe ngaphezulu, unokuphulukana neeyure zomsebenzi kunye nedatha yexabiso.

Ngethamsanqa, kwiimeko ezininzi kuyenzeka ukubuyisa iifayile ze-excel ayigcinwanga okanye ibhalwe ngaphezulu, njengokuba kunokwenzeka ukubuyisela iifayile ukusuka igama.

Esi sikhokelo siya kukubonisa inyathelo ngenyathelo into onokuyenza ukubuyisela ifayile ye-Excel engagcinwanga.

Unokufunda: Uwusebenzisa njani umsebenzi wokubala kwi-Excel

 

Uyifumana njani kwakhona ifayile ye-Excel engagcinwanga

1. Fumana kwakhona ifayile ye-Excel ebhalwe ngaphezulu nge-Excel Assurance

Kwiinguqulelo zangaphambili ze-Excel, i-backup yenziwe ngokuzenzekelayo xa ugcina ifayile. Olu gcino lusebenze njengokhuseleko kutshintsho olungengozi, kuba bekusoloko kusenzeka ukubuyisela inguqulelo yamva nje yefayile.

Kwiinguqulelo zangoku ze-Excel, olu khetho lusekho, kodwa lufihliwe ngandlel’ ithile, kuba ngoku kufuneka ukhankanye kwifayile nganye ukuba inokuba igcinwe ngomva. Olu khetho lunokumiselwa ngolu hlobo lulandelayo:

• Cofa kwi "Fayile" tab kwaye emva koko "Gcina njenge".
• Kwifestile elandelayo, khetha "Khangela" kunye nefolda apho ufuna ukugcina khona ifayile.
• Kwibhokisi yencoko ethi “Gcina njenge”, cofa ku-"Tools" kwaye emva koko kwi-"Settings General".
• Kule bhokisi yencoko yababini, khetha "Soloko usenza i-backup" kwaye qinisekisa ngokucofa "Kulungile".

Ukusukela ngoku ukuya phambili, i-backup iyakwenziwa ngokuzenzekelayo ngolwandiso lwe-XLK rhoqo xa uyigcina. Ukubuyisela le backup, Unokukhetha ezimbini: Ungabuyisela ulwandiso lwefayile yogcino ngolwandiso lweXLSX kwaye uvule ifayile njengesiqhelo. Unokukhetha kwakhona i Vula ukhetho kwiFayile ye-Excel thebhu. Cofa iqhosha elithi "Khangela" kwaye ujonge kwifolda apho ifayile ikhona.

Kwifestile yokukhetha ifayile ezantsi ngasekunene, khetha "Backups" endaweni ethi "Zonke iifayile ze-Excel". Ngoku unokubona zonke ii-backups kuloo folda kwaye uzivule ngokuthe ngqo ukuze uzigcine kwi-Excel.

Ingcebiso

Unako kwakhona ukuvula i "Vula" ukhetho usebenzisa i-Excel indlela emfutshane [Ctrl] + [O].

2. Fumana kwakhona iifayile ze-Excel ezingagcinwanga kwi-OneDrive

Ukuba ugcina iifayile ze-Excel ngaphakathi OneDrive Ukwabelana ngazo noogxa, ukusebenzisana okanye ukufikelela kuzo kwiikhompyuter ezininzi, sele unekopi ezenzekelayo yoguqulelo lwamva nje.

I-OneDrive ibonelela ngolawulo olululo lwenguqulelo, ukuze ukwazi ukufikelela kwiinguqulelo zamva nje ezigciniweyo zazo zonke iifayile zakho nangaliphi na ixesha. Ukwenza oku, landela la manyathelo alandelayo:

• Cofa ekunene ifayile oyifunayo kwifolda ye-OneDrive (kwiWindows Explorer). Windows).
• Khetha "Imbali yoHlelo" kwimenyu yomxholo. Apha unokubona iinguqulelo zamva nje ezigciniweyo zefayile.
• Cofa kwi icon enamachaphaza amathathu abonisa uhlobo olukhethiweyo. Ngoku ungabuyisa okanye ukhuphele ifayile ye-Excel ngegama layo loqobo, okanye uyigcine ngegama elahlukileyo ukuthelekisa ezi nguqulelo zimbini.

Ingcebiso

Microsoft 365 ukusuka kwi-IONOS sisisombululo seseva esifikelelekayo kubantu kunye namashishini amancinci, kuquka i-1 terabyte ye ukugcinwa kwi-OneDrive.

3. Fumana kwakhona ifayile ye-Excel ebhalwe ngaphezulu usebenzisa imbali yenguqulelo yeWindows

I Windows 10 yembali yenguqulelo ukhetho rhoqo (kwaye kwimeko yotshintsho olukhulu) igcina zonke iifayile kulawulo lwakho kwi-drive yangaphandle. Olu khetho alukhuseli kuphela kwi-hard drive urhwaphilizo okanye iintsholongwane, kodwa nasekubhaleni ngokungeyonjongo kweefayile.

Inkumbulo iyafuneka i-USB okanye idrayivu yenethiwekhi yokugcina idatha. Ukuba imbali yenguqulelo yenziwe, ungabuyisela ifayile ye-Excel endala ngolu hlobo lulandelayo:

• Khetha ifayile kwiWindows Explorer kwaye ucofe iqhosha elithi "Imbali" kwithebhu yaseKhaya.
• Iwindow iyavula ebonisa uguqulelo lokugqibela olugciniweyo lwefayile. Ungajonga phakathi kweenguqulelo ezahlukeneyo usebenzisa iintolo ezibekwe ekunene nasekhohlo kwefestile. Ngale ndlela, unokufezekisa ngokulula imeko efunwayo yefayile.
• Ngokucofa i icon yotolo olungqukuva embindini, ungabuyisela uguqulelo lwefayile. Oku kuya kubhala ngaphezulu uguqulelo lwangoku lwefayile. Unokucofa kwakhona igiya kwikona ephezulu ngasekunene kwaye ukhethe "Buyisela ku". Unokukhetha ngoku nasiphi na isiqulathi seefayili ofuna ukukopa kuso uguqulelo lwefayile.

Ingcebiso

Kukho indlela elula yokufikelela kwiinguqulelo zangaphambili zefayile ye-Excel: cofa ekunene ifayile kwiWindows kunye khetha u-“Properties” kwimenyu yomxholo. Unokujonga zonke iinguqulelo ezigciniweyo zefayile kwi "Iinguqulelo Zangaphambili" ithebhu yefestile. Ngoku unokubuyisela ifayile ngokucofa iqhosha elithi "Buyisela", okanye ugcine ikopi yalo kwenye ifolda.

4. Izicwangciso zembali yefayile

Ukuze indlela echazwe ngasentla isebenze, kufuneka uqale uqwalasele imbali yefayile kwiWindows:

• Yiya kwi "Backup" submenu kwimenyu ye "Uhlaziyo kunye nokhuseleko".
• Cofa iqhosha elithi "Yongeza iDiski" kwaye ukhethe idrayivu oyifunayo ukugcina idatha. Ukuba kukho i-hard drive yangaphandle efanelekileyo okanye i-network drive yokugcina imbali yefayile, iya kunikwa ngokuzenzekelayo.
• Sebenzisa ukhetho "Zigcinele ngokuzenzekelayo iifayile zam."
• Ukuba ukhetha olu khetho, imbali yefayile iya kwenziwa yangasemva.
• Cofa ku "Olunye ukhetho" kwaye emva koko "Eyogcino Ngoku" ukukhuphela ngoko nangoko idatha yakho ekhoyo kwi-backup drive. Kungenjalo, idatha yakho ayizukugcinwa de kube lutshintsho olulandelayo.
• Khetha iifolda ofuna ukuzigcina.
• Kuphela ziifayile ezingenakubuyiselwa ukuba zilahlekile zigcinwe kwimbali yefayile, hayi iinkqubo okanye iifayile zesistim. Iifolda zedatha eqhelekileyo sele zikhethelwe ngokuzenzekelayo ukugcinwa kwiprofayile yakho yomsebenzisi. KuKhetho Logcino unokongeza ezinye iifolda kukhetho, umzekelo, ukuba usebenzisa iifolda zeprojekthi ezingabekwanga kwisilawulo somsebenzisi kwihard drive.

5. Fumana kwakhona ifayile ye-Excel engagcinwanga

Ukuba i-Excel iyantlitheka ngelixa isebenza, okanye ukuba ngequbuliso unengxaki yamandla kwaye ulahlekelwe yifayile ngaphandle kokuyigcina, kukho iindlela zokufumana kwakhona ifayile esanda kugcinwa.

Ngokuqhelekileyo inokubuyiselwa nokuba ibingekagcinwa ngaphambili. Oku kungenxa yokuba zonke iinkqubo Microsoft Office Banenketho yogcino oluzenzekelayo. Ukuba i-Excel iyeka ukusebenza kwaye kwenzeka impazamo, inkqubo inika ukhetho ukubuyisela ifayile Excel ukusuka kugcino oluzenzekelayo ukuba ibingavalwanga ngokuchanekileyo kwixesha elidlulileyo.

Ungabuyisela ifayile ye-Excel kwifestile yokuQala ngolu hlobo lulandelayo:

• Ukuba ucofa iqhosha elithi "Show Recovered Documents", uya kubona uluhlu lweefayile ezivuliweyo zokugqibela ezingagcinwanga ngokuchanekileyo, kunye nexesha lokugqibela lokugcina.
• Ngonqakrazo olunye ungabuyisela ifayile oyifunayo.
• Nje ukuba uyifumene kwakhona ifayile, kuya kufuneka uyigcine kwakhona njengefayile ye-Excel, ekubeni ugcino oluzenzekelayo luya kususwa kwixesha elizayo i-Excel ivalwe ngempumelelo.

Unako kwakhona ukubuyisela iifayile ze-Excel ezingagcinwanga kamva:

Cofa "Ifayile" kwimenyu yeribhoni kwaye ukhethe "Lawula Incwadi Yokusebenzela" phantsi ko "Info."

Inketho ethi Buyisela Iincwadi Zokusebenzela ezingagcinwanga ikuvumela ukuba ukhethe kwaye ubuyisele iifayile ze-Excel ezingagcinwanga. I-Excel igcina utshintsho olungagcinwanga kwifolda ethi “C:USA”. Iifayile zinokufikelelwa apha.

Ugcino oluzenzekelayo luthintela ukulahleka kwedatha

I-Excel inendawo yokugcina idatha egcina utshintsho ngamaxesha aqhelekileyo. Nangona kunjalo, kufuneka uvule eli nqaku kwangaphambili:

• Fikelela kwiFayile thebhu uze ukhethe Khetha.
• Khetha ithebhu "Ifayile" kwaye Khetha "Useto". Khetha imenyu ethi "Gcina" kwaye ujonge "Gcina i-AutoRestore data yonke ...".
• Seta ikhefu elifunekayo, emva koko i-Excel kufuneka igcine idatha.
• Vula "Gcina ngokuzenzekelayo inguqulelo yokugqibela ebuyiselweyo ukuba ndiphuma ngaphandle kokugcina" ukhetho. Oku kwenza kube lula ukubuyisela ifayile ye-Excel yamva nje ukuba inkqubo ivala ngokungalindelekanga.

Unokufunda: Udityaniswa njani i-Excel neLizwi: Ngenisa iDatha ukusuka kwi-Excel ukuya kwiLizwi