I am new to a part time job and the first task was to scan a large number of tax documents into the computer. I've done this and given each one a unique name. These files are on the C drive under the MY SCANS folder with a .pdf extension.
Then I created a spreadsheet enter the various bits of information on a large number of property holdings. I thought that I would be able to use the hyperlink function and connect the tax document to the appropriate cell for each holding. For example, in the spreadsheet I have column for the Property Tax ID Number. For each of those unique numbers, there is a scanned document named with that Property Tax ID Number.
In the spreadsheet I then selected a cell and created a hyperlink by right clicking on Insert Hyperlink. Went to the dialogue box and navigated to the correct pdf document and selected it.
After doing a few and checking to see that all was working OK, I continued to move through this large list. The next day when I started up again, I was preparing to work through the steps to show my employer how to access the tax document from the hyperlink on the spreadsheet. But all I got was a message " Cannot find the specified file."

Have done some researching and have not found much to help me figure out what is happening. I am obviously not phrasing my question correctly. I have never had problems with hyperlinks before, but then I was trying to hyperlink PDF's.

Any simple solutions out there? Or am I approaching this the wrong way.

TIA