From memory as I don't have excel 2007 on this PC, so this may not be quite right!
Go to the Office button (top left) - Select Excel options at bottom.
In the general tab Clear the R1C1 reference style check box.
Its in the Formulas Tab (there isn't a general tab)
Hope this helps.