We support a client who utilizes several workbooks created in MS Excel 2007. Multiple users access the same workbooks during the course of a day. The procedure had been, until very recently, that if a user needed to open the document, the would locate it on a shared network drive and open the file that way. If another user already had the file opened for editing, the new user would receive a message stating that the file was in use and they would have to wait. This worked fine for the client.
The problem began when we moved all of the company files to cloud storage. As soon as we switched the mapped network drive from a share on a file server to a share on a cloud drive, the users stopped seeing the message that the file was locked and excel began allowing all of the users to modify these documents simultaneously, saving conflicting changes in multiple copies of the workbook. (This in itself is a mess, but NOT the actual question.)
How do I enable the "Protected Mode" message and behavior again?