Excel 2007 Checkbook Register Question

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/t...=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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Joe727" <nospam@nospam.nospam> wrote in message
news:er%23GsYEcHHA.4176@TK2MSFTNGP02.phx.gbl...
> 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/t...=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
>

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

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:uiuI98GcHHA.5044@TK2MSFTNGP05.phx.gbl...
> Without looking, perhaps you have calculation set to manual instead of
> automatic?
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "Joe727" <nospam@nospam.nospam> wrote in message
> news:er%23GsYEcHHA.4176@TK2MSFTNGP02.phx.gbl...
>> 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/t...=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
>>
>
>

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

"Joe727" <nospam@nospam.nospam> wrote in message
news:exa7gWJcHHA.4000@TK2MSFTNGP02.phx.gbl...
> 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
>
> "Don Guillett" <dguillett1@austin.rr.com> wrote in message
> news:uiuI98GcHHA.5044@TK2MSFTNGP05.phx.gbl...
>> Without looking, perhaps you have calculation set to manual instead of
>> automatic?
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "Joe727" <nospam@nospam.nospam> wrote in message
>> news:er%23GsYEcHHA.4176@TK2MSFTNGP02.phx.gbl...
>>> 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/t...=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
>>>
>>
>>
>
>