External data insert rows

  • Thread starter Thread starter Frank Fokke
  • Start date Start date
F

Frank Fokke

The "external data range properties" has an option to "Insert entir
rows for new data, clear unused cells".
I would expect this option to insert an ENTIRE row over the full lengt
of the sheet, but only inserts rows in the table itself and not th
rows in the table and the data adjacent to it. It would save me some V
programming if this is possiple.
Is this behaviour correct, or is this a bug? I can't find an
information at Microsoft
 
Hi

When having formulas in adjacent cells, I have found the settings 'Overwrite
....' along with 'Fill down formulas ...' to be best combination.
Have you some manually entered information in adjacent cells? When this is
the case, I have entered it into separate sheet along with key value as
leftmost column, and get it then into query's adjacent column(s) using
VLOOKUP.
 
Back
Top