Forum Discussion
Tables Problem
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
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
5 Replies
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
Hi sandipgumtya,
Awesome 😎 ! !
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
