| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate workbook in VBA
Hi,
I would like to calculate an one entire workbook and leave other open workbooks alone. I see that I can calculate one sheet, or the entire application, but I don't see how I can do a whole workbook. If I calculate the workbook one sheet at a time, the interdependence of the sheets leaves some calculations behind. Thanks, Doug |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate workbook in VBA
"Doug" wrote in message ... Hi, I would like to calculate an one entire workbook and leave other open workbooks alone. I see that I can calculate one sheet, or the entire application, but I don't see how I can do a whole workbook. If I calculate the workbook one sheet at a time, the interdependence of the sheets leaves some calculations behind. Thanks, Doug Maybe this helps. http://www.decisionmodels.com/calcsecretsh.htm /Fredrik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reset workbook back to Auto Calculate | Excel Discussion (Misc queries) | |||
| How to calculate percentage acroos sheets in a workbook | Excel Discussion (Misc queries) | |||
| Can I calculate just one worksheet in a multi-worksheet workbook? | Excel Discussion (Misc queries) | |||
| Excel won't update/calculate a single cell in a workbook | Excel Worksheet Functions | |||
| is it possible to use F9 to manually calculate in a single sheet or single workbook? | Excel Discussion (Misc queries) | |||
Hybrid Mode
