Forum Discussion
Workaround for data table that uses results from another data table.
There are data tables and data tables and data tables. All kinds of data can be entered into a table.
You could help us help you if you were more complete in your descriptions of the kinds of data, and perhaps, as well, how it is that your table 1 differs from your table 2, how each is created in the first place, what the relationship is ("relationships are"?) between the two. How are they used? What is the nature of a "call from the 2nd" that "triggers" some sort of re-evaluation of the first (and why that direction, since the second is the less reliable?
You see the point? What you've described is no doubt clear in your own mind, but you are close to it and making assumptions about those of us reading your description. Is it possible--without violating any confidentiality--for you to post a copy of the workbook in question on OneDrive or GoogleDrive, pasting a link here that grants edit access? That too would help us help you.
(I'm quite sure it's not related, but I'm also on a Mac and my version is 16.69)
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/
- how about show some raw data in detail and expected result？
all roads to Roman。
if data table not easy to accomplish one task，maybe another way available。 - Thanks for the education. I've never seen that type of data table; all of the ones I've worked with contain basically static data. That static data may get there (I do have some of these among my own workbooks) by means of FILTER or VLOOKUP or XLOOKuP or the like, but I don't experience the kind of instability and unreliability you are.
