Thanks so much, everyone! I tried the HYPERLINK function, and it worked perfectly for the clickable links.
I’m still a little nervous about Power Query, but I found a YouTube tutorial that breaks it down step-by-step. Gonna give it a shot later.
Quick Q: If I use Power Query, will it auto-update every time I open the file, or do I need to refresh manually?
(And yeah, sticking to full URLs saved me from the broken links issue. Lifesaver!)
I’m still a little nervous about Power Query, but I found a YouTube tutorial that breaks it down step-by-step. Gonna give it a shot later.
Quick Q: If I use Power Query, will it auto-update every time I open the file, or do I need to refresh manually?
(And yeah, sticking to full URLs saved me from the broken links issue. Lifesaver!)
