To prevent Excel from creating new rows and columns automatically, follow these steps: Here you can find a setting named Include new rows and columns in table. You need to double-click on this setting ...
It replaced my date-filling workflow, and I'm not going back.