Hi All,
Using Excel 365 on the office. We have a table in the sheet and when inserting a row a value is filled automatically in one of the cells. All other cells are behaving as expected.
Problem is that we don't know where this value is coming from. It is filled with a very simple formula ( =650/1) but again, we don't know where this is coming from.
Is there a way to find out where an inserting table row is getting it's "info" when inserting a new row? It doesn't matter where in the table I insert the new row, neither does the method (insert row or insert table row above) and the surrounding rows do not have such a value in them (in fact they all have a formula in them that should be on the place where now 650/1 is presented).
Looking forward to your thoughts on this.
Evert
Bookmarks