cell calculation problem

[dgoss]

I am trying to make a worksheet easier to use instead of using excel and a calculator. I have in the first cell 3900.00 and add 47,025.50 to get 50,925.50. I do this on a monthly basis. Next month I may have 3900.00 (same amount again) but it will not update the mtd or ytd total. Is there a way to do this or do I have to add another column. Or am I doing something wrong?

Period Comp. MTD Comp YTD Total
$3,900.00 $47,025.50 $50,925.50

Thanks in advance

 

[Dreamboat]

More than likely, all you need to do is go to Tools-Options, Calculation tab and change it from Manual to Automatic. Make sure you save the file 'cause it's a file setting, not a system setting.

However! If you ever open a file that is set to manual calculation, ALL OTHER FILES THAT YOU HAVE OPEN AT THE SAME TIME will also NOT automatically calculate. Anne Troy

http://www.TheOfficeExperts.com

 

[Digga]

Hi,

don't forget the F9 key. Digga

Sharing Knowledge Saves Valuable Time!