Thread: Unable to get a correct total when changing data within a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Unable to get a correct total when changing data within a formula
try:

Tools Options Calculate and check automatic.
--
Gary''s Student - gsnu200763


"JMac" wrote:

Doing a simple formula Cell A-Cell B and when I change data in cell A or B,
the total is not changing automatically. I event started a new excel sheet
and it is doing the same thing.

Reply With QuoteReply With Quote