User showing as editing mutilpe locations in co-authored, online Excel O365 file

SWalter

New Member
Joined
Sep 29, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
We are using Office 365 Excel files stored in SharePoint online that are Co-Authored by users in multiple physical locations. This has been going ok for the last year or so. But now we are having many issues with saving errors, files freezing and such. Today I noticed that instead of showing which cell another user was editing, the hover over message said "Editing Multiple Locations"and it showed that same user in two separate cells? I know someone could use the hold "Ctrl" down to select multiple cells, but that would only be for that instance. This is being displayed constantly for that user, so I have no idea which cell(s) they are editing with scrolling around looking for the highlighting? I spoke with this user and he said that he was only on one of the highlighted cells in his view, not both like it was showing me. Message and occupied cells.png
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

SWalter

New Member
Joined
Sep 29, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Even more strange, the hoverover on the cells with the user colored border show different data, one shows the User friendly name as normal, the other shows the system user name and a string of numbers as shown here.Odd user ID.png
 

Watch MrExcel Video

Forum statistics

Threads
1,113,745
Messages
5,543,960
Members
410,586
Latest member
acadavid86
Top