'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Cannot Show Other Users' Live Locations in Shared Workbooks
Question details
Users are unable to see the live cell locations of co-authors or use the Go to Cell feature when collaborating in shared workbooks on the Excel desktop application.
- Product
- Microsoft Excel for Microsoft 365 Desktop
- Device & OS
- not provided
- Scenario
- Collaborating in real-time with co-authors in a shared workbook using the desktop version of Excel.
- Observed behavior
- Live cell locations of other users fail to display, and the Go to Cell function does not work on the desktop app, despite functioning correctly in Excel for the web.
Ensure that all collaborators have explicit edit permissions for the shared workbook and that you have a backup of your Windows Registry before modifying system settings.
Reset Excel Registry Settings
Resetting the Excel registry key can resolve corrupted configuration files that prevent collaboration features from working correctly.
Sometimes local application settings become corrupted, blocking real-time syncing features like live cell locations. Deleting the Excel registry folder forces the application to recreate its default settings upon the next startup.
Warning: Modifying the Windows Registry can affect your system. Always export a backup of the registry key before making changes.
Ensure that all instances of Microsoft Excel are completely closed on your computer.
Press the Windows key + R to open the Run dialog. Type 'regedit' and press Enter. Click Yes if prompted by User Account Control.
Navigate to the following path in the Registry Editor: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel.
Right-click the 'Excel' folder and select 'Export' to save a backup to your desktop. Once backed up, right-click the folder again and select 'Delete' (or rename it to 'Excel_old').
Launch Microsoft Excel again, open the shared workbook, and check if the live location features are restored.
Verify Office Builds and Permissions
Ensure all users are running a supported Microsoft 365 build and have the correct editing permissions assigned.
Try WPS Office for Seamless Real-Time Collaboration
If Microsoft Excel continues to experience synchronization or live location issues on the desktop, switch to WPS Office. It provides robust real-time co-editing, high compatibility with Microsoft Office formats, and a lightweight desktop application for smooth teamwork.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about format conversion issues.
- 3. Collaborate in Real-Time: Use the sharing features to invite your team and enjoy stable, real-time collaboration with visible live cell tracking.
Frequently Asked Questions
Why do live locations work on Excel for the Web but not the Desktop app?
Excel for the Web relies on browser-based cloud syncing, which updates independently of local settings. The desktop application depends on local registry configurations and specific software builds, which can occasionally become corrupted or outdated, causing collaboration features to fail locally.
How do I know if I have the right permissions to see co-authors' locations?
You and your co-authors must have 'Can Edit' permissions on the shared document. If a user only has 'View' access, their live tracking and cursor location will not be broadcasted to other users in the workbook.
Will resetting the Excel registry delete my spreadsheets or files?
No, resetting or deleting the Excel registry key only reverts the application's interface settings, recent file lists, and preferences to their factory defaults. Your saved workbooks, data, and macros stored in files remain completely intact.
