I have a 2 column table which is likely to change length whenever the
Refresh Data menu option is selected. The table links to another
software package (SAGE). I don't have formulae in adjacent columns so
my problem can not be solved by checking the "Fill Down formulas in
columns adjacent to data" box. I do, however, have text in adjacent
columns (which the user selects from an in-cell drop down list) which I
need to remain aligned with the relevant row.

The "insert entire rows for new data ..." option does not appear to do
what it says! It only inserts rows in the table not across the sheet

Is there any way i can solve this issue?

TIA

Stuart