ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inactive URL links (https://www.excelbanter.com/excel-discussion-misc-queries/126798-inactive-url-links.html)

Motlalepula

Inactive URL links
 
I currently have an index for a blogpost.
The index is a list of all blogs posted with
their dates, title and the url for that specific post,
which i update weekly. the URLs are copied from
the website and pasted into excel.
What has happened lately is that all the past URLs (abt three years worth)
have suddenly become inactive. This means that when I roll over
the URL with my mouse nothing comes up and the I am unable
to open the web page. This requires that I update each URL.
How and why does this happen?
And how do I prevent this from re-occuring?

Any insight and help will be much appreciated.
Thank you.

Motlalepula




Gary''s Student

Inactive URL links
 
If the URLs are standard things like:

http://www......

but are not "click-able", then in another cell enter:

=HYPERLINK(A1) for example. The cell with this function will be "click-able"
--
Gary's Student
gsnu200702


"Motlalepula" wrote:

I currently have an index for a blogpost.
The index is a list of all blogs posted with
their dates, title and the url for that specific post,
which i update weekly. the URLs are copied from
the website and pasted into excel.
What has happened lately is that all the past URLs (abt three years worth)
have suddenly become inactive. This means that when I roll over
the URL with my mouse nothing comes up and the I am unable
to open the web page. This requires that I update each URL.
How and why does this happen?
And how do I prevent this from re-occuring?

Any insight and help will be much appreciated.
Thank you.

Motlalepula





All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com