Excel 2007 Checkbook Register Question

[Joe727]

Hi - I am a noob to Excel. I downloaded the checkbook register from the
Excel website figuring it would be an easy way for me to become familiar
with the program. Here's what I downloaded:


http://office.microsoft.com/en-us/templates/TC101909831033.aspx?pid=CT101438521033


I put my "Balance Forward" in the top row, then added a deposit. The
deposit and the "Balance Forward" added correctly.

Then, I entered a check, but for some reason the amount of the check, which
was placed in the Debit cell, did not automatically subtract from the
balance.

Question - How do I get this template to work?

Thanks

Joe
P.S. Running XP Pro Service Pack 2 with Office 2007 Professional

 

[Don Guillett]

Without looking, perhaps you have calculation set to manual instead of
automatic?

 

[Joe727]

Hi - It's set to automatic. Here's a screenshot:

http://home.cfl.rr.com/jbmsbink/Excel1.jpg

Should I just redownload the template and start over?

Joe

 

[Joe727]

I found the solution. I had to manually calculate the first Debit amount
and enter the balance. The formula automatically adds and subtracts now.

Joe