View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default 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