Excel daig - yuav ua li cas txuag cov ntaub ntawv

Qee lub sij hawm thaum ua hauj lwm nrog ib daim ntawv teev cov ntaub ntawv, nws tshwm sim tias qhov kev pab cuam freezes. Hauv cov xwm txheej no, cov lus nug tam sim no tshwm sim: "Yuav ua li cas khaws cov ntaub ntawv?". Muaj ntau txoj hauv kev los daws qhov teeb meem no. Nyob rau hauv tsab xov xwm, peb yuav soj ntsuam kom meej tag nrho cov kev xaiv uas txuag cov ntaub ntawv nyob rau hauv ib daig los yog txhob txwm kaw cov ntaub ntawv spreadsheet.

Restoreing cov ntaub ntawv ploj nyob rau hauv ib tug spreadsheet editor

Peb nco ntsoov tam sim ntawd tias koj tuaj yeem rov qab tau cov ntaub ntawv tsis tau khaws cia tsuas yog tias tsis siv neeg txuag tau qhib rau hauv daim ntawv teev cov editor. Yog tias qhov haujlwm no tsis tau qhib, ces tag nrho cov kev tswj hwm tau ua tiav hauv RAM, yog li nws yuav tsis tuaj yeem rov qab cov ntaub ntawv tsis tau khaws tseg. Los ntawm lub neej ntawd, tsis siv neeg txuag tau qhib. Hauv kev teeb tsa, koj tuaj yeem pom cov xwm txheej ntawm cov haujlwm no, nrog rau lub sijhawm teem sijhawm rau kev khaws cov ntaub ntawv sib kis.

Tseem ceeb! Los ntawm lub neej ntawd, kev txuag tsis siv neeg tshwm sim ib zaug txhua kaum feeb.

Txoj Kev Ib: Rov qab tau cov ntaub ntawv tsis tau khaws cia thaum qhov kev pab cuam Hangs

Cia peb xav txog yuav ua li cas rov qab tau cov ntaub ntawv yog tias cov ntawv kho mob tau khov. Cov lus qhia ntxaws ntxaws zoo li no:

  1. Rov qhib lub spreadsheet editor. Ib ntu yuav cia li tshwm nyob rau sab laug ntawm lub qhov rais, tso cai rau koj los kho cov ntaub ntawv. Peb yuav tsum tau nyem nrog rau sab laug nas khawm ntawm lub version ntawm cov ntaub ntawv tau txais kev cawmdim uas peb xav rov qab.
Excel daig - yuav ua li cas txuag cov ntaub ntawv
1
  1. Tom qab ua qhov no yooj yim manipulation, qhov tseem ceeb ntawm cov ntaub ntawv tsis tau khaws tseg yuav tshwm sim ntawm daim ntawv ua haujlwm. Tam sim no peb yuav tsum siv kev txuag. Txhawm rau ua qhov no, nyem rau ntawm lub icon floppy-zoo li tus, uas nyob rau sab laug sab sauv ntawm daim ntawv nthuav qhia cov ntaub ntawv interface.
Excel daig - yuav ua li cas txuag cov ntaub ntawv
2
  1. Lub qhov rais tshwm rau ntawm cov zaub nrog lub npe "Txuag Cov Ntaub Ntawv". Peb yuav tsum xaiv qhov chaw nyob qhov twg cov ntaub ntawv spreadsheet yuav raug cawm. Ntawm no, yog tias xav tau, koj tuaj yeem hloov kho lub npe ntawm daim ntawv nthuav dav, nrog rau nws qhov txuas ntxiv. Tom qab ua tiav tag nrho cov haujlwm, nyem rau ntawm "Txuag".
Excel daig - yuav ua li cas txuag cov ntaub ntawv
3
  1. Npaj txhij! Peb tau rov qab tau cov ntaub ntawv ploj lawm.

Qhov thib ob txoj kev: rov qab tau cov ntaub ntawv tsis tau khaws tseg thaum cov ntaub ntawv nthuav tawm raug kaw

Nws tshwm sim tias tus neeg siv tsis khaws cov ntaub ntawv, yuam kev kaw nws. Hauv qhov no, txoj hauv kev saum toj no yuav tsis tuaj yeem rov qab cov ntaub ntawv ploj. Txhawm rau rov qab, koj yuav tsum siv lub cuab yeej tshwj xeeb. Cov lus qhia ntxaws ntxaws zoo li no:

  1. Peb pib lub spreadsheet editor. Txav mus rau "Cov ntaub ntawv" submenu. Nyem LMB ntawm cov khoom "Tsis ntev los no", thiab tom qab ntawd rau ntawm "Rov qab Cov Ntaub Ntawv Tsis Tau Txais" yam khoom. Nws yog nyob rau hauv qab ntawm lub qhov rais tso saib interface.
Excel daig - yuav ua li cas txuag cov ntaub ntawv
4
  1. Kuj tseem muaj lwm txoj hauv kev. Txav mus rau "Cov ntaub ntawv" submenu, thiab tom qab ntawd nyem rau ntawm "Cov ntsiab lus" ntu. Hauv "Versions" nqis thaiv, nyem rau ntawm "Version Management". Hauv cov npe uas tshwm, nyem rau ntawm cov khoom uas muaj lub npe "Rov qab Unsaved Books".
Excel daig - yuav ua li cas txuag cov ntaub ntawv
5
  1. Ib daim ntawv teev cov ntaub ntawv tsis tau khaws cia tau tshwm sim ntawm qhov screen. Tag nrho cov npe ntawm cov ntaub ntawv spreadsheet tau txais cia li. Cov ntaub ntawv xav tau yuav tsum raug pom siv lub "Hnub hloov kho" kab. Xaiv cov ntaub ntawv xav tau nrog rau sab laug nas khawm, thiab tom qab ntawd nyem "Qhib".
Excel daig - yuav ua li cas txuag cov ntaub ntawv
6
  1. Cov ntaub ntawv xav tau yog qhib rau hauv daim ntawv teev cov editor. Tam sim no peb yuav tsum tau txuag nws. Nyem rau ntawm lub pob "Txuag Raws li" nyob rau ntawm daim kab xev daj.
Excel daig - yuav ua li cas txuag cov ntaub ntawv
7
  1. Lub qhov rais tshwm rau ntawm cov zaub nrog lub npe "Txuag Cov Ntaub Ntawv". Peb yuav tsum xaiv qhov chaw nyob qhov twg cov ntaub ntawv spreadsheet yuav raug cawm. Ntawm no, yog tias xav tau, koj tuaj yeem hloov kho lub npe ntawm daim ntawv nthuav dav, nrog rau nws qhov txuas ntxiv. Tom qab ua tiav tag nrho cov kev ua, nyem rau sab laug nas khawm "Txuag".
Excel daig - yuav ua li cas txuag cov ntaub ntawv
8
  1. Npaj txhij! Peb tau rov qab tau cov ntaub ntawv ploj lawm.

Txoj Kev Thib Peb: Qhib cov ntaub ntawv uas tsis tau khaws cia

Nyob rau hauv cov ntaub ntawv editor, koj tuaj yeem qhib cov ntawv sau ntawm cov ntaub ntawv tsis tau khaws cia manually. Txoj kev no tsis zoo li cov saum toj no, tab sis nws kuj tuaj yeem siv tau yog tias cov ntawv sau ua haujlwm tsis zoo. Cov lus qhia ntxaws ntxaws zoo li no:

  1. Qhib lub spreadsheet editor. Peb txav mus rau "Cov Ntaub Ntawv" submenu, thiab tom qab ntawd nyem lub pob laug nas ntawm lub "Qhib" lub caij.
Excel daig - yuav ua li cas txuag cov ntaub ntawv
9
  1. Lub qhov rais qhib ib daim ntawv yog tso tawm kom pom. Peb tsiv mus rau cov ntawv teev npe uas yuav tsum tau ua raws li hauv qab no: C:Usersимя_пользователяAppDataLocalMicrosoftOfficeUnsavedFiles. "Username" yog lub npe ntawm koj tus account operating system. Hauv lwm lo lus, qhov no yog ib daim nplaub tshev ntawm tus kheej lub computer uas muaj tag nrho cov ntaub ntawv tsim nyog. Ib zaug nyob rau hauv cov ntaub ntawv xav tau, peb xaiv cov ntaub ntawv xav tau uas peb xav rov qab los. Tom qab ua tiav tag nrho cov kauj ruam, nyem "Qhib".
Excel daig - yuav ua li cas txuag cov ntaub ntawv
10
  1. Cov ntaub ntawv peb xav tau tau qhib, uas tam sim no yuav tsum tau txais kev cawmdim. Peb nyem nrog rau sab laug nas khawm ntawm lub floppy-zoo li tus icon, uas yog nyob rau hauv sab laug sab ntawm lub spreadsheet daim ntawv interface.
  2. Lub qhov rais tshwm rau ntawm cov zaub nrog lub npe "Txuag Cov Ntaub Ntawv". Peb yuav tsum xaiv qhov chaw nyob qhov twg cov ntaub ntawv spreadsheet yuav raug cawm. Ntawm no, yog tias xav tau, koj tuaj yeem hloov kho lub npe ntawm daim ntawv nthuav dav, nrog rau nws qhov txuas ntxiv. Tom qab ua tiav tag nrho cov kev ua, nyem rau ntawm lub pob "Txuag".
  3. Npaj txhij! Peb tau rov qab tau cov ntaub ntawv ploj lawm.

Cov lus xaus thiab cov lus xaus txog cov ntaub ntawv rov qab

Peb pom tias muaj ntau txoj hauv kev los kho cov ntaub ntawv los ntawm cov ntaub ntawv nthuav dav hauv cov xwm txheej uas qhov kev zov me nyuam khov lossis tus neeg siv nws tus kheej kaw cov ntaub ntawv. Txhua tus neeg siv nws tus kheej tuaj yeem xaiv txoj kev yooj yim tshaj plaws rau kev rov qab cov ntaub ntawv ploj.

Sau ntawv cia Ncua