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

"Gary''s Student" wrote:

Pull-down:

Tools Options Calculation and check Automatic
--
Gary's Student


"frankmai" wrote:

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 "Your sheets are not correct!". Thank you.