ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 users open same file and both can edit/change the file (https://www.excelbanter.com/excel-discussion-misc-queries/67059-2-users-open-same-file-both-can-edit-change-file.html)

RANDY

2 users open same file and both can edit/change the file
 
If one user open a file, how can I prevent the other user from open the file
for editing. In the past Excel/Word normally display a read-only message when
a file that is opened is being acced.

Randy

Anne Troy

2 users open same file and both can edit/change the file
 
The file must be shared to be shared. :) So perhaps your file is set to be
shared.
http://www.officearticles.com/excel/...soft_excel.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"RANDY" wrote in message
...
If one user open a file, how can I prevent the other user from open the
file
for editing. In the past Excel/Word normally display a read-only message
when
a file that is opened is being acced.

Randy





All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com