'%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)
How to Identify an Anonymous Editor in Excel Online
Question details
The user wants to know how to identify an anonymous person who edited or deleted data in a shared Excel Online workbook.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- A workbook shared via an open link was edited by someone without a logged-in account, resulting in changed or deleted student names.
- Observed behavior
- Changes were attributed to an 'anonymous' or 'guest' user, making it impossible to see the exact identity of the person who made the edits.
Ensure you have owner or editor permissions for the affected Excel file, as you will need appropriate rights to check the version history and modify the document's sharing settings.
Check Version History to Restore Data
While true anonymous users cannot be directly identified after the fact, you can use version history to pinpoint when the edits occurred and restore your deleted data.
When a user accesses an 'Anyone with the link' URL without signing into a Microsoft account, their identity is not captured by Excel Online. However, you can undo their actions.
Open the affected workbook in Excel Online, click on 'File' in the top ribbon, select 'Info', and then click 'Version History'.
Look at the right-hand panel to review past versions. Click through the timestamps to find the exact moment the anonymous edits or deletions occurred.
Once you locate the version of the file from just before the unwanted changes were made, click the 'Restore' button to revert the workbook to that state.
Update Sharing Permissions
To prevent future anonymous edits, restrict the workbook's access so only invited and authenticated users can make changes.
Apply Sheet Protection
If you must share a public link, protect the worksheet so that users can only edit specific cells or view the document in read-only mode.
Use WPS Office for Secure Document Collaboration
While tracking down anonymous edits in Excel Online can be frustrating due to platform limitations, you can use WPS Office as a free, secure, and lightweight alternative. WPS Cloud offers precise sharing permissions and version tracking to ensure your collaborative work remains safe.
- 1. Download WPS Office: Download and install WPS Office Free on your device.
- 2. Open Your Workbook: Open your existing Excel (.xlsx) file in WPS Spreadsheet.
- 3. Upload to Cloud: Click the 'Share' button to upload your document to WPS Cloud.
- 4. Set Permissions: Restrict access by inviting specific people, ensuring only authorized, logged-in users can edit the file.
Frequently Asked Questions
Why do editors appear as 'Anonymous' or 'Guest' in Excel Online?
This happens when a workbook is shared using an 'Anyone with the link' setting, and the person opening the link is not currently signed into a Microsoft account. Because there is no account data attached to their session, the system labels them as anonymous.
Is there a hidden audit log to find an anonymous user's IP address?
For standard personal or educational Microsoft 365 accounts, detailed IP audit logs for anonymous guest links are not accessible to end-users. While enterprise IT administrators may have access to advanced audit logs via the Microsoft Purview compliance portal, this data rarely identifies the specific individual.
Can I prevent users from sharing the anonymous link with others?
Yes. If you change your sharing settings from 'Anyone with the link' to 'Specific people', the link will only work for the email addresses you explicitly invite. Even if they forward the link, unauthorized users will not be able to open or edit the file.
