Forum Discussion
Workaround for data table that uses results from another data table.
The "Data Tables" were each created by using the "Data" menu and selecting "Table", at which point a "Data Table" window popped up asking for either a "Row Input Cell" or a "Column Input Cell".
Both of the Data Tables I was referring to happened to use Column Input Cells.
Each Data Table serves the usual role of taking a list of input values from the left column, sequentially sending these values to a "Column Input Cell" located somewhere else on the spreadsheet, and then recording how the value of another cell in the header of the table changes in response to the changes in the Column Input Cell.
Due to the way that Excel is written, any time the data recorded in a "Data Table" is directly or indirectly dependent on results from another "Data Table" the evaluation procedure is unreliable.
For example, see this reference: https://excelhelphq.com/why-your-excel-data-table-does-not-work-and-how-you-can-fix/
all roads to Roman。
if data table not easy to accomplish one task，maybe another way available。