Hyperlinks in Calc Not Working

Ubuntu 16.0.4
LibreOffice 5.1.4.2

I use calc as a media centre to play films - the hyperlink link to the film files on the disks

Since upgrading to the above config some / most of the hyperlinks do nothing.

Some work but a lot don’t.

We can’t see from where we are how the links that work differ from the ones that don’t. Maybe if you save the file as csv (with tabs for readability) and open that in a text editor, you may see that for instance some of the links are relative to some folder and others absolute to your root folder.

Alternatively, post a copy of the file here with some samples. Use the paperclip icon in the edit area to add an attachment.

Went to try your suggestions (thanks) and I can’t find one that fails!

I’ll close this for now - thanks again for the help