Jul 05 2020 11:17 PM
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
Jul 05 2020 11:35 PM - edited Jul 05 2020 11:37 PM
Solution
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
Jul 05 2020 11:56 PM
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
Jul 06 2020 12:05 AM
Hi,
Is this setting specific to a file or Excel overall? Do I need to check this every time I operate on Tables?
Jul 06 2020 12:12 AM
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
Jul 05 2020 11:35 PM - edited Jul 05 2020 11:37 PM
Solution
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