Tables Problem

[sandipgumtya]

Hi All,

          I have some data in an Excel Table format. As and when needed data need to be added to the table. The problem I am facing here is that the Table is not getting updated automatically. Every time I have to resize the table to include the data. 

Can you pl help in why is this happening? 

Attached sample file.

Thanks

Sandip Gumtya

[#2 · Accepted solution]

Hi @sandipgumtya 

Your auto table expand option might be disabled . 

Go  to File > Option > Proofing > AutoCorrect Options > AutoFormat As you type > Include New rows and column in Table 

Ensure that "Include New rows and column in Table" option is check ✔

 

this should resolve the issue..

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

[#3]

Thanks @Faraz Shaikh 

This works.

Regards

Sandip Gumtya

[#4]

Hi @sandipgumtya,

Awesome 8) ! !

Glad to hear it work.. don't forget mark the post as solved that will help others too

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

[#5]

Hi,

      Is this setting specific to a file or Excel overall? Do I need to check this every time I operate on Tables?

[#6]

Hi @sandipgumtya 

It is a global setting.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more