software

I am working in a spreadsheet I use once a month and have for a year with no
problems. I enter in data and the spreadsheet gives me sales commissions and
profit margins. All of a sudden today the formulas in the spreadsheets are
not recalculating when the data is changed. They worked fine last month. Is
there a button or something I might have pushed to tell it not to calculate?
Thanks in advance guys. I am, of course, driven by a deadline.

Csmith

Go to Tools | Options | Calculation (tab) and check Automatic
recalculation rather than Manual. When in the manual mode you can press
F9 to get the sheet to re-calculate.

Hope this helps.

Pete
Try Tools gt; Options gt; CalculationsTab gt; make sure Automatic is checked
instead of Manual..........

Vaya con Dios,
Chuck, CABGx3
quot;Csmithquot; wrote:

gt; I am working in a spreadsheet I use once a month and have for a year with no
gt; problems. I enter in data and the spreadsheet gives me sales commissions and
gt; profit margins. All of a sudden today the formulas in the spreadsheets are
gt; not recalculating when the data is changed. They worked fine last month. Is
gt; there a button or something I might have pushed to tell it not to calculate?
gt; Thanks in advance guys. I am, of course, driven by a deadline.
gt;
gt; Csmith

Thank you so much Pete. It worked. You are a life saver!

quot;Petequot; wrote:

gt; Go to Tools | Options | Calculation (tab) and check Automatic
gt; recalculation rather than Manual. When in the manual mode you can press
gt; F9 to get the sheet to re-calculate.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;