Yadda za a gyara Excel fayil Ba za a iya samun aikin ko library Kuskuren

Lokacin amfani da MS Excel daftarin aiki ko MS Access cewa assimilate ayyuka ko mashiga wadda bukatar VBA (Kayayyakin Basic Aikace-aikace) ga Macros yin wasu sanya aiki, mai amfani iya samun wani tari kuskure "Ba za a iya samun aikin ko library" .

• Part 1: Mene ne dalilin wannan Kuskure?
• Part 2: yadda za a gyara cin hanci da rashawa Excel fayil
• Sashe na 3: Gyara MS Excel Fayil tare da Excel Gyara Tool

Part 1: Mene ne dalilin wannan Kuskure?

• Wannan kuskure ne yawanci lalacewa ta hanyar mai amfani da MS Access ko MS Excel shirin. Dalilin shi ne cewa shirin yana da wani tunani da wani abu, ko kuma irin library wanda ya bace ya kuma inganta ba a same ta da shirin. Haka kuma, shirin zai iya yin amfani da VB ko Micro kafaffun ayyuka ko mashiga. Saboda haka wani kuskure sakon da aka aiko.
• Wani lokaci a library iya toggled a kan ko toggled kashe haddasa wata samarwar mahada tsakanin dakin karatu da kuma shirin code. Saboda haka da tari kuskure aka bayar.
• Tun da akwai misali da dakunan karatu don haka m library sauti a bit na kalla damar. A wasu yiwu dalili, a wannan lõkacin, shi ne cewa library kuskure-wasa ne cikin hanyar kuskure. Alal misali, mai amfani iya samun library (zauna Outlook) version na shekarar 2007, amma da tunani a cikin code iya neman 2010 version of cewa takamaiman library. Saboda haka da shirin ya gaza nemo daidai library haka bayarwa wannan tari kuskure.
• Wani labari ga wannan sakon kuskuren da aka game da amfani da Microsoft XP da suka hada da wani tunani zuwa yanar gizo sabis a VBA aikin. A lokacin da ka gudu da wannan aikin a cikin MS Office 2003, wannan tari kuskure bayyana. A dalilin ne guda watau abu ko irin library ya bace (ko ba samu).

Part 2: yadda za a gyara cin hanci da rashawa Excel fayil

Ga yanayi daban-daban da wasu mafita domin kawo karshen matsalar ko don gyara gurbace Excel fayil ne ko da yaushe akwai. Kamar gano fitar da m library ko cikin hanyar mismatch idan ta wanzu. A library aka sa'an nan kuma kara ko a madadin da code iya rechecked danganta ga ya dace library.

Ta yaya za a iya yi?

Wadannan matakai:

Mataki 1. Open da MS Excel fayil, bada wani kuskure sako.

Mataki 2. Tabbatar da cewa takardar da cewa yana tsare ayyuka ko mashiga aka zaba.

Mataki 3. Latsa "Alt da F11 keys", domin VB Edita a cikin wani sabon taga (as kasa).

Mataki 4. Danna kan Tools menu ka kuma zaɓa References daga rũsa menu, kamar yadda aka nuna

Mataki 5. Bayan maganganu akwatin zai nuna 'Babu abu library ko irin' an nuna, kamar yadda aka nuna a kasa

Mataki 6. Kamar yadda a cikin sama nuni idan rajistan alamar wanzu tare da samarwar library, a cika shi da kuma danna OK

Mataki 7. Fita kuma ajiye asali Excel fayil.

Yanzu duba don tabbatar Game da ayyuka suna aiki yadda ya kamata.

Sashe na 3: Gyara MS Excel Fayil tare da Excel Gyara Tool

Ɓangare na uku Excel fayil gyara software ne akwai don warware duk irin waɗannan abubuwa da sauri da kuma sosai. Daya daga cikin Mafi Excel fayil Gyara software , a gyara da kuma warke lalace / m Excel fayiloli da aka bayyana a kasa.

Wannan Excel fayil gyara software akwai shi don guda, kazalika da mahara tsarin. Fayil gyara kayan aiki goyon bayan duk versions na windows da kuma goyon bayan Excel 2011 domin Mac. Wannan izni gyara gurbace Excel fayil (.XLS da .XLSX), da mayar da dukkan bayanai daga m zuwa wani sabon Excel fayil.

Mataki 1 Zabi m Excel fayil daga drive da search.

Mataki 2 Chooes daya ko duk m Excel fayil fara zuwa gyarawa tsari.

Mataki na 3 Preview da gyara Excel fayil.

Mataki na 4 Zaži fĩfĩta wuri don ajiye gyara Excel fayil.

Bugu da kari ga Excel Gyara Tool ko Excel fayil gyara software , 'yan dubaru na iya zama taimako ga sauri gyaran gaba daya (warke ko gyara gurbace Excel fayil).

Case 1. Lokacin da Excel fayil shi ne bude kokarin kowane daya daga su biyo.

1. Gwada a kan wani daban-daban kwamfuta
2. Kashe Auto-ajiye.
3. Kashe fayil sharing.
4. Kada gudu Excel daga floppy
5. Ajiye fayil a matsayin shafin yanar gizo da kuma sake bude shi a matsayin Excel fayil.

Case 2. Lokacin da Excel ba zai iya bude fayil, kokarin daya daga cikin wadannan.

1. Bude da cin hanci da rashawa fayil a wuya-drive. Kwafi daga floppy.
2. Nemo .xlb fayil. Har ila yau, ci gaba a madadin. Share .xlb. Sake kunnawa Excel.
3. Open fayil a MS kalma ko Notepad. Wannan zai bari ka warke data amma ba tsarawa
4. Tare da MS Excel 97/2000 viewer za ka iya duba data da kuma buga. Open fayil ta amfani da wannan free shirin zuwa mai da bayanai. Wannan shirin zai warke Tsarin kazalika cell dabi'u.
5. Amfani Excel XP. Wannan yana da mafi alhẽri zaɓuɓɓuka saboda maida.