calculate

[computers hate me]

I have a workbook with many spreadsheets and formulas so i have it set up for
manual update. I have one sheet called "Top Ten Graphical Overview" I want
to be able to update only that sheet without the rest of the workbook
updateing cause it takes too long. is it possible to do that?
possibly a macro?

 

[Mike H]

Maybe,

Tools|Options|Calculation
Calc Sheet

Or tap F9

Mike

 

[John C]

Just my 2 cents, but if the Top Ten Graphical overview has any calculations
based on any other sheet, wouldn't you 'want' the whole workbook to
calculate? If the Top Ten Graphical overview does not have any calculations
based on the other sheets, why not make it its own separate workbook?

 

[computers hate me]

Ok the rest of the sheets have already been updated through a macro. This
macro puts in some formulas to a couple of the worksheets. So at the end i
want to update this sheet with the graphs but the rest of the workbook is
already updated. When i clicked F9 it recalculated the entire workbook.

 

[computers hate me]

wait i just tried the tools|options|Calculation and it works

THANKs

 

[John C]

I gotta ask. If the rest of the workbook is updated via macro, why not have
the macro update this page as well?

 

[computers hate me]

i guess i wasnt thinking of that at that point but i did add it to the macro
so that it updates it

Thanks