Calculate/Update Formulas

K

Kevin

Lately, I have been having difficulties getting Excel to
update existing formulas. I press F9 to update/calcuate
and nothing happens. However, if I go to a particular
cell with a formula, hit F2 to edit and simply press the
enter key, the formula updates.

What gives? Is this some type of virus?

Thanks for any feedback.
 
F

Frank Kabel

Hi
could you post this specific formula?
Also does hitting CTRL+ALT+F9
change the value
 
V

Vaughan

Sounds like you have something stopping the calculation. When you edit the individual cell it just calculates that cell. F9 does the whole workspace.

Is the problem on a particular workbook, or is it always happening?
Do you have circular references somewhere perhaps? Try allwoing iteration in your calculation and see if that has any effect.
 
G

Guest

It is actually several formulas, but here is one:

=VLOOKUP($C54,vlacttotal,I$1,FALSE)

This has happened in two different files in the past few
days.
 
K

Kevin

I've tried turning on iterations, even though I do not
have circulars.

This has happened on two separate files in the past few
days.
-----Original Message-----
Sounds like you have something stopping the calculation.
Click to expand...
When you edit the individual cell it just calculates that
cell. F9 does the whole workspace.
Is the problem on a particular workbook, or is it always happening?
Do you have circular references somewhere perhaps? Try
Click to expand...
allwoing iteration in your calculation and see if that has
any effect.
 
D

David McRitchie

Hi Kevin,

The fact that F2 is reentering your data is a hint. That
it is either calculation or something extra is with the formula.
It is usually that you have
Calculation turned off in options, which I see no indication
that that was checked. Tools, options, calculation (tab), ...

If that is the problem and it gets turned off again try resetting
it with only your personal.xls file open.

I have a macro that I put into a workbook when problems like
that occur. It could be a bad macro or an addin turning off
calculation and not restoring.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins


You might also try Alt+Shift+F9
Recalculate all cells on all worksheets in all open workbooks
sometimes it busts things free.

Try using the TRIMALL macro on a copy of your sheet.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
--
 
Top