adding new column to a table that has pivot table

[lezawang]

Hi
I created a table. The formatted it to a table (Insert-->Table) then create a pivot table from that table. if I add a new row then I will see the new item after I refresh the pivot table but when I added a column, the column name is not showing under Fields List? I click on Analyze--> Change Data source then I saw excel did not include the new column? How can I include the new column automatically? why only row added automatically? I thought using table format would solve this issue but it did not. Thank you.