I have a list of data where some cells contains links to other cells within the list. When I sort the list the data within the list is moved around but the row numbers keeps their numbers. This means that data that was in cell B5 suddenly might be in B10. Usually Excel updates the links accordingly, (i.e. the cell that linked to B5 before would now have linked to B10) but today I noticed that the links did not update while sorting. Does anybody knows if this is a new behaviour, or have I just not noticed this particular behaviour when sorting before?
Bookmarks