Question

Locked

Links in a Excel Sheet

By 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

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

re: links in a Excel Sheet

by sid_adil In reply to Links in a Excel Sheet

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

Collapse -

to find links in an Excel spreadsheet

by LocoLobo In reply to Links in a Excel Sheet

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

Collapse -

Many thanks

by craigdieter In reply to to find links in an Excel ...

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.

Collapse -

Simpler sometimes works

by martinhughharvey In reply to Many thanks

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

Collapse -

Shortcut for viewing formulas

by Another poster In reply to to find links in an Excel ...

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)!

Collapse -

Broken links ...

by martinhughharvey In reply to Links in a Excel Sheet

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.

Back to Software Forum
7 total posts (Page 1 of 1)  

Software Forums