PaulFogel123
Member
Hello,
On the attached table, I have data validation in columns C, D, and E. And there is a formula in Column F. Adding a row by entering data in columns B, C, D, or F produces the expected result--the new row is part of the table and the data validation extends to the new rows. The formula in column F is also extended to the new row.
Here's the problem: I have the identical table (except for many more rows) in another workbook. When I do the exact same thing above it expands the table, but the data validation is not extended to the new row, nor is the formula in column F extended to the new row. However, if I move the cursor to the last row and select Insert>Table Row Below it works in the expected way.
What could be the issue? Is there a setting that needs to be adjusted?
Paul
On the attached table, I have data validation in columns C, D, and E. And there is a formula in Column F. Adding a row by entering data in columns B, C, D, or F produces the expected result--the new row is part of the table and the data validation extends to the new rows. The formula in column F is also extended to the new row.
Here's the problem: I have the identical table (except for many more rows) in another workbook. When I do the exact same thing above it expands the table, but the data validation is not extended to the new row, nor is the formula in column F extended to the new row. However, if I move the cursor to the last row and select Insert>Table Row Below it works in the expected way.
What could be the issue? Is there a setting that needs to be adjusted?
Paul