View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jamie.cockrill@gmail.com is offline
external usenet poster
 
Posts: 2
Default Stop Excel from evaluating formulae unless I want it to

Hi All,

I've just had to create a monster sheet that essentially enables me to
do a SUMIF over 2 criteria, however there's some 15,000 cells involved
in this new sheet and it really slows the workbook down on startup and
every time it re-evaluates the formulae.

Is there any way that I could set just that sheet so that it doesn't
re-evaluate the formulae unless I ask it to (by means of a prompt or
any other method)?

Thanks

Jamie