Why doesn't this function refresh. The only time it refreshes is when I
activate the cell, press F2 and Enter.

Function SheetIndex(rngSheet As Range) As Long
SheetIndex = rngSheet.Parent.Index
End Function