Chotsani buku la Excel lomwe silinasungidwe

Mukamagwira ntchito ku Excel, wogwiritsa ntchito pazifukwa zosiyanasiyana sangakhale ndi nthawi yosunga idatha. Choyamba, zimatha kuyambitsa magetsi, mapulogalamu ndi zovuta zina. Palinso zochitika pamene wogwiritsa ntchito wopanda nzeru asindikiza batani m'malo mopulumutsa buku mukatseka fayilo mu bokosi la zokambirana "Osapulumutsa". Muzochitika zonsezi, nkhani yobwezeretsa chikalata cha Excel chomwe sichinasungidwe chimakhala chofunikira.

Kubwezeretsa deta

Zofunika kudziwa nthawi yomweyo kuti mutha kubwezeretsa fayilo yosasungidwa pokhapokha pulogalamuyo ikatha. Kupanda kutero, pafupifupi zochita zonse zimachitidwa mu RAM ndikuchira sizotheka. Autosave imatseguliridwa mwachisawawa, komabe, ndikwabwino ngati mungayang'ane momwe muliri mumayendedwe kuti mudziteteze kwathunthu pazinthu zilizonse zosasangalatsa. Ngati mungafune, muthanso kupanga pafupipafupi kukhala ndi zikalata zodziwikiratu kupulumutsa nthawi zambiri kumeneko (ndikosankha, kamodzi mphindi 10).

Phunziro: Momwe mungakhazikitsire Autosave ku Excel

Njira 1: kubwezeretsa chikalata chosasungidwa pambuyo pake

Pakasokonekera ka kompyuta kapena pulogalamu ya pakompyuta, kapena pakagwa magetsi nthawi zina, wosuta sangathe kusunga bukhu la Excel lomwe anali kugwirapo ntchito. Zoyenera kuchita?

1. Dongosolo litakhala kuti libwezeretsedwa kwathunthu, tsegulani Excel. Mbali yakumanzere yenera ukangomaliza kukhazikitsa, gawo loyambitsalo lizitsegukira zokha. Ingosankha mtundu wa chikalata chokhazikika chomwe mukufuna kubwezeretsa (ngati pali zosankha zingapo). Dinani pa dzina lake.



2. Pambuyo pake, zidziwitso kuchokera mufayilo yosasungidwa ziwonetsedwa pa pepalalo. Kuti mugwiritse ntchito njira yopulumutsira, dinani pazithunzi mu mawonekedwe a diskette pakona yakumanzere kwa zenera la pulogalamuyo.



3. Tsamba lopulumutsa buku limatsegulidwa. Sankhani komwe fayilo ili, ngati kuli kotheka, sinthani dzina lake ndi mtundu. Dinani batani Sungani.

Pa kuchira izi zitha kuonedwa kuti zatha.

Njira yachiwiri: kubwezeretsa buku losasungidwa mukatseka fayilo

Ngati wogwiritsa ntchito sanasunge bukulo osati chifukwa chakugwira ntchito mwadongosolo, koma kokha chifukwa litatsekedwa, adakanikiza batani "Osapulumutsa", ndiye kuti mubwezeretse njira yomwe ili pamwambapa sigwire ntchito. Koma, kuyambira ndi mtundu wa 2010, Excel ilinso ndi chida china chofanana chobwezeretsera deta.

1. Yambitsani Excel. Pitani ku tabu Fayilo. Dinani pazinthu "Zaposachedwa". Pamenepo dinani batani "Bwezerani deta yosasungidwa". Ili kumapeto kwenikweni kwa theka lamanzere la zenera.

   

   Pali njira ina. Kukhala mu tabu Fayilo pitani pagawo laling'ono "Zambiri". Pansi pa gawo lapakati pazenera mu parbar block "Mavesi" dinani batani Kutanthauzira Kwapa. Pamndandanda womwe umawonekera, sankhani Bwezeretsani Mabuku Osapulumutsidwa.



2. Njira iliyonse yomwe mungasankhe, zitatha izi mndandanda wa mabuku omwe sanapulumutsidwe umatsegulidwa. Mwachilengedwe, dzinalo limapatsidwa kwa iwo zokha. Chifukwa chake, buku liti likufunika kubwezeretsedwanso, wosuta ayenera kuwerengera nthawi, yomwe ili mgulu Tsiku Losinthidwa. Pambuyo pa fayilo yomwe yasankhidwa, dinani batani "Tsegulani".



3. Pambuyo pake, buku losankhidwa limatsegulira ku Excel. Koma, ngakhale idatsegulidwa, fayiloyo ndiyopulumutsidwa. Kuti mupulumutse, dinani batani Sungani Mongayomwe ili pa tepi yowonjezera.



4. Windo loyika fayilo yokhazikika limatsegulidwa, momwe mungasankhire malo ndi mtundu wake, komanso kusintha dzina. Chisankho chikapangidwa, dinani batani Sungani.

Bukuli lidzasungidwa patsamba lowerengeredwa. Izi zibwezeretsa.

Njira 3: Mwatsegulani Buku Lopulumutsidwa

Palinso njira yotsegulira mafayilo osasungidwa pamanja. Zachidziwikire, njirayi sioyenera monga njira yapita, komabe, nthawi zina, mwachitsanzo, ngati magwiridwe antchito awonongeka, ndi njira yokhayo yobwezeretsanso deta.

1. Timayamba Excel. Pitani ku tabu Fayilo. Dinani pa gawo "Tsegulani".



2. Chikalata chotsegulira zenera chikuyamba. Pa zenera ili, pitani ku adilesi ndi template ili:

   C: Ogwiritsa username AppData Local Microsoft Office UnsavedFiles

   Adilesi, mmalo mwa phindu "lolowera", muyenera kusintha dzina la akaunti yanu ya Windows, ndiye dzina la chikwatu pakompyuta ndi zidziwitso za ogwiritsa ntchito. Mukasamukira kuchikwama chomwe mukufuna, sankhani fayilo yomwe mukufuna kuti mubwezeretsenso. Kanikizani batani "Tsegulani".



3. Buku litatsegulidwa, timasungira pa disk momwemonso zomwe zidatchulidwa kale pamwambapa.

Mutha kupita ku chosungira cha mafayilo osungidwa mu Windows Explorer. Ichi ndi chikwatu chotchedwa Osapulumutsidwa. Njira yopita kumeneko yawonetsedwa pamwambapa. Pambuyo pake, sankhani chikalata chomwe mukufuna kuti mubwezeretse ndikudina pa batani lakumanzere.

Fayilo ikuyambitsidwa. Timasunga mosalekeza.

Monga mukuwonera, ngakhale mutakhala kuti simunasunge buku la Excel ngati kompyuta yasokonekera kapena ngati mwatseka kusungira mukatseka, pali njira zingapo zobwezeretsanso deta. Mkhalidwe waukulu wakuchira ndikuphatikizidwa kwa autosave mu pulogalamuyi.