Software

Ask something
Discussion Locked

Excel - editing shared files

0 helpful
3 replies

by kris.graves 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When several team members make changes to a shared spreadsheet located on server - can you lock others out or give read only access until it is closed or saved by the current editing member? With Office2000 it appears two or more can change the file at the same time and I don't think it was that way with Office97

3 replies

by dklippert

Look at Tools>Share Workbook. Remove the check mark from allow changes by more than one user.
Here's some more information. Type the Q number in the soultions using box at support.microsoft.com

Shared Workbook Lists Multiple Users

Q212072

This discussion is closed to new replies.