Forum Discussion

sandipgumtya's avatar
sandipgumtya
Copper Contributor
Jul 06, 2020
Solved

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 automaticall...
excel
  • ExcelExciting's avatar
    ExcelExciting
    Jul 06, 2020

    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

ExcelExciting's avatar
ExcelExciting
MVP
Jul 06, 2020

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

  • sandipgumtya's avatar
    sandipgumtya
    Copper Contributor
    Jul 06, 2020

    Hi,

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

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Jul 06, 2020

      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

       

Resources