View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Worksheet Calculations not working

Hi

I suspect that calculation has got set to Manual.
What happens if you press F9?

ToolsOptionsCalculationautomatic

--
Regards
Roger Govier

"KPA" wrote in message
...
I have used a worksheet for client expense accounts for about six months.
When I updated data for the month of Jan, the formulas aren't running the
calculations to create the running balance... I have about 20 clients in
one
workbook and 40 in another, and neither workbook is functioning. I can't
figure out what changed...

There are three columns to enter expenses and one for deposits, with a
running balance in the right column. I'd appreciate suggestions on how to
get back on track.