Forum Discussion
nicholasjcstubbs
Jul 10, 2023Copper Contributor
Trace precedents of datatable
I have used the {=table(cell ref,)} datatable function to calculate a range of outputs from a range of inputs. Now I wish to check the calculations but trace precedents does not work with this functi...
SergeiBaklan
Jul 22, 2023Diamond Contributor
TABLE() function from What-If Analysis is actually the macro which fills the range with calculated values. Table Precedents doesn't work with it.