Worksheet Calculations not working

  • Thread starter Thread starter KPA
  • Start date Start date
K

KPA

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.
 
Hi

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

Tools>Options>Calculation>automatic
 
check if the Manual Calculation mode is ticked,
access thru :

1) Tool on the menu bar
2) select Option
3) Calculation tab
4) check on the Automatic checkbox under Calculation

Alternatively, you may press F9 key on your keyboard requesting Excel to
re-calculate.

HTH

--
Pls click on the Yes button below if this posting is helpful.

Thank You

cheers, francis
 
First thing to check is the Calculation Tab on the dialog box the appears
when you click Tools/Options... make sure Automatic is selected from the
Calculation section.
 
Back
Top