The most common reason why users find that the output of the template does not reflect the inputs is that the input data is not entered inside the tables correctly. To know if your data is inside the Table, click on the cell and see if Table Tools ribbon appears.
Table Tools – Design Ribbon
If it does, your data is inside the table. If not, it is not inside the Table and hence will not be reflected in any dependent calculations.
If you are inside the table and want to know the boundaries of the table, press Ctrl+A. Excel will select all the data cells inside the table and thus show us the boundaries.
Finding Boundary of Table
To know more about the table, please check the below article:
