Mwataya fayilo yanu ya Excel? Kalozera wathunthu womvetsetsa ndikupewa kupulumutsa zolakwika

Kodi mukuvutika kusunga mafayilo anu mu Excel? Izi zitha kukhala zokhumudwitsa, makamaka ngati mwakhala nthawi yayitali mukugwira ntchito pa spreadsheet yanu ndipo mukuwopa kutaya zosintha zanu zonse. Microsoft Excel ndi imodzi mwa zida zomwe zimagwiritsidwa ntchito kwambiri pakuwongolera ndi kusanthula deta, kotero Kukumana ndi zolakwika poyesa kusunga zolemba ndi imodzi mwamafunso omwe amapezeka kwambiri ndikudandaula pakati pa ogwiritsa ntchito.

M'nkhaniyi, tikambirana zonse Zomwe zingatheke zomwe zingalepheretse Excel kusunga mafayilo anundipo tidzapereka mayankho atsatanetsatane pamilandu iliyonse. Pano simudzapeza njira zowonongeka, komanso mafotokozedwe omveka bwino ndi malangizo othandiza kuti mupewe mavutowa m'tsogolomu. Bwerani, khalani ndipo tikufotokozereni. momwe mungachire kuzinthu izi ndikuzipewa.

Momwe njira yosungira imagwirira ntchito mu Excel komanso chifukwa chake ingalephere

Musanayambe kupeza mayankho, ndikofunikira kumvetsetsa momwe Excel imasungira mafayilo, popeza ndondomekoyi si yophweka monga momwe ikuwonekera. Excel, mukamasunga pamanja buku lantchito, choyamba imapanga fayilo yosakhalitsa pamalo omwewo monga chikalata choyambirira.. Kusunga kukamalizidwa, chotsani fayilo yoyambirira ndikupatsa fayiloyo dzina lolondola. Ngati pali vuto lililonse panthawiyi, zolakwika zosiyanasiyana zitha kuchitika, ndipo fayilo yomwe ili ndi zosintha zaposachedwa siyingasungidwe moyenera.

Zosokoneza pakupulumutsa zikhoza kukhala chifukwa cha zifukwa zambiri: kuchokera kukanikiza "Esc" fungulo, mavuto hardware, mavuto mapulogalamu, antivayirasi mavuto, mikangano chilolezo, wapamwamba njira yaitali kwambiri, kapena ngakhale kusowa litayamba malo. Muyeneranso kusamala ndi malo ochezera a pa Intaneti kapena ma drive akunja, ngati kuti kugwirizanako kutayika pamene Excel ikusunga, mutha kukhala ndi mafayilo owonongeka kapena kusintha kosasungidwa.

Mauthenga olakwika wamba mukasunga mafayilo mu Excel

Mwa mauthenga olakwika omwe amapezeka kwambiri pamene Excel sisunga fayilo, zotsatirazi zikuwonekera:

• "Chikalatacho sichinasungidwe"
• "Chikalatacho sichinapulumutsidwe kwathunthu"
• «Chikalata chowerengera chokha sichingapezeke. »
• "Diski Yonse"
• "Zolakwa zidadziwika posunga..."
• "Fayiloyo siyolondola"

Chilichonse cha zolakwika izi chimaloza ku zifukwa zosiyanasiyana., choncho ndi bwino kuzindikira uthenga weniweni musanafufuze njira yoyenera.

Zifukwa zazikulu zomwe Excel sichisunga zosintha

Malinga ndi zolembedwa zovomerezeka, mabwalo othandizira komanso zomwe ogwiritsa ntchito akumana nazo, Zifukwa zodziwika bwino zomwe Excel imapereka zovuta pakusunga mafayilo ndi:

• Kusowa zilolezo pa chikwatu kopita: Ngati mulibe kuwerenga, kulemba, kapena kusintha zilolezo pa foda yomwe mukuyesera kusunga buku la ntchito, Excel sidzatha kumaliza kusunga.
• Mapulagini Achipani Chachitatu: Zowonjezera zina zomwe zimayikidwa mu Excel zitha kusokoneza njira yopulumutsira, kupangitsa kuwonongeka kosayembekezereka kapena zolakwika.
• Mafayilo owonongeka kapena oyipa: Ngati fayilo yoyambirira ili ndi chinyengo, Excel ikhoza kulepheretsa kusintha kusungidwa bwino.
• Malo osakwanira a disk: Ngati malo omwe mukupita alibe malo aulere, Excel simaliza ntchito yosunga.
• Pulogalamu ya antivayirasi: Mapulogalamu ena a antivayirasi amatha kuletsa kusungirako, makamaka ngati asanthula mafayilo atsopano kapena kusintha mafayilo otseguka panthawi ya scan.
• Kugawana mikangano kapena maloko: Fayilo ikatsegulidwa ndi munthu wina kapena nthawi ina ya Excel, zolakwika zitha kuchitika posunga.
• Njira yamafayilo ndiyotalika kwambiri: Excel imachepetsa dzina la fayilo kuphatikiza njira yonse kukhala zilembo 218. Ngati ipitilira, mupeza dzina lolakwika.
• Mavuto amalumikizidwe m'malo a netiweki: Mukasunga mafayilo ku netiweki pagalimoto ndipo kulumikizana kutayika, kusungirako kungalephereke ndipo mutha kutaya zomwe zachitika posachedwa.
• Mafayilo owerengera okha: Fayilo ikhoza kukhala ndi mawonekedwe awa kapena simungakhale eni ake, ndikuchepetsa kuthekera kosunga ndi zosintha.
• Zolakwika za Hardware (disk, ma drive a USB, etc.): Kulephera kwakuthupi kapena kutsekedwa kwa galimoto pamene mukusunga kungayambitsenso zolakwika ndi kuwonongeka kwa mafayilo.
• Mafayilo otsekedwa ndi dongosolo kapena pulogalamu ina: Ngati fayiloyo ikugwiritsidwa ntchito ndi pulogalamu ina, ikhoza kulepheretsa kusunga.

Kodi mungakonze bwanji Excel osasunga zosintha?

Tiyeni tikambirane imodzi ndi imodzi njira zothetsera vuto lililonse.

1. Onani ndikusintha zilolezo za foda

Choyambirira Onetsetsani kuti muli ndi zilolezo zokwanira mufoda momwe mumasungira fayilo. Dinani kumanja pa chikwatu, sankhani Propiedades, pezani tabu chitetezo ndikuyang'ana zilolezo zomwe zaperekedwa kwa wogwiritsa ntchito. Ngati mulibe chilolezo cholembera kapena kusintha, funsani woyang'anira gulu kuti akupatseni kapena yesani kusunga fayilo kumalo ena komwe muli nawo.

2. Sungani fayilo ngati buku latsopano kapena dzina lina

Chimodzi mwazochita zoyambilira pamene Excel sichikukulolani kusunga ndikugwiritsa ntchito njirayo Sungani monga ndikusintha dzina la fayilo kapena njira. Mwanjira iyi, mumapewa kulembanso fayilo yoyambirira ndikupewa kuwonongeka kapena malire a nthawi. Kuchita izi:

1. Pezani menyu Archivo ndikusankha Sungani monga.
2. Lowetsani dzina lina ndikuyesera kulisungira kumalo ena.

Njira imeneyi imakhala yothandiza ngati mikangano ili chifukwa cha zilolezo, mafayilo osakhalitsa oyipa, kapena kuwonongeka kwakanthawi.

3. Sunthani ma spreadsheets oyambilira kupita ku bukhu lina lantchito

Ngati fayilo ikuwoneka kuti yawonongeka kapena ikulephera kusunga, njira yothandiza ndi sunthani mapepala onse (kupatula pepala lodzaza limodzi) kupita ku bukhu lantchito latsopano. Chifukwa chake:

1. Onjezani pepala lodzaza ndi Kuloza + F11.
2. Gwirizanitsani mapepala onse oyambirira kupatula pepala lodzaza (dinani pa yoyamba, Shift-dinani lomaliza).
3. Dinani kumanja ndikusankha Sunthani kapena Koperani… > sankhani (Buku Latsopano) > Landirani.

Mwanjira iyi, mutha kusunga fayilo yatsopanoyo popanda zolakwika ndikubwezeretsa zonse, kuphatikiza ma VBA macros, potengera ma module ndi dzanja. Ngati mukufuna kudziwa zambiri zamomwe mungapewere zolakwika mu Excel, timalimbikitsa kuwunikanso nkhani yathu Zolakwika za BitLocker mu Windows.

4. Sungani ngati mtundu wina wa fayilo (.xlsx, .xlsm, etc.)

Nthawi zina mawonekedwe a fayilo amawonongeka. Kusintha mtundu wa fayilo kumatha kuthetsa vutoli. Kuchita izi:

1. En Archivo, atolankhani Sungani monga.
2. Muzochita Lembani, sankhani mtundu wina (mwachitsanzo, .xlsm kwa mafayilo okhala ndi macros kapena alireza ngati choyambirira chinali .xls).

Ndi izi mutha kuchotsa zosagwirizana zakale kapena zolakwika zamtundu.

5. Yesani kusunga fayilo kumalo ena

Ngati mukuganiza kuti vuto lingakhale pagalimoto yomwe mukupita (mwachitsanzo, drive yakunja, network drive, kapena foda yoletsedwa), sungani fayilo ku desktop kapena foda ina yakwanuko wa timu yanu. Izi zimachotsa maukonde, zilolezo, kapena vuto la danga. Komanso, ngati muli ndi mafunso okhudza kubwezeretsa mafayilo osasungidwa, mutha onani phunziro lathu pa bwezeretsani mafayilo a Mawu osasungidwa.

6. Sungani mafayilo atsopano kumalo oyambirira

Pangani buku latsopano la Excel ndikusunga kopi mufoda yomweyi pomwe choyambirira chinali. Ngati simungathe, vuto mwina ndi zilolezo, malo osakwanira pagalimoto, kapena mkangano mapulogalamu. Ngati mutha kusunga fayilo yatsopanoyo, vuto lingakhale ndi mawonekedwe kapena zomwe zili patsamba loyambalo.

7. Yambitsani Excel mumayendedwe otetezeka

Nthawi zambiri Mapulagini a chipani chachitatu amachititsa mavuto posunga mafayilo. Kuyesa ngati ichi ndi chifukwa:

• Njira ya 1: Dinani ndi kugwira kiyi Ctrl ndi kutsegula Excel, kutsimikizira uthenga mode otetezeka.
• Njira ya 2: Press Windows + R, alemba opambana / otetezeka ndi kumenya Enter.

Ngati mutha kusunga mumayendedwe otetezeka, zimitsani kapena chotsani zowonjezera chimodzi ndi chimodzi mpaka mutapeza wolakwa. Kuchita izi:

1. Tsegulani Excel bwino.
2. menyu Archivo > options > Zomangira.
3. Pansi, sankhani COM mapulagini ndikusindikiza Ir.
4. Chotsani zonse zowonjezera ndikuyambitsanso Excel.

8. Onani malo a disk omwe alipo

Chimodzi mwa zifukwa tingachipeze powerenga alibe malo okwanira ufulu. Gwiritsani ntchito File Explorer kuti muwone malo omwe alipo. Ngati yadzaza, masulani malo pochotsa zinyalala, kuchotsa mafayilo osakhalitsa, kapena kukulitsa magawowo ndi zida monga. EaseUS Partition Master kapena ofanana.

9. Kuletsa kwakanthawi antivayirasi mapulogalamu

Mapulogalamu ena a antivayirasi amatha kusanthula mafayilo kapena zikalata zatsopano munthawi yeniyeni, ndikuletsa kwakanthawi kuti zisungidwe. Zimitsani kwakanthawi antivayirasi yanu mukusunga, koma kumbukirani kuyiyambitsa pambuyo pake. Ngati cholakwikacho chizimiririka, yang'anani makonda anu a antivayirasi kuti muchotse zikwatu momwe mumasungira zikalata za Excel.

10. Konzani kuyika kwa Office yanu

Ngati palibe chomwe chikugwira ntchito, kukhazikitsa kwanu kwa Office kumatha kuwonongeka. Kukonza:

1. Pitani ku Control Panel> Mapulogalamu ndi Zinthu.
2. Sakani Office Microsoft, dinani kumanja ndikusankha Kukonza.
3. Sankhani Kukonza mwachangu (mwachangu) kapena Kukonza pa intaneti (Zamitsani).

Pambuyo pake, yesani kusunganso mafayilo anu a Excel.

Zolakwa zenizeni ndi zothetsera

"Chikalata chowerengera chokha sichingapezeke."

Izi zitha kukhala chifukwa chakuti fayiloyo imalembedwa kuti iwerengedwe-yokha kapena chifukwa china yakhoma. Zothetsera:

• Onetsetsani kuti muli ndi zilolezo zosintha.
• Sungani fayiloyo ndi dzina lina kapena malo ena.
• Tsekani zitsanzo zonse za Excel ndikutsegulanso imodzi yokha.

"Disk yadzaza"

Monga tanenera, tsegulani malo pagalimoto kapena yesani kusunga ku diski ina. Ngati musunga ku ma drive akunja, onetsetsani kuti alumikizidwa bwino ndipo musakhale olumikizidwa pakusunga.

"Fayiloyo siyolondola"

Onetsetsani kuti njira yonse (kuphatikiza zikwatu ndi mayina a mafayilo) sipitilira zilembo 218. Ngati ndi choncho, fupikitsani njirayo posunga fayilo mufoda ya mizu (monga VS: \) ndikugwiritsa ntchito dzina lalifupi.

Zolakwika posunga malo a netiweki

Ngati mukugwira ntchito pa netiweki ndikutaya kulumikizana kwanu mukamagwira ntchito, Excel ikhoza kukulepheretsani kupulumutsa komanso kuwonetsa mauthenga olakwika okhudza njira zomwe sizingafikike. Ngati izi zichitika:

• Sungani fayilo kwanuko ndi kukopera izo kubwerera kwa netiweki pagalimoto pamene kugwirizana kubwezeretsedwa.
• Pa ma netiweki a Windows, mutha kusintha kaundula kuti muthe kulimba mtima pakutha mwangozi.

Zolakwa zokhudzana ndi Visual Basic for Applications (VBA)

Ngati fayiloyo ikuphatikiza ma macros kapena VBA ndikuwonongeka, Mutha kuyesa kukonza ndikuchotsa ntchito zomwe zawonongeka za VBA.. Monga njira yowonjezera, Ndibwino kuti mupange kopi yosunga zobwezeretsera ndikugwiritsa ntchito zida zowonera zosungirako zokhazikika kuti muchotse zida zachinyengo musanatsegulenso ndikusunga chikalatacho.

Mavuto ndi mafayilo owonongeka kapena owonongeka

Ngati mukuganiza kuti fayilo yanu ndi yachinyengo, Excel imaphatikizapo ntchito kuti kutsegula ndi kukonza:

1. Tsegulani Excel, pitani ku Archivo > Tsegulani.
2. Sankhani wapamwamba vuto.
3. Pa batani lotseguka, dinani muvi wakumunsi ndikusankha kutsegula ndi kukonza.

Muzovuta zovuta, mutha kugwiritsa ntchito zida za chipani chachitatu monga Wondershare kukonza o Kukonza kwa Stellar kwa Excel, zomwe zimakupatsani mwayi wokonza mafayilo owonongeka pobwezeretsa matebulo, ma fomu ndi zinthu zina.

Malangizo oteteza ndi kubwezeretsa mafayilo osasungidwa

Kuti mupewe kutaya ntchito m'tsogolomu, ndikofunikira:

• Yambitsani ndikusintha autosave: Mwanjira iyi Excel imasunga zosintha zokha nthawi ndi nthawi.
• Lumikizani akaunti yanu ya Microsoft ndikugwiritsa ntchito OneDrive: Izi zimakupatsani mwayi wosunga zosunga zobwezeretsera zokha mumtambo.
• Sinthani ma frequency osungira okha: Mutha kuchepetsa nthawi kuti muwonjezere chitetezo cha data yanu.

Momwe mungabwezeretsere mafayilo osasungidwa?

Ngati mudatseka Excel osasunga, yesani njira izi:

• Tsegulani Excel, pitani ku Archivo > Information > Sinthani buku > Bweretsani mabuku omwe sanasungidwe. Apa mungapeze zomasulira zosakhalitsa.
• Sakani mafayilo osakhalitsa mkati C:\Users\YourName\AppData\Local\Temp (sinthani "YourName" ku dzina lanu lolowera). Sakani mafayilo okhala ndi zowonjezera .tmp.

Njirazi zimawonjezera mwayi wobwezeretsanso ntchito yanu mutalephera mosayembekezereka.

Malangizo ndi zidule kuti mupewe zolakwika zamtsogolo mu Excel

• Nthawi zonse khalani ndi Office yatsopano kugwiritsa ntchito mwayi pazigamba zachitetezo ndi kukonza.
• Pewani kugwira ntchito pamafayilo osungidwa pama drive a USB okha kapena malo osakhazikika pa intaneti.
• Pangani makope pafupipafupi m'malo osiyanasiyana (komweko, mtambo, kuyendetsa kunja).
• Chenjerani ndi zowonjezera zosatsimikizika za chipani chachitatu ndikuzimitsa ngati simukuzifuna.
• Yang'anani malo anu osungira musanagwire ntchito ndi mafayilo akuluakulu.

Izi zolimbikitsa imathandizira kuchepetsa mwayi wa zolakwika pakusunga mu Excel ndi kusunga kukhulupirika kwa deta yanu nthawi zonse.