Ua nalowale kāu faila Excel? ʻO ke alakaʻi piha i ka hoʻomaopopo ʻana a me ka pale ʻana i ka mālama ʻana i nā hewa

Ke pilikia nei ʻoe i ka mālama ʻana i kāu mau faila ma Excel? Hiki ke pilikia loa kēia kūlana, ʻoiai inā ua lōʻihi kou manawa e hana ai ma kāu pāpalapala a makaʻu ʻoe i ka nalowale ʻana o kāu mau loli. ʻO Microsoft Excel kekahi o nā mea hana i hoʻohana nui ʻia no ka hoʻokele ʻikepili a me ka nānā ʻana, no laila ʻO ka loaʻa ʻana o nā hewa i ka wā e hoʻāʻo ai e mālama i nā palapala kekahi o nā nīnau maʻamau a me ka hopohopo i waena o nā mea hoʻohana.

Ma kēiaʻatikala, e nānā mākou i nā mea a pau ʻO nā kumu hiki ke pale aku iā Excel mai ka mālama ʻana i kāu mau failaa e hāʻawi mākou i nā hāʻina kikoʻī no kēlā me kēia hihia. Ma ʻaneʻi ʻoe e ʻike ai ʻaʻole wale nā ​​kaʻina hana i kēlā me kēia ʻanuʻu, akā ʻo nā wehewehe wehewehe a me nā ʻōlelo kōkua e pale aku ai i kēia ʻano pilikia i ka wā e hiki mai ana. E noho, a na makou e wehewehe aku ia oe. pehea e ho'ōla ai mai kēia mau kūlana a pale aku iā lākou.

Pehea e hana ai ke kaʻina hana mālama ma Excel a no ke aha e hāʻule ai

Ma mua o ka hele ʻana i nā hoʻonā, pono e hoʻomaopopo pehea ʻo Excel e mālama ai i nā faila, no ka mea, ʻaʻole maʻalahi ke kaʻina hana e like me ka mea i ʻike ʻia. Excel, i ka wā e mālama lima ai ʻoe i kahi puke haʻawina, hana mua i kahi faila manawa ma kahi like me ka palapala kumu. Ke pau ka mālama ʻana, e holoi i ka faila kumu a hāʻawi i ka faila manawa i ka inoa pololei. Inā kū mai kekahi pilikia ma kēia kaʻina hana, hiki mai nā ʻano hewa like ʻole, a ʻaʻole mālama pono ʻia ka faila me nā loli hou.

Nā pilikia i ka mālama ʻana Hiki ke kumu no nā kumu he nui: mai ke kaomi ʻana i ke kī "Esc", pilikia lako, pilikia polokalamu, pilikia antivirus, paio ʻae, nā ala faila i lōʻihi loa, a i ʻole ka nele o ka wahi disk. Pono ʻoe e makaʻala i nā wahi pūnaewele a i ʻole nā ​​​​drives waho, me he mea lā ua nalowale ka pilina i ka wā e mālama ai ʻo Excel, hiki iā ʻoe ke hoʻopau i nā faila hewa a i ʻole nā ​​​​hoʻololi i mālama ʻole ʻia.

Nā memo hewa maʻamau i ka mālama ʻana i nā faila ma Excel

Ma waena o nā memo hewa maʻamau i ka wā ʻaʻole mālama ʻo Excel i ka faila, ʻo kēia ka mea e kū nei:

• "ʻAʻole i mālama ʻia ka palapala"
• "ʻAʻole i mālama pono ʻia ka palapala"
• "ʻAʻole hiki ke komo i ka palapala heluhelu wale nō. »
• "Paʻa piha"
• "Ua ʻike ʻia nā hewa i ka mālama ʻana..."
• "ʻAʻole kūpono ka inoa faila"

Hōʻike kēlā me kēia mau hewa i ke kumu like ʻole., no laila ʻoi aku ka maikaʻi e ʻike i ka memo pololei ma mua o ka ʻimi ʻana i ka hopena kūpono.

ʻO nā kumu nui ʻaʻole mālama ʻo Excel i nā loli

Wahi a nā palapala kūhelu, nā ʻaha kōkua a me nā ʻike mea hoʻohana, ʻO nā kumu maʻamau e hāʻawi ai ʻo Excel i nā pilikia i ka wā e mālama ai i nā faila:

• ʻAʻole ʻae ʻia ma ka waihona wahi: Inā ʻaʻole ʻoe i heluhelu, kākau, a hoʻololi paha i nā ʻae ma ka waihona āu e hoʻāʻo nei e mālama i ka puke hana, ʻaʻole hiki iā Excel ke hoʻopau i ka mālama.
• Pākuʻi ʻaoʻao ʻekolu: Hiki paha i kekahi mau mea hoʻohui i hoʻokomo ʻia ma Excel ke keʻakeʻa i ke kaʻina hana hoʻopakele, e hoʻoulu ai i nā ulia a i ʻole nā ​​​​hewa.
• Nā waihona i pōʻino a ʻino paha: Inā hewa ka faila kumu, hiki i ka Excel ke pale i ka mālama pono ʻana i nā loli.
• ʻAʻole lawa ka hakahaka disk: Inā ʻaʻohe wahi kaʻawale o ka wahi e hele ai, ʻaʻole hoʻopau ʻo Excel i ka hana mālama.
• Polokalamu Antivirus: Hiki i kekahi mau polokalamu antivirus ke ālai i ke kaʻina hana mālama, ʻoi aku ka nui inā nānā lākou i nā faila hou a hoʻololi paha i nā faila i wehe ʻia i ka wā o ka scan.
• Kaʻana like i nā paio a i ʻole nā ​​laka: Inā wehe ʻia ka faila e kekahi mea ʻē aʻe a i ʻole ma kahi ʻē aʻe o Excel, hiki mai nā hewa i ka wā e mālama ai.
• lōʻihi loa ke ala waihona: Ua kaupalena ʻo Excel i ka inoa faila me ke ala piha i 218 mau huaʻōlelo. Inā ʻoi aku, e loaʻa iā ʻoe kahi hewa inoa hewa.
• Nā pilikia pili i nā wahi pūnaewele: Inā mālama ʻoe i nā faila i kahi kaʻa pūnaewele a nalowale ka pilina, hiki ʻole ke hoʻopakele a nalowale ka ʻikepili hou.
• Nā waihona ma ke ʻano heluhelu-wale nō: Hiki i ka faila ke hoʻohana i kēia ʻano a ʻaʻole paha ʻoe ka mea nona, e kaupalena ana i ka hiki ke mālama iā ia me nā loli.
• Nā hewa paʻa (disk, USB drive, etc.): ʻO ka hemahema kino a i ʻole ka hemo ʻana o ke kaʻa i ka wā e mālama ai, hiki ke hana i nā hewa a me nā faila ʻino.
• Hoʻopaʻa ʻia nā faila e ka ʻōnaehana a i ʻole kekahi palapala noi: Inā hoʻohana ʻia ka faila e kekahi papahana ʻē aʻe, hiki iā ia ke pale i ka mālama ʻana.

Pehea e hoʻoponopono ai ʻaʻole mālama ʻo Excel i nā loli?

E noʻonoʻo pakahi kākou i nā hāʻina kūpono loa no kēlā me kēia hihia kikoʻī.

1. E nānā a hoʻololi i nā ʻae waihona

O ka mea mua loa E hōʻoia inā loaʻa iā ʻoe nā ʻae kūpono i ka waihona kahi āu e mālama ai i ka faila. Kaomi pololei ma ka waihona, koho Nā Kuleana, e komo i ka pā Ka malu a nānā i nā ʻae i hāʻawi ʻia i kāu mea hoʻohana. Inā ʻaʻohe āu ʻae kākau a hoʻololi paha, e noi i ka luna hoʻomalu o ka hui e hāʻawi iā ʻoe a i ʻole e hoʻāʻo e mālama i ka faila i kahi ʻē aʻe āu e loaʻa ai.

2. E mālama i ka faila ma ke ʻano he puke hana hou a i ʻole he inoa ʻē aʻe

ʻO kekahi o nā hana mua i ʻōlelo ʻia inā ʻaʻole ʻae ʻo Excel iā ʻoe e mālama ʻo ia ke hoʻohana i ke koho Mālama a hoʻololi i ka inoa faila a i ʻole ke ala. Ma kēia ala, ʻaʻole ʻoe e kāpae i ka faila kumu a pale aku i nā ulia a i ʻole nā ​​palena manawa. No ka hana ʻana i kēia:

1. E komo i ka waihona Pūnaewele a koho Mālama.
2. E hoʻokomo i kahi inoa ʻē aʻe a hoʻāʻo e mālama i kahi ʻokoʻa.

Hoʻohana pinepine ʻia kēia ʻano hana i ka wā o ka hakakā ʻana ma luna o nā ʻae, nā faila i hoʻopau ʻia, a i ʻole nā ​​ulia pōkole.

3. E hoʻoneʻe i nā pāpalapala kumu i kahi puke hana ʻē aʻe

Inā ʻike ʻia ka hewa a i ʻole ka mālama ʻole ʻana o ka faila, he ʻenehana kūpono e hoʻoneʻe i nā pepa a pau (koe wale nō hoʻokahi pepa hoʻopihapiha) i kahi puke hana hou. A) ʻAe:

1. E hoʻohui i kahi pepa hoʻopihapiha me Shift + F11.
2. E hui pū i nā pepa kumu a pau koe ka pepa hoʻopihapiha (e kaomi i ka mea mua, Shift-kaomi ma ka mea hope).
3. Kaomi pololei a koho Neʻe a kope paha… > koho (Buke hou) > E ae.

Ma kēia ala, hiki iā ʻoe ke mālama pinepine i ka faila hou me ka ʻole o nā hewa a hoʻihoʻi i nā ʻike āpau, me nā macros VBA, ma ke kope ʻana i nā modules ma ka lima. Inā makemake ʻoe e aʻo hou e pili ana i ka pale ʻana i nā hewa ma Excel, manaʻo mākou e nānā i kā mākou ʻatikala ma Nā hewa BitLocker ma Windows.

4. Mālama ma ke ʻano he ʻano faila ʻokoʻa (.xlsx, .xlsm, etc.)

I kekahi manawa ua ino ka waihona waihona kumu. Hiki i ka hoʻololi ʻana i ke ʻano faila ke hoʻoholo i ka pilikia. E hana i kēia:

1. En Pūnaewele, kaomi Mālama.
2. I ke koho ʻAno, koho i kekahi ʻano ʻokoʻa (no ka laʻana, .xlsm no nā faila me nā macros a i ʻole .xlsx ina he kumu .xls).

Me kēia hiki iā ʻoe ke hoʻopau i nā incompatibilities kahiko a i ʻole nā ​​hewa format.

5. E ho'āʻo e mālama i ka faila i kahi ʻē aʻe

Inā manaʻo ʻoe aia paha ka pilikia ma ka huakaʻi huakaʻi (no ka laʻana, kahi kaʻa waho, kahi kaʻa pūnaewele, a i ʻole kahi waihona i kaupalena ʻia), mālama i ka faila i ka papapihi a i ʻole kekahi waihona kūloko o kāu hui. Hoʻoponopono kēia i ka pili pūnaewele, nā ʻae, a i ʻole nā ​​pilikia ākea. Eia kekahi, inā he nīnau kāu e pili ana i ka hoʻihoʻi ʻana i nā faila i mālama ʻole ʻia, hiki iā ʻoe ke nānā i kā mākou kumu aʻo ma hoʻihoʻi hou i nā faila Word i mālama ʻole ʻia.

6. E mālama i nā faila hou i ka wahi kumu

E hana i kahi puke hana Excel hou a mālama i kope i loko o ka waihona hoʻokahi kahi i loaʻa ai ke kumu. Inā ʻaʻole hiki iā ʻoe, ʻo ka pilikia paha nā ʻae, lawa ʻole ka wahi ma ka drive, a i ʻole he paio polokalamu. Inā hiki iā ʻoe ke mālama i ka faila hou, aia paha ka pilikia me ke ʻano a i ʻole ka ʻike o ka waihona kumu.

7. E hoʻomaka i ka Excel ma ke ʻano palekana

Nui nā manawa Hoʻopilikia nā plugins ʻaoʻao ʻekolu i ka wā e mālama ai i nā faila. E hoʻāʻo inā ʻo kēia ke kumu:

• Koho 1: E kaomi a paa i ke ki Ctrl a wehe iā Excel, e hōʻoia i ka memo safe mode.
• Koho 2: Kaomi Windows + R, kakau ana ʻokoʻa / palekana a ku komo.

Inā hiki iā ʻoe ke mālama i ke ʻano palekana, hoʻopau a wehe i nā mea hoʻohui i kēlā me kēia a ʻike ʻoe i ka mea hewa. E hana i kēia:

1. E wehe maʻamau iā Excel.
2. Ka 'ike no Pūnaewele > koho > Hoʻopau.
3. Ma ka lalo, koho Nā plug COM a kaomi Ir.
4. Wehe i nā mea hoʻohui a pau a hoʻomaka hou iā Excel.

8. E nānā i ka hakahaka diski loaʻa

ʻO kekahi o nā kumu maʻamau, ʻaʻole lawa ka hakahaka. E hoʻohana i ka File Explorer e nānā i ka wahi i loaʻa. Inā piha, e hoʻokaʻawale i ka hakahaka ma ka hoʻokaʻawale ʻana i ka ʻōpala, ka holoi ʻana i nā faila no ka manawa lōʻihi, a i ʻole ka hoʻonui ʻana i ka pā me nā mea hana like. ʻ Masterlelo Māhele EaseUS a like paha.

9. Hoʻopau i ka polokalamu antivirus no kekahi manawa

Hiki i kekahi mau polokalamu antivirus ke ʻimi i nā faila hou a i ʻole nā ​​palapala i ka manawa maoli, e kāohi ana iā lākou mai ka mālama ʻana. Hoʻopau i kāu antivirus i ka wā e mālama ai, akā e hoʻomanaʻo e hoʻāla iā ia ma hope. Inā nalowale ka hewa, e nānā i kāu hoʻonohonoho antivirus e kāpae i nā waihona kahi āu e mālama ai i nā palapala Excel.

10. Hoʻoponopono i kāu hoʻonohonoho Office

Inā ʻaʻohe mea e hana, ʻino paha kāu hoʻonohonoho Office. No ka hoʻoponopono:

1. E hele i ka Control Panel > Programs and Features.
2. Huli Microsoft Office, kaomi ʻākau a koho Kaukaʻi.
3. Koho Hoʻoponopono wikiwiki (wikiwiki) a i ʻole Hoʻoponopono pūnaewele (hohonu).

A laila, e ho'āʻo e mālama hou i kāu mau faila Excel.

Nā hewa kikoʻī a me kā lākou hoʻonā

"ʻAʻole hiki ke kiʻi ʻia ka palapala heluhelu-wale."

ʻO kēia paha no ka mea ua kaha ʻia ka faila ma ke ʻano he heluhelu wale nō a i ʻole no ka laka ʻana o kahi mea ʻē aʻe. Nā pane:

• E hōʻoia iā ʻoe nā ʻae hoʻoponopono.
• E mālama i ka faila me kahi inoa ʻē aʻe a i ʻole ma kahi ʻē aʻe.
• E pani i nā manawa a pau o Excel a wehe hou i hoʻokahi wale nō.

"Ua piha ka diski"

E like me kā mākou i ʻōlelo ai, e hoʻokaʻawale i ka hakahaka ma ka drive a i ʻole e hoʻāʻo e mālama i kahi disk ʻē aʻe. Inā mālama ʻoe i nā drive waho, e hoʻomaopopo pono ua pili pono lākou a ʻaʻole e hemo i ka wā mālama.

"ʻAʻole kūpono ka inoa faila"

E nānā ʻaʻole ʻoi aku ke ala holoʻokoʻa (me nā waihona a me nā inoa faila) ma mua o 218 mau huaʻōlelo. Inā pēlā, e hoʻopōkole i ke ala ma ka mālama ʻana i ka faila ma kahi waihona kumu (e like me C: \) a hoʻohana i kahi inoa pōkole.

Nā hewa i ka mālama ʻana i nā wahi pūnaewele

Inā ʻoe e hana ana ma kahi pūnaewele a nalowale kāu pili i ka wā e hana ana, hiki i ka Excel ke pale i ka mālama ʻana a hōʻike pū i nā memo hewa e pili ana i nā ala pūnaewele hiki ʻole ke hiki. Inā loaʻa kēia:

• E mālama i ka faila ma ka ʻāina a kope hou ia i ka hoʻokele pūnaewele ke hoʻihoʻi ʻia ka pilina.
• Ma nā pūnaewele Windows, hiki iā ʻoe ke hoʻololi i ke kākau inoa no ka hoʻomaikaʻi ʻana i ke kūpaʻa ʻana i nā hoʻokuʻu ʻole ʻia.

Nā hewa e pili ana i Visual Basic for Applications (VBA)

Inā loaʻa i ka faila nā macros a i ʻole VBA a lilo i mea ʻino, Hiki iā ʻoe ke hoʻāʻo e hoʻoponopono iā ia ma ka holoi ʻana i nā papahana VBA i poino.. Ma ke ʻano he hopena holomua, Manaʻo ʻia e hana i kope kope a hoʻohana i nā mea hana noʻonoʻo no ka wehe ʻana i nā mea ʻino ma mua o ka wehe ʻana a mālama ʻana i ka palapala.

Nā pilikia me nā faila i pōʻino a palaho paha

Inā manaʻo ʻoe ua hewa kāu faile, loaʻa iā Excel kahi hana i wehe a hooponopono:

1. E wehe i ka Excel, hele i Pūnaewele > Wehe.
2. E koho i ka faila pilikia.
3. Ma ke pihi wehe, kaomi i ka pua i lalo a koho wehe a hooponopono.

I nā hihia paʻakikī, hiki iā ʻoe ke hoʻohana i nā mea hana ʻekolu e like me Wondershare Hoʻoponopono o Hana kū pono Stellar no Excel, ka mea e ʻae iā ʻoe e hoʻoponopono i nā faila i hōʻino ʻia ma o ka hoʻihoʻi ʻana i nā papa, nā formula a me nā mea ʻē aʻe.

Nā ʻōlelo aʻoaʻo pale a me ka hoʻihoʻi ʻana i nā faila i mālama ʻole ʻia

I mea e pale aku ai i ka lilo ʻana o kāu hana i ka wā e hiki mai ana, pono e:

• E ho'ā a hoʻonohonoho hoʻopaʻa auto: Ma kēia ala e mālama ai ʻo Excel i nā mana ʻokoʻa i kēlā me kēia manawa.
• E loulou i kāu moʻokāki Microsoft a hoʻohana iā OneDrive: Hāʻawi kēia iā ʻoe e mālama i nā kope kope ma ke ao.
• Hoʻoponopono i ka alapine mālama mālama ʻakomi: Hiki iā ʻoe ke hōʻemi i ka wā e hoʻonui ai i ka palekana o kāu ʻikepili.

Pehea e hoʻihoʻi ai i nā faila i mālama ʻole ʻia?

Inā pani ʻoe iā Excel me ka mālama ʻole, e hoʻāʻo i kēia mau ala:

• E wehe i ka Excel, hele i Pūnaewele > ʻIkepili > Mālama puke > E hoʻihoʻi i nā puke i mālama ʻole ʻia. Maʻaneʻi hiki iāʻoe ke loaʻa nā mana manawa.
• Huli i nā faila manawa ma C:\Users\YourName\AppData\Local\Temp (e hoʻololi i "YourName" i kou inoa inoa). Huli i nā faila me ka hoʻonui .tmp.

Hoʻonui kēia mau ʻano i ka manawa o ka hoʻihoʻi ʻana i kāu hana ma hope o kahi hāʻule i manaʻo ʻole ʻia.

Nā ʻōlelo aʻoaʻo a me nā hoʻopunipuni e pale aku i nā hewa i ka wā e hiki mai ana ma Excel

• E mālama mau i ka Office i nā lā e hoʻohana pono i nā pale palekana a me nā hoʻoponopono.
• Hōʻalo i ka hana ʻana i nā faila i mālama ʻia ma nā drive USB wale nō a i ʻole nā ​​wahi pūnaewele paʻa ʻole.
• Hana kope pinepine ma nā wahi like ʻole (kūloko, ao, kaʻa waho).
• E makaʻala i nā mea hoʻohui ʻekolu ʻaoʻao i hōʻoia ʻole ʻia a hoʻopau iā lākou inā ʻaʻole pono ʻoe iā lākou.
• E nānā i kāu wahi waihona ma mua o ka hana ʻana me nā faila nui.

ʻO kēia pūʻulu manaʻo kōkua i ka hōʻemi ʻana i nā hewa i ka wā e mālama ai ma Excel a mālama i ka pololei o kāu ʻikepili i nā manawa a pau.