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

H

Hersbt

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!!
 
J

Jason Morin

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.
 
H

Hersbt

Thanks a lot for your prompt and helpful reply!

Jason Morin said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I calculate a single page ONLY? 1
F9, Shift+F9, Ctrl+Alt+F9 etc 3
Is it possible to Calculate a single worksheet at a time? 1
Saving / emailing sinlge excel sheet, not entire workbook 2
Need to merge worksheets - Excel 2003 0
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
Urgent- Help ! (Message 'Calculate' Appears) 2
Reference to sheet name in another workbook 3

Top