Close
excel_logo

3.3.3. Tashqi bog’lanishlar

Tashqi bog’lanish hosil qilish | Ogohlantirish | Havolalar (link)ni tahriri qilish

Excelda tashqi bog’lanish bu – boshqa bir ish kitobining (Excel fayli) biror katak yoki sohasiga bog’lanishidir. Quyida uchta bo’limlarning fayllari topishingiz mumkin (North, Mid, South).

1north

2mid

3south


Tashqi bog’lanish hosil qilish

Tashqi bog’lanish hosil qilish uchun quyidagilarni amalga oshiring.

  1. Barcha ish kitoblarini (Excel fayllarni) oching.
  2. Company faylda, B2 katakni tanlang va barobar (=) belgisini kiriting.4tashqi_boglanish_misol
  3. Menyuning View (Вид) bo’limi, Window (Окно) guruhida, Switch Windows (Перейти в другое окно)ning ustiga bosing.5switch-windows
  4. North`ni ustiga bosing.6click-north
  5. North faylni ichida B2 katakni tanlang.7select-cell
  6. + belgisini kiriting.
  7. 3 dan 6 gacha qadamlarni Mid ish kitobi uchun takrorlang.
  8. 3 dan 5 gacha qadamlarni South ish kitobi uchun ham takrorlang.
  9. B2 katakdagi formuladan $ belgilarini olib tashlang.

Natija:

8external-references-result

10. Formulani boshqa kataklarga ko’chiring.


Ogohlantirish

Barcha ish kitoblarni yoping. Biror bo’limning ish kitobida (faylda) biror sonni o’zgartiring. Yana hamma fayllarni yoping. Company ish kitobini (faylni) oching.

  1. Barcha havolalarni yangilash uchun Enable Content (Включить это содержимое) bosing.
  2. Havolani yangilamaslik uchun esa, X ni bosing.

9enable-content

Izoh: agar siz boshqa bir ogohlantirishni ko’rsangiz, Update yoki Don’t Update’ni bosing.


Havolalarni tahrir qilish

Data (Данные) bo’limida, Connections (Подключения) guruhida Edit Links (Изменить связи) dialog oynasini ishga tushirish uchun Edit Links (Изменить связи)ni bosing.

9click-edit-links

  1. Agar havolalarni yangilamagan bo’lsangiz, siz havolalarni bu yerda yangilashingiz mumkin. Biror ish kitobini tanlang va shu ish kitobidagi havolalarni yangilash uchun Update Values ni bosing. Status qanday OK ga o’zgarganiga e’tibor bering.10update-values
  2. Agar siz o’sha ogohlantirish chiqishini xohlamasangiz va havolalarni avtomatik tarzda yangilamoqchi bo’lsangiz, Start Promt bosing, uchinchi variantni tanlang va OK ni bosing.

11dont-display-alert-update-links

North.xlsx

Mid.xlsx

South.xlsx

Company.xlsx

Manba: excel-easy.com

(140 marta o'qilgan, bugun 1 marta o'qildi)

O'xshash maqolalar:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: