Hi All,

This is a weird one I've never come across before. I'm using Excel 2010 and referencing cells to other cells in another worksheet. All of a sudden what is displayed is not the content of the referenced cell but the actual formula used! My Excel is fully up-to-date and "Show Formulas" is not enabled.

If you look at the screen shot below I've uploaded, you'll see the cell I've selected works perfectly with the formula used shown in the formula bar. After that it all goes very weird!

Has anyone experienced this and if so, is there a fix?

Many thanks

formula error.JPG