I figured out my own problem. Essentially, since my data was part of an
Excel table, when it updated, it updated independently of my worksheet
rows/columns. I grabbed the little handle on the lower right of my table and
included all the columns to the right that included my formulas. Now, when I
refresh my ODBC data, everything updates very nicely.



"JDNETTC" wrote:

When I insert a row, it will give me a blank row. I am trying to insert a
row in the middle of many rows of formulas, and I want the row to be
auto-populated with the correct formula.

Instead of:

Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted and blank)
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk

I want:

Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk

My actual spreadsheet is more complicated, but the principle is what I need
to get working.

JD