Honestly, just use =HYPERLINK(). It’s foolproof for clickable links.
If you need live data, Power Query is the answer. It’s not as scary as VBA, and Microsoft has solid guides on it.
For the breaking links thing—always use full URLs. Relative paths are a nightmare if the file moves.
If you need live data, Power Query is the answer. It’s not as scary as VBA, and Microsoft has solid guides on it.
For the breaking links thing—always use full URLs. Relative paths are a nightmare if the file moves.