Hi, I'm setting up a business planning worksheet into which I import external
data from another Excel table using the built in driver. I import a few
columns and then add some extra columns required to the right, such as
formulas and other validated fields. The problem is that whenever new data is
added or existing data is removed, the columns to the right of the external
data do not move as I would like them to.
In "External Data Range Properties" I ticked "Insert entire rows from new
data, clear unused cells." but that doesn't seem to work.
Can anyone help me out with this? Thanks in advance.