Formula to link HYPERLINK function to a different file location based on the workstation?

Part of my job needs me to keep track of some scanned paperwork via spreadsheet. Each set of data has a unique ID number, in column A, and Column G contains a HYPERLINK formula for ease of pulling up a PDF copy of the information. I keep a Local copy and a copy on the network shared drive, identical in contents and name.

I use the following code right now:

Please Login or Register  to view this content.

My problem is that I'm the end of an awful internet connection, so when I access these (often) it takes forever. I would like to pull from my local Drive instead of the network for my purposes, but other people who do not have and should have access to to also need to use this spreadsheet. Is there a way to set this up so it will link to the file from my local copies when I'm using it, and the Network opies when everyone else uses it?

Not the best solution I am sure but a workaround possibly: Add Column H and have the same formulas but linked to your C drive path , it won't work for others (but they can use the links in G). If you hide the column H nobody is bothered..