I have an excel 2007 file sitting in a shared network folder. I only want one user to be able to make changes at a time (any other users would get a read-only). For some reason it currently does not do this, and I have multiple users with the same doc open. I'm concerned that changes will get over-written when 2 people are saving their changes. Can anyone help me with the settings for this.
Step 1: Open Excel file.
Step 2: Press Alt + T, b for open share Workbook window.
Step 3: Please Tick for Allow Changes by more than 1 user at the same time.
Step 4: Click OK.
Thats it...