We currently use an excel spreadsheet which requires input by different users within the department. I know there is a facility you can activate which displays a pop up message box stating another user is currently 'in' the spreadsheet and it can be accessed via a read-only action....but, I can't seem to find information on how to put it into action. I am probably typing in the wrong HELP question?
If you are using Office 365 and the file is either in Sharepoint or in OneDrive, you won't see this message anymore, as multiple people can edit the same file at the same time. Is that not what you want?
Many thanks for taking the time to reply Jan. I have since had further advice, and it would seem this pop-up message box is only applicable in a shared drive facility. As we access the majority of our files from Dropbox the Microsoft message cannot be displayed.