Results 1 to 2 of 2

Thread: How can find where is the excel sheet is link with error sheet(there source is lost)?

  1. #1
    bigbose is offline Senior Member+
    Last Online
    6th September 2022 @ 01:08 AM
    Join Date
    24 Jan 2010
    Age
    38
    Posts
    176
    Threads
    56
    Credits
    1,404
    Thanked
    11

    Default How can find where is the excel sheet is link with error sheet(there source is lost)?



    when i open two links sheet in excel 2003 in opening time its show three option 1. update. 2. do not update . 3 cancel
    when we click on update then again show continue or edit link.
    when we click on edit link then open one dialog box there so many option
    i.e break link ,update value ,change source,check status. etc..

    but some time we miss some link file .
    then its show Error in source not found.
    note : i have a some many sheet in one workbook

    my question is that . how can find where is the sheet is link with error sheet ( there source is lost) ?
    and cell how can find?

    thanks
    Pls Help meeeee



  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Ye error zayada tar us soorat m aata ha k aap ne aik sheet ka data dosre sheet m calculate karne k leye sumif ya indirect ya "=" k formula istimal keye hon. Kyon k jab bhee aap file open karte hain tu excel automatic sheet ko recalculate karta ha jis ki wajha se ye error ata ha. Is ka hal ye ha k aap tool--->option--->claculation----> k option m ja kar automatic calculation k check box ko khatam kar dain ya manual select karain.

    Dosra agar aap sumif k formula ya indirect ya kisi aur kism k formula istimal karte hain tu in ko sumproduct k version se change kar dain. Kiyon k sumproduct close work book se bhee calculation kar leta ha.
    Teesra ye k aap agar dono files ko link rakhna chahte hain tu aap workgroup ka option istimal karain. aur khayal rakhain k files aik he directory m ho.

    regards

Similar Threads

  1. Excel aik Sheet se dosri sheet mein data up date kerna
    By riazanjum09 in forum General Discussion
    Replies: 2
    Last Post: 16th January 2014, 01:15 AM
  2. Need Help For Excel Sheet Error
    By shahid_s1 in forum Ask an Expert
    Replies: 8
    Last Post: 17th July 2012, 12:16 AM
  3. Help Me About Excel Sheet
    By Imran sid in forum Ask an Expert
    Replies: 1
    Last Post: 6th December 2010, 10:43 AM
  4. Aik Excel Sheet Say Data Dosri Sheet Main Daikhna !!!
    By sannan in forum General Discussion
    Replies: 13
    Last Post: 29th January 2010, 11:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •