Hyperlink from Organisation chart box
On one worksheet of my workbook I have an organisation chart. I have created
a hyperlink so that clicking one of the boxes on the chart takes me to another worksheet in the same workbook (becasue the whole chart is too big for one worksheet). However when I right click on the organisation chart box I do not get the remove hyperlink option! (or edit hyperlink...etc). Therefore, when I re-named the destination worksheet the hyperlink stopped working. Any suggestions / help is much appreciated Dave |
Hyperlink from Organisation chart box
Hi,
You have to Edit the hyperlink to update the reference name of the new destination worksheet. Challa Prabhu "Dave" wrote: On one worksheet of my workbook I have an organisation chart. I have created a hyperlink so that clicking one of the boxes on the chart takes me to another worksheet in the same workbook (becasue the whole chart is too big for one worksheet). However when I right click on the organisation chart box I do not get the remove hyperlink option! (or edit hyperlink...etc). Therefore, when I re-named the destination worksheet the hyperlink stopped working. Any suggestions / help is much appreciated Dave |
Hyperlink from Organisation chart box
Thanks, but how do I do that?
"challa prabhu" wrote: Hi, You have to Edit the hyperlink to update the reference name of the new destination worksheet. Challa Prabhu "Dave" wrote: On one worksheet of my workbook I have an organisation chart. I have created a hyperlink so that clicking one of the boxes on the chart takes me to another worksheet in the same workbook (becasue the whole chart is too big for one worksheet). However when I right click on the organisation chart box I do not get the remove hyperlink option! (or edit hyperlink...etc). Therefore, when I re-named the destination worksheet the hyperlink stopped working. Any suggestions / help is much appreciated Dave |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com