There you go - learnt another excel moment . !!!!!

"ShaneDevenshire" wrote:

Hi,

Maybe the spreadsheet was set to Manual recalc for a reason. So
alternatively you can press F9, Shift+F9, Ctrl+Alt+F9, or Ctrl+Alt+Shift+F9.

All of these commands recalculate the workbook or application in one way or
another. Of course the easiest is F9.
--
Thanks,
Shane Devenshire


"MikeR-Oz" wrote:

Why is this:

- it may be as simple a reference such as being in D4 and placing command
=C4 and copying it down 1 cell by dragging the corner of the cell down BUT
the cell D5 does not change to reflect what should be =C5. The formulae is
reflected correctly in the top window for D5 but I have to do a save for the
change to take effect.

????

Mike