Help with MS Excel - formulas

Posted By Message

sticklee
LIF Adult

Member since 8/06

2984 total posts

Name:
Stick

Help with MS Excel - formulas

I have an excel spreadsheet that I use every month to track bills. I have several formulas in the spreadsheet and additions/subtractions used to automatically update my totals.

For the last week or so, the totals have not been automatically updating as I update bills. I've found that I have to click into the cell with the formula and hit "enter" in order to get the sum/total to update.

Can anyone help me understand why this might be happening? FM me for more details if you think you can help!

Thanks!

Posted 6/13/08 3:06 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

ali120206
2 Boys

Member since 7/06

17796 total posts

Name:

Re: Help with MS Excel - formulas

Go to Tools - Options and then pick calculation tab.

Make sure the automatic calculation is selected.

This happens to me sometimes at work - for some reason auto calculate gets turned off.

Posted 6/13/08 3:09 PM
 

chikita315
Love

Member since 8/06

7945 total posts

Name:
M-lo

Re: Help with MS Excel - formulas

Go to the Tools menu, pick Options

Then you'll get a pop-up

Go to the Calculations tab - make sure "Automatic" is selected

That should do it

Posted 6/13/08 3:11 PM
 

sticklee
LIF Adult

Member since 8/06

2984 total posts

Name:
Stick

Re: Help with MS Excel - formulas

Ahhh - that was it! I have no idea why that happened!

Thank you so much ladies Chat Icon

Posted 6/13/08 3:21 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™
Excel Question MsG 4/17/06 5 Families Helping Families ™
switching formulas aja 10/25/05 7 Parenting
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™
Question about changing formulas...May be a little TMI SoinLove 8/19/05 2 Parenting