I have a user who uses Links in his workbooks to get data from other workbook files. When he opens one of the workbooks, he is prompted to refresh the links; when he clicks the Yes button, he gets an Open File dialog prompting him to open the linked file from c:\documents and settings\tedm\local settings\temp instead of from his network drive. I have opened the same file from my computer to test it and it works fine; i.e., the links are refreshed from the location on the network and I am not prompted to find the files on my c: drive.
Why is this not working on his computer? How do we fix it?