Calculating single sheets in a workbook Excel 2007

[waxb18]

I have a workbook with A HELL OF A LOT of data...so big infact that i have had to upgrade to Excel 2007

In my previous version of excel you could calculate a single worksheet rather than the whole book, but after a lot of looking i cant find this function on 2007....

Any ideas???

 

[GlennUK]

According to the help SHIFT+F9 calculates the active worksheet.

 

[waxb18]

According to the help SHIFT+F9 calculates the active worksheet.

Thanks a bunch

My other question is....

can you calculate a selected range within a worksheet... i.e. one column at a time??

 

[GlennUK]

You could write a macro to do that for you, or you could do the old trick of selecting a range and doing Edit/Replace "=" with "=" /Replace All.