Muna cire fuska a cikin Microsoft Excel

Yanayin haɗi yana ba ka damar ci gaba da aiki tare da takardun Excel a cikin fasalin wannan shirin, koda kuwa an gyara su tare da kwafin wannan aikin. Ana samun wannan ta hanyar ƙayyade amfani da fasaha mara inganci. Amma wani lokaci ya zama wajibi don musaya wannan yanayin. Bari mu koyi yadda za mu yi haka, da yadda za mu yi wasu ayyuka.

Amfani da Yanayin Ƙari

Kamar yadda ka sani, Microsoft Excel yana da nau'i mai yawa, wanda farko ya dawo a shekarar 1985. An samu nasarar nasara a cikin Excel 2007, lokacin da ainihin tsarin wannan aikace-aikacen, maimakon xls ya zama xlsx. A lokaci guda akwai canje-canje mai mahimmanci a cikin ayyuka da ke dubawa. Ayyukan Excel na baya ba tare da matsaloli ba tare da takardun da aka yi a cikin takardun baya na shirin. Amma haɗin kai baya baya samun ci gaba. Saboda haka, ba a iya buɗe takardun da aka yi a Excel 2010 ba a Excel 2003. Dalilin shi ne cewa tsofaffi tsofaffi bazai iya tallafa wa wasu fasahar da aka kirkiro fayil din ba.

Amma wani halin da ake ciki yana yiwuwa. Ka ƙirƙiri fayil a cikin tsohuwar wannan shirin a kan kwamfutar daya, sa'an nan kuma gyara wannan takardun a kan wani PC tare da sabuwar version. Lokacin da aka canza fayil din zuwa tsohuwar kwamfuta, sai ya bayyana cewa ba ya bude ko a'a duk ayyukan suna samuwa a ciki, tun da canje-canjen da aka sanya shi ana tallafawa ne kawai ta aikace-aikace na karshe. Don kauce wa irin wannan yanayi mara kyau, akwai yanayin daidaitawa ko kuma, kamar yadda ake kira, ana iyakacin yanayin aiki.

Dalilinsa ya kasance a kan gaskiyar cewa idan ka gudu da fayil ɗin da aka tsara a cikin shirin tsofaffi na shirin, za ka iya yin canje-canje da shi kawai tare da taimakon fasahar da shirin ke haifar. Zaɓuɓɓuka ɗaya da umarni ta amfani da sababbin fasahohin da abin da tsarin mahaliccin ba zai iya aiki bazai samuwa ga wannan takarda ko da a aikace-aikace na zamani idan an kunna yanayin dacewa. Kuma a cikin irin wannan yanayi, ana iya sa ta tsoho kusan kullum. Wannan yana tabbatar da cewa ta hanyar dawowa aiki a cikin aikace-aikacen da aka kirkiro daftarin aikin, mai amfani zai iya bude shi kuma zai iya aiki sosai ba tare da rasa duk bayanan da aka shigar ba. Saboda haka, aiki a wannan yanayin, alal misali, a cikin Excel 2013, mai amfani zai iya amfani da waɗannan siffofin da Excel 2003 ke goyan baya.

Haɓaka Yanayin Ƙari

Don taimakawa yanayin daidaitawa, mai amfani baya buƙatar ɗaukar wani mataki. Shirin na kanta ya gwada takardun kuma ya ƙayyade fasalin Excel inda aka kirkiro shi. Bayan haka ya yanke shawara za ka iya amfani da dukkan fasahar da aka samo (idan suna goyon bayan waɗannan nau'i) ko sun hada da hane-haɗe a yanayin yanayin daidaitawa. A wannan yanayin, alamar da aka dace za ta bayyana a saman ɓangaren taga bayan da sunan takardun.

Musamman sau da yawa, ana iyaka yanayin da aka iyakance a yayin bude fayil a aikace-aikace na yau da aka halicce shi a Excel 2003 da kuma a cikin sassan farko.

Kashe Yanayin Ƙaddamarwa

Amma akwai lokuta idan dole ne a tilasta wajibi a tilasta yanayin haɗi. Alal misali, ana iya yin wannan idan mai amfani ya tabbata cewa ba zai koma aiki a kan wannan takarda ba a tsohuwar littafin Excel. Bugu da ƙari, ƙuntatawa za ta fadada aikin, da kuma samar da damar aiwatar da takardun ta amfani da fasahar zamani. Saboda haka sau da yawa akwai wata ma'ana a cire haɗin. Domin samun wannan dama, kana buƙatar canza abin da aka rubuta.

  1. Jeka shafin "Fayil". A gefen dama na taga a cikin toshe "Yanayin ƙayyadaddun ayyuka" danna maballin "Sanya".
  2. Bayan haka, akwatin kwance ya buɗe inda ya ce sabon littafi za a ƙirƙira wanda zai goyi bayan duk fasalulluwar wannan shirin, kuma tsohon zai ƙafe gaba ɗaya. Mun yarda ta danna kan maballin "Ok".
  3. Bayan haka sakon yana nuna cewa fasalin ya cika. Domin ya ɗauki sakamako, kana buƙatar sake farawa da fayil din. Muna danna maɓallin "Ok".
  4. Excel ya sake shigar da takardun kuma sannan zaka iya aiki tare da shi ba tare da wani hani akan ayyukan ba.

Yanayin haɗi a Sabon Fayiloli

Mun riga mun faɗi cewa ana amfani da yanayin dacewa ta atomatik lokacin da aka bude fayil ɗin da aka ƙaddamar a cikin version ta baya a cikin sabon ɓangaren shirin. Amma akwai kuma irin wannan yanayi da ya riga ya aiwatar da ƙirƙirar takardun aiki da aka kaddamar a cikin yanayin da aka ƙayyade aiki. Wannan shi ne saboda gaskiyar cewa Excel ta kunna fayilolin ceto ta hanyar tsohuwa a cikin tsari xls (Excel 97-2003 littafin). Domin samun damar ƙirƙirar tebur da cikakken ayyuka, kana buƙatar mayar da ajiyar ajiya a cikin tsari xlsx.

  1. Jeka shafin "Fayil". Gaba, muna matsa zuwa sashe. "Zabuka".
  2. A cikin matakan sigogi wanda ya buɗe, koma zuwa sashi "Ajiye". A cikin akwatin saitunan "Sauke Books"wanda yake a gefen dama na taga, akwai saiti "Ajiye fayiloli a cikin tsari mai zuwa". A cikin wannan matsala, muna canza darajar daga "Excel 97-2003 (* .xls)" a kan "Littafin aikin Excel (* .xlsx)". Don canje-canjen da za a yi, danna kan maballin "Ok".

Bayan waɗannan ayyukan, za'a kirkiro sabon takardun a cikin daidaitattun yanayin, kuma ba'a iyakance ba.

Kamar yadda kake gani, yanayin daidaitawa zai taimaka sosai wajen kaucewa rikice-rikice tsakanin software idan kuna aiki a kan takardu a cikin sassan Excel. Wannan zai tabbatar da amfani da fasaha na yau da kullum, kuma, sabili da haka, zai kare kariya daga matsalolin haɗin kai. A lokaci guda, akwai lokuta idan ana buƙatar wannan yanayin. Anyi haka ne sosai kuma bazai haifar da matsala ga masu amfani da suka saba da wannan hanya ba. Babban abu shine fahimtar lokacin da za a kashe yanayin haɗin kai, kuma lokacin da yafi kyau don ci gaba da aiki ta amfani da shi.