Cross-sheet formula and sort data
 

Not sure if this is a new issue with Excel 2007 or if it was there before.
When entering a formula into a worksheet (call it Sheet1), I firstly clicked
open a second sheet before going back to the first sheet. The resulting
formula was then Sheet1!(formula). I realised that Sheet1! wasn't necessary,
but didn't think it would be an issue. How wrong I was!

When I later sorted the worksheet into a different order, the cell formulae
were not amended to reflect the new order. To correct this it was necessary
to delete all reference to Sheet1!

Is this by design, or a flaw in the program?