Hi

You can simply replace all formulas with their values (PasteSpecial.Values).
Of-course there is no way back later, but it's the only way, I'm afrayd.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"ianripping " wrote in message
...
I know that you can stop a whole workbook from being automatically
calculated but can it be done for just one sheet?


---
Message posted from http://www.ExcelForum.com/