Not sure on where to post this one, when I create a new worksheet with various columns, some with validation choices some with calcs.  I do the usually cntrl T to create a table, but the table no longer shows the drop down lists or calculations on the value.   Which makes it a challenge if I wanted to add new data.

Just on that, if I add data to the table.and then click refresh all, all the data disappears from the table.  If I add it to the excel sheet it's added to the table.  So again altering column sizes and rows, should this be the excel sheet or the table ?  Or did I miss a setup step, as I seem to be struggling with something that should be straight forward.

Is there a tables cleanup how to...seems I have links missing where I copied data from other sheets, and tables I don't want anymore.  Not sure which does what due to the data input challenges.   Sorry long mail.