excle issue

Question

The user modified an Excel workbook on a specific worksheet and shared the file with a teammate for collaboration. After some time, the data from a particular column on that worksheet disappeared.

During our investigation, we observed that the indicating that edit activities were recorded.

At this point, we need to determine whether the missing data can be recovered. Since the recent versions are not available in Version History despite the audit logs showing modification events, we need to investigate whether the changes were successfully saved to SharePoint/OneDrive or if they were lost due to workbook corruption, synchronization issues, or an incomplete save operation. We would like to know if there are any additional recovery options available to restore the missing column data.

Answer 1

Dear @Megha Devrani,

Good day! Welcome to Microsoft Q&A forum!

Based on your description, I understand that data from a column in a shared Excel workbook disappeared after edits were made on a specific worksheet. Although audit logs show modification activity, the relevant versions are not available in Version History. You're looking to determine whether the missing data can be recovered and whether the issue is related to workbook corruption, sync problems, or an incomplete save operation.

According to the message shown, Excel has detected an issue with the workbook content and is offering a recovery option. Please click 'Yes' to allow Excel to attempt to repair and recover as much data as possible from the file.

Once the recovery process completes, please let me know:

• Whether the missing column data reappears
• If Excel displays a repair log or recovery summary, please share a screenshot of it
• Whether you are able to save and reopen the repaired workbook successfully

Additionally, could you confirm if the issue is visible in both Excel Desktop and Excel for the Web?

The message in the screenshot may indicate workbook corruption, so the recovery results and any repair logs will help me know whether the missing data can still be recovered or if additional investigation is required.

I appreciate your cooperation in performing these checks. I will review the results and continue assisting you with the investigation.

Thank you for your time and patience!

---

If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in [forum documentation] to enable e-mail notifications if you want to receive the related email notification for this thread.