How can I make an automatic calculation in changing sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
My Workbook Option has the Automatic check the calculation still not run
unless hit the F9 button! Hope I have another answer. Thanks.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Names and Auto-calculation 2
Custom Function Won't Auto-Calculate 5
Name field - automatic calculate 2
Recalculating when an Excel sheet gets the focus from outside Excel 10
Why doesn't Excel understand what 'Manual' for Calculations? 4
Backwards Compatibility with Excel 2002 2
Sheet tab names change automatically 3
Automatic calculation is not working 4

Back
Top