Why is that some linked data can be dragged along and filled in automatically when linking between new spreadsheets, but then when you try it again on a different spreadsheet, it just repeats the same data over and over again? It won't spread the formula to new columns and just repeats itself.

Anyone know how to fix this issue? I have two very similar projects where on one of them, there is no issue at all, but the other is driving me crazy. Its almost as if there is a setting change that needs to be done, or maybe not...