I have an excel template containing various vlookups that are referencing cells in another excel workbook. Both of these workbooks are saved on a network drive at my job. My problem is that excel keeps changing the file path of the vlookups to what seems to be a temporary folder. Initially, the vlookups still work, however once I close down the template and reopen it, the links will not update because of these 'temporary' file paths.

I'm at home right now so I can't post more details about what the file path looks like that excel changes my vlookups to, but I can post more details tomorrow.

In the meantime if anyone has any idea of how to remedy this problem, please let me know. I've googled and searched and can't seem to find a solution to my specific problem anywhere.

Thanks,
Kevin