Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Removing Link in Excel
Name: halenhardy2 Date: February 23, 2004 at 07:43:55 Pacific OS: ME CPU/Ram: p128
Comment:
I have magically acquired a Link in a workbook to another workbook. The 2 workbooks are completely isolated from each other and there is no real link. Everytime I bring up the one workbook it has a message about being linked to the other and Do I want to update. I know where the link is but am unable to delete it. All Edit Links will let me do is Update or Change xource but no delete option. Is there an option somewhere I can use. TYhanks..Gary Hardy.
Name: Report_2 Date: February 23, 2004 at 12:29:06 Pacific
Reply:
Click on or select the cell that contains the link. Go to Edit, Copy, Paste Special, Values.
The link will be gone.
0
Response Number 2
Name: halenhardy2 Date: February 23, 2004 at 14:39:55 Pacific
Reply:
The problem is that I have no way of knowing which cell supposedly has the link. I just activated the file and this time chose the "update" option. Nothing happened but now I don't get the link anymore. Another magic moment in Windows. Thanks..Gary Hardy
Summary: When I click on or hover over an email link in excel, a different email shows up. This happens on every cell in a column containing email addresses. I don't know where the other email addresses are...
Summary: How do I create a link in an excel 97 cell so it opens up an outlook e-mail template? I want to do this over a network and I'm sure there's a way to do this. Please help! Thanks! ...
Summary: U must remove them in excel, in disable options/display/background lines. In fact when u copy to powerpoint, it strictly takes a picture of ur sheet! ...
0 
