is it possible to use F9 to manually calculate in a single sheet or single workbook?
 

is it possible to use F9 to manually calculate in a single sheet or single
workbook?
as i have got over 500 cells with vlookup in a single sheet, with more than
50 sheets in a workbook.
Thank you!!

Shift+F9 will calculate only the active sheet. From the
XL Help for XL2003:

-----
Press F9 Calculates formulas that have changed since the
last calculation, and formulas dependent on them, in all
open workbooks. If a workbook is set for automatic
calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed
since the last calculation, and formulas dependent on
them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open
workbooks, regardless of whether they have changed since
last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and
then calculates all formulas in all open workbooks,
regardless of whether they have changed since last time
or not.
----

HTH
Jason
Atlanta, GA

-----Original Message-----
is it possible to use F9 to manually calculate in a
single sheet or single
workbook?
as i have got over 500 cells with vlookup in a single
sheet, with more than
50 sheets in a workbook.
Thank you!!


.

Thanks a lot for your prompt and helpful reply!

"Jason Morin" wrote in message
...
Shift+F9 will calculate only the active sheet. From the
XL Help for XL2003:

-----
Press F9 Calculates formulas that have changed since the
last calculation, and formulas dependent on them, in all
open workbooks. If a workbook is set for automatic
calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed
since the last calculation, and formulas dependent on
them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open
workbooks, regardless of whether they have changed since
last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and
then calculates all formulas in all open workbooks,
regardless of whether they have changed since last time
or not.
----

HTH
Jason
Atlanta, GA

-----Original Message-----
is it possible to use F9 to manually calculate in a
single sheet or single
workbook?
as i have got over 500 cells with vlookup in a single
sheet, with more than
50 sheets in a workbook.
Thank you!!


.