November 6, 2019
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.
July 16, 2010
Is it possible that this table is a Power Query table? If the data is being loaded to the table by Power Query then it will overwrite anything that you manually enter when you refresh, but if it's just a table you created with data entry, then the issue of data validation and formulas disappearing shouldn't happen.
Are you able to share the file in question so I can try to re-produce the issues.