Hyperlinks in Excel

Mr-H | 22:58 Wed 21st Mar 2012 | Computers

2 Answers

I use Excel to list all my music and play the track using a Hyperlink to Windows Media Player. Suddenly many (most!) of the links have stopped working. The Hyperlink address has got '/AppData/' suddenly appearing. If I use the 'edit' path, I can at least clear this without having to create the full link again, but why/how does this happen? What can I do to stop a recurrence please?

Learning the language c

Disc drive won't work

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by Mr-H. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Maydup

Have you had a tidy up and broken a few links to music which is now stored in a different folder perhaps?

Mr-H

Question Author

I did tidy up 1 music folder, but tose files have been amended manually 'cos the route to the final address had changed. With this problem however, if I use 'edit hyperlink' then highlight and delete '/Appdata' the hyperlink is restored and the music track plays again.

1 to 2 of 2

Do you know the answer?