View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MikeR-Oz MikeR-Oz is offline
external usenet poster
 
Posts: 46
Default Change a cell reference - NO affect until save file??

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