Normally when referencing cells on another worksheet, the formula bar will
display something like so,

=Sheet2!B15

Under what circumstance would the formula be displayed like the following?

=Sheet2!R[-226]C

And how do I change this back to the "normal" formula format?

Many thanks!