Rows in file not getting deleted

I am working on a data set where suddenly I am unable to delete few rows in between. As in only the data in the cells are getting deleted but the empty row is still present. Tried ctrl & -, manually deleting, tried converting to table and deleting. Tried all methods suggested by chat gpt and co pilot. This is a simple data set with values in general, text, number and date format. What is irritating is this is affecting all the other sheets in the same file. The only alternative solution now which is working is copying the entire data set everyday to a new sheet and then reworking. Can anyone explain why exactly this is happening. Been working with excel for few years and being unable to find the exact RCA is ruining my peace.

Update: Unable to add rows as well.