software

I regularly print out wrong data from the Excel Sheets because when I change
to the sheet needed to be printed, I have to hit F9 for recalculation. I
forgot to do it most of the time! Please let me know how to overcome this
problem. I sent the workbook to my co-workers and aways got their complain
with the feedback quot;Your sheets are not correct!quot;. Thank you.

Pull-down:

Tools gt; Options gt; Calculation and check Automatic
--
Gary's Studentquot;frankmaiquot; wrote:

gt; I regularly print out wrong data from the Excel Sheets because when I change
gt; to the sheet needed to be printed, I have to hit F9 for recalculation. I
gt; forgot to do it most of the time! Please let me know how to overcome this
gt; problem. I sent the workbook to my co-workers and aways got their complain
gt; with the feedback quot;Your sheets are not correct!quot;. Thank you.

My Workbook Option has the Automatic check the calculation still not run
unless hit the F9 button! Hope I have another answer. Thanks.

quot;Gary''s Studentquot; wrote:

gt; Pull-down:
gt;
gt; Tools gt; Options gt; Calculation and check Automatic
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;frankmaiquot; wrote:
gt;
gt; gt; I regularly print out wrong data from the Excel Sheets because when I change
gt; gt; to the sheet needed to be printed, I have to hit F9 for recalculation. I
gt; gt; forgot to do it most of the time! Please let me know how to overcome this
gt; gt; problem. I sent the workbook to my co-workers and aways got their complain
gt; gt; with the feedback quot;Your sheets are not correct!quot;. Thank you.

Are you using Excel worksheet functions or User Defined Functions?

If not constructed properly UDF's will not calculate until forced to.Gord Dibben Excel MVPOn Tue, 13 Dec 2005 16:01:07 -0800, quot;frankmaiquot;
gt; wrote:

gt;My Workbook Option has the Automatic check the calculation still not run
gt;unless hit the F9 button! Hope I have another answer. Thanks.
gt;
gt;quot;Gary''s Studentquot; wrote:
gt;
gt;gt; Pull-down:
gt;gt;
gt;gt; Tools gt; Options gt; Calculation and check Automatic
gt;gt; --
gt;gt; Gary's Student
gt;gt;
gt;gt;
gt;gt; quot;frankmaiquot; wrote:
gt;gt;
gt;gt; gt; I regularly print out wrong data from the Excel Sheets because when I change
gt;gt; gt; to the sheet needed to be printed, I have to hit F9 for recalculation. I
gt;gt; gt; forgot to do it most of the time! Please let me know how to overcome this
gt;gt; gt; problem. I sent the workbook to my co-workers and aways got their complain
gt;gt; gt; with the feedback quot;Your sheets are not correct!quot;. Thank you.