Can I get Excel to recalculate just one cell?
On Mon, 26 Apr 2010 11:56:12 -0700 (PDT), Wouter HM
wrote:
Hi Prof Wonmug,
Try This
Open Tools - Options
Goto tab Calculation
Select option Manual
Click OK
If you have the line of code below comment it out:
Application.Volatile
Use the F2 option as before
I've never used Application.Volatile. I'm volatile enough without
setting a special option. ;-)
The manual option seems to work. Is there any downside other than I
have to press F9 to see the results if I change anything? What won't
work that used to with option automatic?
I noticed that there is also an option manual except table. I'm not
sure exactly what that does, but it seems to make F2 work just like
with option manual, but if I change a constant that is used in a
table, the table gets updated.
Do you run with option manual always on or just when you need it?
|