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 - 27 Mar 2007 13:55 GMT
Without looking, perhaps you have calculation set to manual instead of
automatic?

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
> 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
[quoted text clipped - 15 lines]
> Joe
> P.S. Running XP Pro Service Pack 2 with Office 2007 Professional
Joe727 - 27 Mar 2007 18:30 GMT
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
> Without looking, perhaps you have calculation set to manual instead of
> automatic?
[quoted text clipped - 18 lines]
>> Joe
>> P.S. Running XP Pro Service Pack 2 with Office 2007 Professional
Joe727 - 29 Mar 2007 13:15 GMT
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
> Hi - It's set to automatic. Here's a screenshot:
>
[quoted text clipped - 26 lines]
>>> Joe
>>> P.S. Running XP Pro Service Pack 2 with Office 2007 Professional