Forum Discussion
Rows being deleted unintentionally
Excel 2021: I have had severl instances when opening a particular workbook, or similar copies, of rows being deleted and the rest in a specific group of rows, being run together. I have 12 worksheets with months names on the workbook and this is happening on 11 of the sheets. I have to copy the good sheet, then select the other 11 and paste. It has been happehning many times this week.
2 Replies
Try this:
1. Use Excel’s Repair Tool
o Go to File > Open > Browse.
o Select the workbook.
o Click the arrow next to Open → choose Open and Repair.
2. Check for hidden macros
o Press Alt + F11 to open the VBA editor.
o Look for Workbook_Open events that might delete rows.
3. Save a clean copy
o Copy the “good” sheet into a new workbook.
o Save the file as .xlsx (not .xls or .xlsm unless macros are required).
4. Disable add-ins temporarily
o Go to File > Options > Add-ins.
o Disable COM and Excel add-ins one by one to see if the issue stops.
5. Check external links
o Use Data > Edit Links to see if the workbook is pulling from other files.
o Break links if they’re unreliable.haven't experienced the problem again. I deleted all corrupted worksheets, then copied the good sheet back 11 times (they were months names). Odd, I had saved the workbook in several locations; OneDrive, on my PC and to a usb. All were corrupted.
