Software

Ask something
Discussion Locked

Excel hyperlinks

0 helpful
3 replies

by paulrhopkins

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I use excel to list and help manage the various number of projects I am involved with. My PC was rebuilt so that now, when I create an hyperlink to take me from this worksheet to somewhere else it is fine until I save. Then when I click on the hyperlink I get "the address of this site is not valid, etc" message.

I've had this problem before but cannot remember the cure: googling it does not help. It was not anything to do with the registery settings.

Paul

3 replies

by paulrhopkins

The solution is to: tools>options>general>web options and untick update links on save.

I post this reply to my own fault just in case somebody else has a similar problem.

by smbriggs63

Thanks for answering your own post, I had the same issue and resolved due to a Google search leading to this post.

by deepsand

Use the "Questions" forum; the "Discussion" forum is for matters of general discussion, not specific problems in search of a solution.

Post problems such as this to the "Question" forum, rather than the "Discussion" forum. There are those who specifically seek out problems in need of a solution, and that's where they go to look for such.

Additionally there are the benefits that:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions comingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.

This discussion is closed to new replies.