View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Columns not totaling unless you save worksheet

In Excel click the TOOLS menu item and select OPTIONS. Click the CALCULATION
tab and click the AUTOMATIC option button to reset calculation from manual
back to the default.
--
Kevin Backmann


"Lori G" wrote:

I had set up worksheets for some people. I had someone today tell me that
when they enter the information in it doesn't total the data anymore. When I
checked on the problem I found that after entering in the data it would not
total, but if you saved the worksheet it would total the data. I do not use
the worksheets so I do not know if there were any changes made. The
worksheets are password protected, but their supervisor knows the password,
so it is plausible that they were changed.

Is there anything you know of that would cause this?