Table will not auto update and add new data into the table

[Leicester City Fox]

Hi there

Have a table in Excel it does not when I add data underneaththis and press control t it will not add it to the table and the setting areticked for it to automatically update the data add but it will not do this.

Any ideas how to get my new data added to my current table?

Thanks
Leicester Fox

 

[Fluff13]

Cross posted https://www.mrexcel.com/forum/excel...-not-auto-update-add-new-data-into-table.html

 

[vletm]

Leicester City Fox
Please, reread:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[GraH - Guido]

As it was not answered on the other forum.
Simply copy/pasting underneath an existing table will resize the table automatically. No need to CTRL+T. That is required to convert a range to a table.
If your table has a total row, you paste by selecting the first cell of the total row. The new rows are inserted while keeping the total row alive, so to speak.

 

[Leicester City Fox]

As it was not answered on the other forum.
Simply copy/pasting underneath an existing table will resize the table automatically. No need to CTRL+T. That is required to convert a range to a table.
If your table has a total row, you paste by selecting the first cell of the total row. The new rows are inserted while keeping the total row alive, so to speak.

Hi GraH Guido

Thank you for Replying this work

Many Thanks

Leicester Fox