How can I make an automatic calculation in changing sheet?

F

frankmai

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.
 
F

frankmai

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

Gord Dibben

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 MVP
 
Top