How to manage new data with external data in Excel?
 

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.

How to manage new data with external data in Excel?
 

hi
more info please.
(i'm assuming that you are using microsoft query(MSQ))
columns to the right of the external
data do not move as I would like them to.

how are they moving now and how would you like them to move???

whenever new data is
added or existing data is removed

this new data/existing data, is it from the other excel table or are you
adding and removing data fromt he MSQ.?

Regards
FSt1

"Hugo" wrote:

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.