Questions

Links in a Excel Sheet

+
0 Votes
Locked

Links in a Excel Sheet

shwetaphegde
I have one excel file with 4 sheets.
When I try to open the file I am getting an error that unable to open so & so file.... But In that file no links to that path ... But it is showing that error... I am not able to find out why that irrelevent path is getting displayed as error message. If I press OK, the file is opening.Can you please suggest me a solution for this

Thank you
shweta
  • +
    0 Votes
    sid_adil

    hi shweta
    it seems that ur file is using a macro which was created in some other file or having link to data in that file so whenever u open your file it looks for the presence of that file check ur file for link to that file or send details of error msg for further progress

    +
    0 Votes
    LocoLobo

    Hi,

    this problem happens to us from time to time as well. What we end up doing is viewing the formulas and looking for the formulas referencing other files. Go to Tools-Options-View then under "Windows Options" check the formulas check box. If you know a better way let me know as this gets tedious.

    Good luck

    +
    0 Votes
    craigdieter

    The process (Tools-Options-View then under "Windows Options" check the formulas check box.) worked like a champ, as stated, it was tedious, but my problem has been resolved.

    Thanks
    Craig.

    +
    0 Votes
    martinhughharvey

    Select all worksheets and do a find for the offending link.

    +
    0 Votes
    Another poster

    OK, I know this post is way old but just thought I might help. The shortcut key for viewing formulas in a worksheet is CRTL+tilde
    That's right, finally a use for the tilde (the ` key next to the 1)!

    +
    0 Votes
    martinhughharvey

    Well it's obviously no harm so you can "Break Links" via "Edit Links". When I get these I simply select all the worksheets and Find (CTL/F) the offending filename. You'll see all the offending cells and can change them (mass change via CTL/H). This is often caused by copying formulas from other workbooks. Hope this helps.

  • +
    0 Votes
    sid_adil

    hi shweta
    it seems that ur file is using a macro which was created in some other file or having link to data in that file so whenever u open your file it looks for the presence of that file check ur file for link to that file or send details of error msg for further progress

    +
    0 Votes
    LocoLobo

    Hi,

    this problem happens to us from time to time as well. What we end up doing is viewing the formulas and looking for the formulas referencing other files. Go to Tools-Options-View then under "Windows Options" check the formulas check box. If you know a better way let me know as this gets tedious.

    Good luck

    +
    0 Votes
    craigdieter

    The process (Tools-Options-View then under "Windows Options" check the formulas check box.) worked like a champ, as stated, it was tedious, but my problem has been resolved.

    Thanks
    Craig.

    +
    0 Votes
    martinhughharvey

    Select all worksheets and do a find for the offending link.

    +
    0 Votes
    Another poster

    OK, I know this post is way old but just thought I might help. The shortcut key for viewing formulas in a worksheet is CRTL+tilde
    That's right, finally a use for the tilde (the ` key next to the 1)!

    +
    0 Votes
    martinhughharvey

    Well it's obviously no harm so you can "Break Links" via "Edit Links". When I get these I simply select all the worksheets and Find (CTL/F) the offending filename. You'll see all the offending cells and can change them (mass change via CTL/H). This is often caused by copying formulas from other workbooks. Hope this helps.