SOLVED

Tables Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1504977%22%20slang%3D%22en-US%22%3ETables%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504977%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20have%20some%20data%20in%20an%20Excel%20Table%20format.%20As%20and%20when%20needed%20data%20need%20to%20be%20added%20to%20the%20table.%20The%20problem%20I%20am%20facing%20here%20is%20that%20the%20Table%20is%20not%20getting%20updated%20automatically.%20Every%20time%20I%20have%20to%20resize%20the%20table%20to%20include%20the%20data.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20pl%20help%20in%20why%20is%20this%20happening%3F%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20sample%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESandip%20Gumtya%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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

 

5 Replies
Best Response confirmed by sandipgumtya (Occasional Contributor)
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 ✔

 

Snag_2399a08f.png

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

Thanks @Faraz Shaikh 

This works.

 

Regards

Sandip Gumtya

 

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

Hi,

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

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