Cells with formulas won't update unless I click in browser Why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of a sudden the worksheets in "My Documents" are not functioning
properly. Cells that have formulas in them that should update automatically
don't update.
For example I have Cell C1 that should be the total of cell A1 - cell B1.
When I enter amounts in cell A1 and cell B1, cell C1 stays at 0.00 unless I
click on cell C1, position my curser with a click somewhere in the formula
bar and hit enter.

The worksheets I access through my C drive are working fine. It's only the
worksheets in My Documents that are affected.

Anybody have an answer?
 
Alan,
Thank you very much. I don't remember going in and changing it to manual in
the first place so I never thought to go change it "back". But that is
exactly what I needed.

Nancy
 
Excel sometimes seems to develop a mind of it's own and do things like that
all by itself for no apparent reason! I've had several options change
themselves over the years,
Regards,
Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Cells 2
setting cell values based on a 3rd cell 4
How to return a blank formula cell if the reference is blank? 2
Formula To Keep Certain Cells Blank 5
VLookup formula question 2
Excel Formula and Variance Analysis 0
Adding Cells, Get Error. 2
Copy formula down - cell references change - result is same for al 6

Back
Top