I've linked my excel document to an external source for data. New data is updated to the excel document, and the new data becomes applied to the first row (to always show the most recent). Essentially, whatever used to be the first row becomes the second row, and the new data is the first row.
As a result, the formulas that I have on the Excel Table aren't autofilling to the first rows. I can use the Fill feature in the Home tab, but that has to be manual and I have to determine the cells that don't have formulas to use it. Is there an alternative that would automate autofilling the formulas to the new data so I don't have to do it every time?