In Calc how to easily change multi hyperlinks to a folder that has had it's name changed

[KellyinYelm]

Example:old folder name was “Qwest” (phone company name)
Qwest was purchased by Century Link so I’d like to change the folder name to “Century Link or Qwest”

This folder has many years (12 months per yr) of bills/receipts, my calc spread sheet has many hyperlinks to those individual monthly bills. Hyperlinks are internal to my system, not external to web locations.

Yes I know how to go through & change each hyperlink to reflect the new folder name but I thought there might be an easier, quicker more efficient way to change them all.

[Lupp]

(I cannot find much use in the renaming. It’s on your system, and you and your dog will know about the new biller’s name.)
Actual hyperlinks assigned to textportions can only be edited either by interaction or by user code (“macro”). You wouldn’t get the problem at all if you used the HYPERLINK function for the purpose, and probably it’s easy to change the design of your Calc sheet a bit to implement this solution. Renaming a folder would then only need mirroring in one single cell of one sheet in a Calc document.
I expressly do not advise, but if you decide to go the Macro-Do, you may check this contribution to a better structured forum, to get hints about how it might be done.

(Editing:) Really sorry. I must have miscalculated the implications of words used due to my poor English. Bad joke? No disrespect intended! I now also see that my answer above may not have met the question to its point.

Next attempt:
Sheet names of an open document are internal to Calc. Thus the software can update formulae - and it does.

Folder names are external to Calc and managed by the Operating System. Calc may be sleeping when a name is changed, and will also otherwise not be informed about the changes. With other words: There is no way for Calc to identify a storage location independent of its name which would be necessary to update folder names in formulae or hyperlinks on its own responsibility.

[KellyinYelm]

My dog in this necessary Calc document (& the bills referenced) is the IRS.
Without any broken links it also makes it easier for me a simple user to find (for printing) & store (for the future) docs needed each & every January.

I’ve changed sheet names, referenced from other sheets with simple formulas, & found Calc has changed all those references to the new sheet name saving me much time.

I’m a simple user who greatly appreciates LO!!! & all of you who help!!
I will close this.

[Lupp]

Sorry! Sheet names of an open document are internal to Calc. Thus the software can update formulae - and it does. Folder names are external to Calc and managed by the Operating System. Calc may be sleeping, and will also otherwise not be informed about the changes. With other words: There is no way for Calc to identify a storage location independent of its name which would be necessary to do the update on its own responsibility. Its your turn. Sorry again!

[mark_t]

As you probably only want to do this once you might try editing the xml files inside the calc document. Make a copy of the calc document, change the extension of the copy from .ods to .zip. Then you can open the .zip file and see inside this the various components of the Calc document. It might be possible to then edit the content.xml inside the zip file using a text editor such as Notepad or Wordpad, find and replace the text of the hyperlink to the new folder name. Save the modification back to the zip file, then change the extension back to .ods. It should then be possible to open this modified ods file and see that all the hyperlinks have been changed.

Be very carefull to keep a backup of your original document.