Records got deleted

I

italia

We have this big file accessed by more than many people in our group.
It orignally had 65,000 records. We just realised that this file has
25,000 records.

We recovered last 3 backup up files and all had 25,000 records.

The file has a subtotal formula showing the count of records. It is
still showing up as 65,000 until we change any value in the range.

This tells us that the formula was not updated when the records got
deleted.

We are trying to investigate how the records got deleted so that we can
make sure it does not occur again.

Any thoughts?


Thanks,
Kevin
 
G

Gary''s Student

Don't panic...

First make sure there are no hidden rows
Next make sure that some row heights have not been set to zero
Next make sure there are no Autofilters on
Next enter and run this small macro:

Sub range_reporter()
Dim r As Range
Set r = ActiveSheet.UsedRange
numrow = r.Rows.Count
MsgBox ("number of rows " & numrow)
End Sub


Then panic.
 
P

Patricia Shannon

I haven't run into this myself, but it looks like if the sheet is protected,
certain cells might be hidden.
Tools/Protection
if the sheet is protected, it will show "Unprotect sheet". Click that
Select all the cells, then
Format/Cells/Protection
if hidden is selected, unselect it
===========
To minimize this happening in the future:

You could turn on recording of history of changes. I haven't used it
myself. Do help on History.

You can protect a sheet. To keep other people from unprotecting it, you can
apply a password. Make sure password is not forgotten! You can choose
actions that will still be allowed. "Select locked cells" and "Select
unlocked cells" are allowed by default.
Tools/Protection/Protect Sheet

To allow some cells to be changed when sheet is protected, before protecting
the sheet, unlock the cells:
Format/Cells/Protection/unchoose Locked
 
Top