I know this is an old thread, but I'm sure people nowadays are still experiencing this issue. I have found one line of code that I entered in the Workbook.Open procedure that prevents formulas from autofilling through the entire table(s).

Just simply add this code in the workbook.open statement:

Private Sub Workbook_Open() Application.AutoCorrect.AutoFillFormulasInLists = False End Sub