Yana iya faruwa da ku ma.
Lokacin aiki tare da babban littafin aiki a cikin Excel, ba koyaushe kuna yin wani abu gaba ɗaya mara lahani ba (ƙara jeri ko saka babban guntun sel, alal misali) kuma ba zato ba tsammani zaku sami taga tare da kuskure "Yawancin tantanin halitta daban-daban. Formats":
Wani lokaci wannan matsala tana faruwa a cikin wani nau'i mara kyau. A daren jiya, kamar yadda kuka saba, kun adana kuma kun rufe rahoton ku a cikin Excel, kuma a safiyar yau ba za ku iya buɗe shi ba - ana nuna saƙo iri ɗaya da shawara don cire duk tsarawa daga fayil ɗin. Murna bai isa ba, yarda? Mu duba musabbabi da hanyoyin gyara wannan lamarin.
Me yasa hakan ke faruwa
Wannan kuskuren yana faruwa lokacin da littafin aikin ya wuce matsakaicin adadin tsarin da Excel zai iya adanawa:
- don Excel 2003 da tsofaffi - waɗannan nau'ikan 4000 ne
- don Excel 2007 da sababbi, waɗannan nau'ikan 64000 ne
Bugu da ƙari, tsarin a wannan yanayin yana nufin kowane nau'i na musamman na zaɓuɓɓukan tsarawa:
- sa
- cika
- tantanin halitta
- tsarin lamba
- Tsarin yanayi
Don haka, alal misali, idan kun sanya ɗan ƙaramin takarda kamar haka:
… to Excel zai tuna 9 daban-daban cell Formats a cikin littafin aiki, kuma ba 2, kamar yadda alama a farkon kallo, saboda lokacin farin ciki line kewaye kewaye zai haifar da, a gaskiya, 8 daban-daban tsara zažužžukan. Ƙara zuwa raye-rayen zanen tare da rubutu da cikawa, kuma sha'awar kyakkyawa a cikin babban rahoto zai haifar da ɗaruruwan da dubunnan nau'ikan haɗuwa iri ɗaya waɗanda Excel zai tuna. Girman fayil ɗin daga gare ta, da kanta, ma baya raguwa.
Irin wannan matsala kuma sau da yawa tana faruwa lokacin da kuka maimaita kwafin ɓangarorin wasu fayiloli zuwa cikin littafin aikinku (misali, lokacin haɗa zanen gado tare da macro ko da hannu). Idan ba a yi amfani da manna na musamman na dabi'u kawai ba, to, ana shigar da sifofin jeri da aka kwafi a cikin littafin, wanda da sauri ya kai ga wuce iyaka.
Yadda za a magance shi
Akwai hanyoyi da yawa anan:
- Idan kana da fayil na tsohon tsari (xls), to, sake adana shi a cikin sabon (xlsx ko xlsm). Wannan zai ɗaga mashaya nan da nan daga 4000 zuwa 64000 tsari daban-daban.
- Cire tsarin tantanin halitta mara amfani da ƙarin "kyawawan abubuwa" tare da umarnin Gida - Share - Share tsararru (Gida - Share - Share Tsara). Bincika idan akwai layuka ko ginshiƙai akan zanen gado waɗanda aka tsara gaba ɗaya (watau zuwa ƙarshen takardar). Kar a manta game da yiwuwar ɓoye layuka da ginshiƙai.
- Bincika littafin don ɓoyayyun zanen gado da manyan-boye-wani lokaci ana ɓoye su a kan “masu fasaha”.
- Cire tsarin yanayin da ba'a so akan shafin Gida - Tsarin Yanayi - Sarrafa Dokoki - Nuna Dokokin Tsara don Gabaɗaya Sheet (Gida - Tsarin Yanayi - Nuna ka'idoji don wannan takardar aikin).
- Bincika idan kun taru fiye da adadin salon da ba dole ba bayan kwafin bayanai daga wasu littattafan aiki. Idan akan tab Gida (Gida) A cikin jerin styles (Salo) babban adadin "datti":
... to, zaku iya kawar da shi da ƙaramin macro. Danna Alt+F11 ko button Kayayyakin aikin Basic tab developer (Mai haɓakawa), saka sabon tsari ta cikin menu Saka - Module kuma kwafi macro code a can:
Sub Reset_Styles() 'cire duk salon da ba dole ba Ga kowane objStyle A cikin ActiveWorkbook.Styles On Error Resume Gaba Idan Ba objStyle.BuiltIn Sannan objStyle.Delete Akan Kuskuren GoTo 0 Na gaba objStyle' Kwafi daidaitattun salo na salo daga sabon littafin aiki Saita wbrk Saita wbSabuwa = Littattafan Aiki.Ƙara wbMy.Styles.Haɗa wbSabuwar wbNew.Rufe adana canje-canje:=Ƙarshen Ƙarshen Ƙarya
Kuna iya ƙaddamar da shi tare da gajeriyar hanyar keyboard. Alt+F8 ko kuma ta hanyar maballin Macros (Macros) tab developer (Mai haɓakawa). Macro zai cire duk salon da ba a yi amfani da shi ba, yana barin daidaitattun saiti:
- Yadda ake Hana Kwayoyin Halitta ta atomatik tare da Tsarin Yanayi a cikin Excel
- Menene macros, inda kuma yadda ake kwafin macro code a cikin Visual Basic, yadda ake gudanar da su
- Littafin aikin Excel ya zama mai nauyi da jinkirin - yadda za a gyara shi?