Phoso ho romela taelo ho kopo ho Microsoft Excel: litsela tsa ho rarolla bothata

Ho sa tsotellehe hore, ka kakaretso, Microsoft Excel e na le botsitso bo phahameng ba mosebetsi, ka linako tse ling mathata a hlaha ka kopo ena. E 'ngoe ea mathata ana ke molaetsa "Phoso ha u romela taelo ho kopo." E etsahala ha o leka ho boloka kapa ho bula fono, hammoho le ho etsa ka liketso tse ling. A re boneng hore na ke eng e bakang bothata bona, le hore na e ka lokisoa joang.

Mabaka a phoso

Ke lisosa life tse kholo tsa phoso ee? Re ka khetholla tse latelang:

  • Tšenyo ho thepa ea motheo;
  • Leka ho fihlella dintlha tsa tshebediso e sebetsang;
  • Liphoso ho ngolisoeng;
  • Tšenyo ea Excel.

Bothata ba ho rarolla mathata

Litsela tsa ho felisa phoso ena li itšetlehile ka sesosa sa eona. Empa, maemong a mangata, ho thata haholo ho theha sesosa ho feta ho se felisa, tharollo e utloahalang haholoanyane ke ho leka mokhoa oa ho leka ho fumana tsela e nepahetseng ea khato ho tsoa ho khetho e hlahisitsoeng ka tlase.

Mokhoa oa 1: Thibela DDE Hlokomoloha

Hangata, hoa khoneha ho tlosa phoso ha u romela taelo ka ho thibela DDE ho hlokomoloha.

  1. E-ea tab "Fana".
  2. Tobetsa ho ntho "Lintho".
  3. Fensetereng ea meeli e butsoang, e-ea karolong e latelang "E tsoetseng pele".
  4. Re batla sekheo sa maemo "Kakaretso". Hlakola khetho "Hlokomoloha likōpo tsa DDE tse tsoang liketsong tse ling". Re hatella konopo "Ho lokile".

Ka mor'a moo, maemong a mangata, bothata bo felisoa.

Mokhoa oa 2: Koetlisa Mokhoa oa Ts'ebetsong

E 'ngoe e ka bang sesosa sa bothata bo ka holimo e ka ba matla a lumellanang le mokhoa. E le ho e thibela, u lokela ho lula u etsa mehato e ka tlase.

  1. Rea falla, re sebelisa Windows Explorer, kapa mookameli oa feshene leha e le efe, moo re ka fumanang pokello ea software ea Microsoft Office khomphuteng. Tsela e eang ho eona ke e latelang:C: Program Files Microsoft Office OFFICE ". Che. Ke palo ea ofisi ea ofisi. Ka mohlala, fensetere moo mananeo a Microsoft Office 2007 a bolokiloeng e tla ba OFFICE12, Microsoft Office 2010 ke OFFICE14, Microsoft Office 2013 ke OFFICE15, joalo-joalo.
  2. Ka fensetereng ea OFFICE, sheba fono ea Excel.exe. Re tobetsa ho eona ka konopo e nepahetseng ea mouse, mme ho menu e hlahang ho latela maemo re khetha ntho "Matlotlo".
  3. Ka fensetere ea thepa ea Excel e butsoang, e-ea tab "Ho lumellana".
  4. Haeba ho na le li-lebokose la li-checkbox ka pel'a ntho "Matha lenaneo ka mokhoa o lumellanang le"kapa "Matha lenaneo lena e le mookameli", joale u li tlose. Re hatella konopo "Ho lokile".

Haeba li-checkbox tse serapeng li sa tsamaisoe, joale tsoela pele ho batla mohloli oa bothata kae-kae.

Mokhoa oa 3: Registry Cleanup

E 'ngoe ea mabaka a ka etsang phoso ha u romella taelo ea kopo ho Excel ke bothata ho ngolisoeng. Kahoo, re tla hloka ho e hloekisa. Pele re tsoela pele ho etsa liketso tse ling e le hore re tsebe ho itšireletsa khahlanong le liphello tse sa rateheng tsa mokhoa ona, re khothalletsa ka tieo ho theha mokhoa oa ho tsosolosa ntlha.

  1. E le hore u hlahise fensetere ea "Matha", kenyelletsa motsoako oa senotlolo Tlanya + R lebokoseng. Ka fensetere e bulehileng, kenya molaetsa "RegEdit" ntle le litemana. Tobetsa konopo ea "OK".
  2. Registry Editor e bula. Ka lehlakoreng le letšehali la mohlophisi ke sefate sa lihlooho. E-ea ho boitsebiso "CurrentVersion" ka tsela e latelang:HKEY_CURRENT_USER Software Microsoft Windows CurrentVersion.
  3. Tlosa mafapha ohle a lengolong "CurrentVersion". Ho etsa sena, tobetsa fenseteng ka 'ngoe le konopo e nepahetseng ea mouse,' me u khethe ntho eo ho eona mohloong oa litaba "Tlosa".
  4. Ka mor'a hore ho tlosoa, qalisa k'homphieutha 'me u hlahlobe tshebetso ea Excel.

Mokhoa oa 4: Sireletsa lihlahisoa tsa hardware

Tharollo ea nakoana ea bothata e ka 'na ea tima khafetsa ea hardware Excel.

  1. Ho fallela karolong e seng e tloaelehile ho rona ka tsela ea pele ea ho rarolla bothata. "Lintho" tabeng "Fana". E boetse o tobetsa ntho "E tsoetseng pele".
  2. Ka har'a fensetere ea Excel e bulehileng e kentsoeng ka ho fetisisa, sheba li-setting tse thibelang "Screen". Beha letšoao le haufi le parameter "Thibela ho potlakisa setšoantšo sa hardware". Tobetsa konopo "Ho lokile".

Mokhoa oa 5: thibela litlatsetso

Joalokaha ho boletsoe ka holimo, e 'ngoe ea lisosa tsa bothata bona e ka ba ho se sebetse ha mofuta o mong oa ho kenyelletsa. Ka hona, e le tekanyo ea nakoana, o ka sebelisa ho thibela insel ho kenya letsoho.

  1. Hape, e-ea tab "Fana"ho ea karolong "Lintho"empa tobetsa nako ena ketsahalong Eketsa-ons.
  2. Ka tlase ea fensetere lenaneong le theoha "Tsamaiso"khetha ntho Litlhaloso tsa COM. Re hatella konopo "Tsamaea".
  3. Hlakola litlatsetso tsohle tse thathamisitsoeng. Re hatella konopo "Ho lokile".
  4. Haeba ka mor'a sena, bothata bo nyametse, hape re khutlela fensetereng ea add-ins COM. Beha letšoao, 'me u tobetsa konopo "Ho lokile". Hlahloba hore bothata bo khutlile. Haeba ntho e 'ngoe le e' ngoe e loketse, joale e-ea ho eketsa-kenang, joalo-joalo. Ho kenyelletsa-moo moo phoso e khutlang e holofetse, 'me ha e sa etsoa matla. Lisebelisoa tse ling kaofela li ka fuoa matla.

Haeba, ka mor'a ho koala lintho tsohle tse ling, bothata bo sala, sena se bolela hore li-add-on li ka buloa, 'me phoso e lokela ho ts'oaroa ka tsela e' ngoe.

Mokhoa oa 6: Khutlisetsa Lihlopha Tsa Lifilimi

U ka boela ua leka ho tsosolosa mekhatlo ea lifaele ho rarolla bothata.

  1. Ka konopo "Qala" ea ho "Panel Control".
  2. Ka Sethaleng sa Tsamaiso, khetha karolo "Mananeo".
  3. Fensetereng e butsoeng, e-ea karolong e latelang "Merero e fapaneng".
  4. Ka fensetere ea li-setting tsa lenaneo, u khetha ntho "Ho bapisa mefuta ea lifilimi le melaetsa ea mananeo a itseng".
  5. Lenaneng la lifaele, khetha khetho ea xlsx. Re hatella konopo "Fetola lenaneo".
  6. Lethathamong la mananeo a khothalletsoang a butsoeng, khetha Microsoft Excel. Tobetsa konopo. "Ho lokile".
  7. Haeba Excel e se lethathamong la mananeo a kgothaletsweng, tobetsa konopo "Tlhahlobo ...". Tsamaea tseleng eo re buileng ka eona, re buisane ka ho rarolla bothata ka ho khaotsa ho lumellana, 'me u khethe file ea excel.exe.
  8. Re etsa liketso tse tšoanang bakeng sa ho atolosoa ha xls.

Mokhoa oa 7: Fumana lisebelisoa tsa Windows le ho khutlisetsa Microsoft Office

Ntho ea ho qetela, ho ba sieo ha lifensetere tsa bohlokoa tsa Windows e ka 'na ea e-ba sesosa sa phoso ena Excel. Hoa hlokahala ho hlahloba hore na lisebelisoa tsohle tse fumanehang li kopitsoa 'me, ha ho hlokahala, kopitsa tse haellang.

  1. Khutlisa hape lebokose la taolo. Eya karolo "Tsamaiso le Tshireletso".
  2. Tobetsa ho ntho "Windows Update".
  3. Haeba ho na le molaetsa fensetereng e bulehileng mabapi le ho fumaneha ha lisebelisoa, tobetsa konopo "Kenya lisebelisoa".
  4. Re letetse lisebelisoa tse lokelang ho kenngoa, 'me re qalise k'homphieutha.

Haeba ha ho le e 'ngoe ea mekhoa ena e thusitseng ho rarolla bothata, joale ho ka' na ha e-ba molemo ho nahana ka ho tsosolosa sephutheloana sa software ea Microsoft Office, kapa esita le ho tsosolosa mokhoa oa ho sebetsa oa Windows ka kakaretso.

Joalokaha u ka bona, ho na le mekhoa e mengata ea ho felisa liphoso ha u romela taelo ho Excel. Empa, ka molao, maemong a mang le a mang ho na le tharollo e le 'ngoe feela e nepahetseng. Ka hona, e le ho felisa bothata bona, ho hlokahala ho sebelisa mokhoa oa teko ho sebelisa mekhoa e sa tšoaneng ea ho felisa phoso ho fihlela khetho e nepahetseng e fumaneha.