There are 3 ways I know of to do something like this:

1. split the workbook into several workbooks, one containing all the "auto"
sheets and then one book for each of the "manual" sheets.
You will need links between the books as appropriate.
Then you can open the "auto" book and the "manual" book you are currently
interested in. Then when you want a different "manual" book you close the
one thats open and open the next one.

This will not work well if the links between the sheets are complex, and you
would need to have Excel in automatic mode so that the open "manual" book
would always calculate.

2. write some VBA that uses the enablecalculation property of the worksheets
to control whether they get automatically recalculated or not. This is not
all that straighforward.

3. use FastExcel mixed calculation mode.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
Is there some way I can tell Excel to auto calculate some sheets, but to
set others to manual? Essentially I have a bunch of sheets that all need
auto calc, but then another set that do final analysis and I'm only
interested in one of them at a time. If I could shut the others down it
would speed things up.

Incidentally, I'm using Excel 97 if that makes any difference.

Thanks...

Bill