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