Forum Discussion
Renaming a web hyperlink after linking it from another tab
Hi exceluser6614 ,
I'm still not fully understanding your problem or what you need to do. If you would be able to post screenshots to explain more that would be great.
Abdelrahman Abdou,
Certified Microsoft Excel Expert, Consultant.
Founder, Owner @ ExcelBonanza.com
http://www.excelbonanza.com/ |
https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/
Hello,
I posted screen shots below.
In the first screen shot you see that I have a list of hyperlinks on the master tab.
On the second screen shot you will see that by using the HYPERLINK function I am linking a cell on sheet 1 to a hyperlink on the master tab.
The third screen shot below shows what happens when I try to add a friendly name. The friendly name shows up when when you click on it you get the error message below.
I believe this is happening because I am linking to a cell on the master tab and not typing in a hyperlink on this page. I need the hyperlinks on sheet 1, 2, 3 etc to link back to the master tab so that when I make a change on the master tab it automatically makes the change in the other sheets.
As in your third screenshort try to change text "Master!A1" on reference Master!A1. In general it works:
Master:
Another sheet:
Google is opened correctly from here.
Hi exceluser6614 ,
From what I can see, the issue is that the link is written as http://www.google.com instead of http://www.google.com
You need to make sure to write http:// before the website address, and then you won't get the error.
Regards,
Abdelrahman
Thank you for the suggestion. I added the http:// and it still does not work. I am getting the same error message as before. AAbdou
Then I guess I can't figure out what your issue is. The only thing that can help me is trying everything myself on your computer. sorry for that. Would've loved to help further.
Abdelrahman Abdou,
Certified Microsoft Excel Expert, Consultant.
Founder, Owner @ ExcelBonanza.com
http://www.excelbonanza.com/ |
https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/
