Maybe you could do this:

select all the worksheets
select a single cell
edit|Replace
what: = (equal sign)
with: =
replace all
Ungroup the sheets

Yirmin wrote:

I've got the same problem as the other guy with the very large work book that only recalcs when you close and reopen it. I've tried ctrl alt f9, I've tried ctrl shift alt f9 and the don't do a thing. Is there something that has to be turned on in excel to enable this?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

--

Dave Peterson