Hyperlinks between sheets

Hi,

This is my first time posting on a forum so I hope somebody is able to help.

I have an excel spreadsheet with several worksheets, I have a lot of hyperlinks from one sheet to other sheets. However, if I change the name of one of the sheets that is hyperlinked to it removes the links.

Is there anyway that I can rename a worksheet but maintain the links?

Many thanks!

Try the following formula:

=HYPERLINK("#"&CELL("address",Sheet2!A1),"Go to "&CELL("address",Sheet2!A1))

Change Sheet2 and the cell reference A1 to the desired location.
If the sheet is renamed, it should change automatically.

Hi,

Many thanks for that, however the problem that I have is that I want the cell which has the hyperlink to display the contents of the cell that it hyperlinks to.

When I originally set up the hyperlink I use Insert-Hyperlink and set it up in that way having first linked the cell I hyperlink from to display the contents of cell I am hyperlinking to.

Is there any way of doing what you have suggested in another way?

I really do appreciate any help!!

Try the formula below:

=HYPERLINK("#"&CELL("address",Sheet1!A1),"Go to "&Sheet1!A1)

Change to the desired cell and sheet name.