Formula copy and paste problem

  • Thread starter Thread starter Gary Jordan
  • Start date Start date
G

Gary Jordan

All of a sudden when I copy and paste a simple formula like =H17-E17
from cell G17 into cell G18, the formula bar says the correct formula
=H18-E18 is present, but the absolute value from G17 shows up in G18
rather than the correct value. What has happened?
 
Gary,

Most likely your calculation mode has somehow changed to manual (for
instance by loading a file in which that mode was set).

Tools / Option / General tab and checking automatic will solve that
problem.



--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top