Taming External data/Table update process

[andydtaylor]

Hi,

I am battling table properties for external data refreshed in Excel. I want a table shrinking/growing to add/remove rows in a Spreadsheet. Should be possible, right?

It feels like the guy at Microsoft writing this functionality got fired halfway through, and it's not finished! Has anyone found a way to trick Excel into doing this? I have tried merging cells below tables to no avail.


My use case (for data added) onlky:

Table in Range D12: L58

1. Insert cells for new data
Content on Line 60 and below is broken between Columns A&C and M & beyond (i.e.to XFD). Content between columns D&L is shifted down

2. Insert Entire rows for new data, clear unused cells
Content on Line 60 and below is <b>broken between Columns A&C<b>. Content from Columns D to beyond (i.e.to XFD) is shifted down uniformly.

3. Overwrite existing cells.
Overwrites cells. Bad


Thanks,


Andy

 

[igold]

Your description is a little fuzzy. Do you have any code to show us what you are trying to do. What is the name of the Table you are trying add lines to.

 

[andydtaylor]

Hi

Thanks for your reply. No code but let me try rephrasing.

Out of the box Excel tables connected to external data have 3 options for controlling their behaviors on update (addition to) externally connected data. These are:

1. Push area down only immediately below table and remove if table rows not required on subsequent update (introduces misalignment)
2. Insert rows (no capability to remove rows) below and to the right of table but not to the left or table (introduces misalignment)
3. Overwrite content below your table.

I would like a table growing or shrinking to add or remove entire rows below the table. I’m an adult, I should be allowed to do this... (2) comes closest but obscurely this does not insert rows to left of table and cannot remove them when external data shrinks.


Any thought on extracting the behavior I would like from Excel is appreciated

Thanks

Andy