Ran into a bit of a head scratcher this week in regards to network file permissions on an Excel spreadsheet. Department manager created a spreadsheet in a shared network folder that his employees had read access to. He wanted the employees to be able to update the spreadsheet so I gave their security group write level access to the file. The file would open for an employee okay but when the person tried to save the document the following error would trigger:

File name or path does not exist.
The file is being used by another program
The workbook you are trying to save has the same name as a currently open workbook.

I triple checked all the permissions to make sure I had everything correct. Checked the file server to see that the user did indeed have Read+Write access while they had the file open. Even checked the server logs to make sure there weren’t any security errors. Everything looked fine.

I then decided to look at the server log to see what it looked like when an admin opened and saved the file where I stumbled upon the answer. Excel is trying to create a .tmp file in the same folder the spreadsheet is in before it saves the spreadsheet. The user’s security group only had read access to the folder which resulted in the generic Excel save error.

I moved the spreadsheet to a subfolder and applied the same permissions to that folder and that did the trick.