How to manage new data with external data in Excel?

H

Hugo

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.
 
F

FSt1

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.
Click to expand...

how are they moving now and how would you like them to move???
whenever new data is
added or existing data is removed
Click to expand...

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

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to import external data into excel? 2
Import External Data 3
External data link to Access - no linked tables? 3
How to Create a Macro to Import External Data 0
External Data Range Properties - Cannot find in 2007 1
Import Data from Access query 8
External Data Refresh Issues 0
Where is the Data Import Excel button in Excel 2007 6

Top