We have a shared excel file we keep on the a network drive that is utilized by multiple users. We are not using the shared version.
Normally when the file is operating correctly, if one user is editing the file and another user is trying to access it, a note will come up for user 2 indicating User 1 is in the file and read only is available. The problem with our file is the user name comes up with someone who is not in the file, John Doe. No matter who tries to open the file while another user is making edits, John Does name comes up. I'm sure this is probably a silly fix in the options or privacy setting but I'm out of options, I think it may have to do with privacy setting and removing personal information on save