Suppress read only message

I have a sheet stored on a shared drive which everyone opens.  Ant changes are saved to a data file on individuals computer.  However when the second or third person opens the main file it comes up with the read only issue.  Anyway of avoiding this?
StormFusionAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
You need to switch the workbook to Shared mode first, with or without a password (see https://support.office.com/en-us/article/Use-a-shared-workbook-to-collaborate-49b833c0-873b-48d8-8bf2-c1c59a628534 for details). That locks some changes, though, like combining cells, but allows for multi-user access.
However, this feature is known to be unreliable (in the past). Loosing changes. corrupting the file and similar effects have been reported for prior releases.
0
 
D PatelD Patel, Software EngineerCommented:
At the time of sharing the file you will have to Add Name  'Everyone' and with permission level 'Read/Write'.
0
 
aikimarkCommented:
Convert the workbook to a Google doc.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Why? That will move it to the cloud, and require Google accounts, and ...
0
 
aikimarkCommented:
Why?
Sharing
0
 
frankhelkCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Qlemo (https:#a41825260)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.