Hi there,
I'm using excel 2016 on OSx.

I'm trying to automate some hyperlinks to files that are one folder down on my drive (from the excel file). But it always says file not found - even when the location looks perfect to me (when I hover over the link).

=HYPERLINK(Choices!$C$2&'Claims table v0.1'!J70,A70)

Filename is called: file.pdf and opens fine via finder. (e.g. if i double click it to open).


To set this up (see below for screen capture):

- I have a folder location, which I reference using an absolute formula, this is on a separate sheet called "Choices", cell C2
- Then, I have a column where I place my filename (I copy this from the filename itself in finder and paste it, extension included), J71
- Then the formula takes the filename, adds it to the folder location, and uses the text from another column as the hyperlink text.... A71

But, I get errors each time - I've tried lots, like taking the extension away, adding it in the formula, changing file names, adding numbers, removing space, removing numbers etc.... just can't manage to work out where it is going wrong.
thanks for any help.

1.png
Screenshot 2018-12-10 at 01.45.08.png
2.png