The trick might be excel “UsedRange”
“A used range includes any cell that has ever been used.”
So if your worksheet contained data that were later deleted the space is still considered as “occupied” and AppendRange activity will append below it.
You can check if it your case by openning your worksheet and pressing “Ctrl-End”. It point you to the UserRange end.
Cheers