My Excel has a connection to XQ DDE, and it has always worked fine until today when a problem suddenly occurred. Below is the description of the file connected to DDE, referred to as File D.

Problem: Unable to use the “delete row” function, and the insert function is also not working.

Example:
As shown in the first image, rows 23-27 have five numbers.
enter image description here
If row 25 is deleted, theoretically, the number 3 should disappear, and the remaining numbers should shift up.
However, for some reason, when I delete row 25 in my Excel, it appears as if the delete row function only clears the data instead of actually deleting the row.
enter image description here

Steps I have tried:

1. Restarted the computer.
2. Went to File -> Options -> Advanced -> Checked “Ignore other applications that use Dynamic Data Exchange (DDE)”.

Current observations:

1. If the DDE connection is disconnected for File D, it works normally.
2. If another file with existing data is opened while File D is connected to DDE, the same issue occurs in the other file. Closing File D restores normal functionality in the other file.
3. If a new Excel workbook is opened while File D is connected to DDE, it works normally.
4. Even opening a new worksheet in File D does not allow the delete row or insert row functions to work.

I seek your help to understand this issue. I have VBA code that relies on the delete row function, which is now completely unusable. Thank you.