View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
frankmai
 
Posts: n/a
Default How can I make an automatic calculation in changing sheet?

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.