Are the other sheets in the same workbook?

Just to chime in- Nobody wants all the links in a spreadsheet to be changed to relative paths. Fuck whoever made this up and enabled it by default. Fuck them. Who the fuck thought anybody would want this?

This option, buried deep in your settings: "Update links on save" <-- Even if it worked, it would be only for me, not every other sucker who opens the spreadsheet and automagically has their links fucked up when they save the spreadsheet.

Nobody wants all the links in a spreadsheet to be changed to relative paths. Fuck whoever made this up and enabled it by default. Fuck them.

Did I say fuck enough? No?

Fuck this 'feature'.

Edit: Fix grammar and to add one more 'fuck'.

Note, we have tried using the "update links on save" option but still no luck.

/u/Throwout78673 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

/u/Infinite_Blueberry30 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Try checking if any of your named ranges is referring to what you want to break from.

Check any conditional formatting rules and data in charts if you copied anything over from another spreadsheet.

Bottom line up front:

1. Use the Hyperlink() function instead of manually adding hyperlinks.
2. Save your workbook in the correct format: .xlsx or .xlsm

This is the most poorly-written request for help I've read in a long time, to the point it almost seems deliberate.

I update data weekly based on source links...

🤦

"Delinking" in the title and this reference to "source links" made it sound like you're referring to actual data links.

Links and hyperlinks are not the same thing. I'm unclear why you would use two different words interchangeably to refer to the same thing, when you clearly know what a hyperlink is.

Hyperlinks don't "delink" - and the "spreadsheet" isn't "linked" by putting a hyperlink in a cell.

This isn't meant to be offensive, but it genuinely seems you're trying to make up technical jargon to sound like you know more than you do.

...just a few rows below that row of the most current week.

"That" row? Which row? You didn't refer to a row. Does it even matter?

The layout doesn't even seem relevant to your question so it's unnecessary in addition to being meaninglessly ambiguous.

But for the second week in a row, the links no longer work.

Are you talking about consecutive weeks or are you still vaguely referring to the layout that wasn't explained?

The text is displayed, but they are no longer formatted as hyperlinks. Just text, it seems.

Saying the "links no longer work" means they still exist but just aren't functioning. What you're saying now is that the hyperlinks are gone.

And "just text?" What text? The URL? - Some other text that was the hyperlink display text? A label that was on a row near the hyperlinks?

I just corrected them last week and made them hyperlinks again.

Based on context clues I'm assuming you right used the cell context menu to make the cells hyperlinks. It's still unclear whether the "text" is the URL or something else.

Back to the beginning:

I've had a spreadsheet for many years.

The last time I saw a post that said this, the OP was a Mac user who literally never closed their applications or saved their files, and blamed Excel for "reverting" months of work on their spreadsheet.

I'm not sure what your issue may be.

You can try using the =HYPERLINK function.

u/despapitfast - i’m so terribly sorry to have upset you. Please tell me what I can do to make it all better.

/u/Impressive-Fortune69 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

I guess I'll try Quora.

you find a fix yet?

/u/ExperimentalFailures - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

I'd check to see what differences there are between the users - different Excel version, operating system version/updates, and/or different add-ins.

Repairing the Office installations of the problematic users might be worth a try.

Is there a previous version that works for everyone? If so, then what changed?

But, ultimately, I wouldn't trust the workbook any more. Probably best to rebuild from a clean base. Perhaps an opportunity to make improvements. Hopefully it isn't too big a job.

/u/TraditionRound6882 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

/u/wormburner1980 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Office 2001??

This is something I've used in the past. If the link is good, it'll return 200.

function getStatusCode(url){
   var response = UrlFetchApp.fetch(url);
   return response.getResponseCode();
}

You may have to give it access -- but I'm not sure. Use =IFERROR(IF(ISBLANK(A1),,getStatusCode(A1))) and drag fill it down. If you have thousands, maybe to 100 at a time -- then 200 at a time.

Then to do some conditional formatting...

Highlight error'd ones

=AND(LEN($A1),NOT(LEN($B1)))

Highlight good ones

=AND(LEN($A1),LEN($B1))

If you're using Linux or MacOS or even WSL, check this script

Good URLs with this will return 301 and bad ones, 000.

I strongly suggest you to use Help, Feedback, Report a problem. They do listen to these.

/u/IAmMeMeMe - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.