K
ksp
One of my users has a spreadsheet that has several simplistic formula'
eg =A1+A10+A15 etc adding about 35 different cells.
She used the 'trace precedents' tool to check her formula and for som
strange reason two cells were not 'marked' as being precedents eve
though they definitely are. I have tried going to one of the offendin
cells and used the trace dependants tool and excel recognises that thi
cell is included in the formula but just not back the other way.
I have tried doing this on a few different PC's and the result is th
same.
I have never come across this before - has anyone else ?
Anyone have any suggestions as to what may cause this ?
Thanks in advanc
eg =A1+A10+A15 etc adding about 35 different cells.
She used the 'trace precedents' tool to check her formula and for som
strange reason two cells were not 'marked' as being precedents eve
though they definitely are. I have tried going to one of the offendin
cells and used the trace dependants tool and excel recognises that thi
cell is included in the formula but just not back the other way.
I have tried doing this on a few different PC's and the result is th
same.
I have never come across this before - has anyone else ?
Anyone have any suggestions as to what may cause this ?
Thanks in advanc