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...
Forum Discussion
Hi,
I realise this is an old thread but it's so close to answering my question that I'll start here.
I've been given responsibility of managing and maintaining an Excel spreadsheet that make a lot of use of {=table(cell ref,)} but I don't know how this was set up; I don't know what table is being referenced, what formulae feed into the table or anything other than the address of cell ref and the value of the output.
Surely there must be a way of viewing what feeds into this function? Can anyone point me in the right direction?
Any help will be appreciated.