| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make an automatic calculation in changing sheet?
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make an automatic calculation in changing sheet?
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make an automatic calculation in changing sheet?
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 On Tue, 13 Dec 2005 16:01:07 -0800, "frankmai" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Automatic updating of 2nd sheet from first | Excel Worksheet Functions | |||
| Realtime Automatic sorting of data in rows in new work sheet | Excel Worksheet Functions | |||
| Automatic changing refrences to sheet corresponding to first day. | Excel Discussion (Misc queries) | |||
Linear Mode
