I need to grant a user rights to an Excel file. The problem is the file is in a "private" folder, and the user doesn't have access to the folder.
I have gone to the file level and granted him all rights except for Full Control and Special permissions. I then created a shortcut that points directly to this file and moved it to the user's desktop. The user clicks on the shortcut and is able to open, read and modify the file. The problem is, when the user tries to save the file he gets the following message: "Access Denied. Contact you administrator."
Obviously, I am missing something. The owner of the file doesn't want to move the file because of the sensitivity of the information inside those files. And I was also told that he would like to be able to do this with a couple more users (except they would have access to a different file).
Does anyone have a suggestion? These files are on the network (Windows Server 2003 R2).