Values do not update (1 Viewer)

M

MGumbrell

Registered User.

Local time

Today, 07:48

Joined

Apr 22, 2005

Messages

129

• Nov 27, 2008

• #1

I have been using the same worksheet for months. All of a sudden the values of formulas do not update when an associated range value is changed. I can F2 the cell and the cell value changes accordingly but there are a lot of formulas.

Can anyone tell me:-
01 - Why this may have happened (to avoid it in the future)
02 - Can I repair it (otherwise I will have to create the sheet again)

Thank you
Matt

 

chergh

blah

Local time

Today, 07:48

Joined

Jun 15, 2004

Messages

1,414

• Nov 27, 2008

• #2

Check Tools>Options>Calculation Tab and make sure that the 'automatic' radio button is selected.

 

M

MGumbrell

Registered User.

Local time

Today, 07:48

Joined

Apr 22, 2005

Messages

129

• Nov 28, 2008

• #3

That was it. Unsure how that was changed but at least its fixed now.

Thank you.

 

S

shades

Registered User.

Local time

Today, 01:48

Joined

Mar 25, 2002

Messages

516

• Nov 28, 2008

• #4

Sometimes an inadvertent key combination can turn it off.

 

wiklendt

i recommend chocolate

Local time

Today, 16:48

Joined

Mar 10, 2008

Messages

1,746

• Feb 5, 2009

• #5

FYI in Excel 2007 this option is found in:

Office orb > Excel Options (down the very bottom on the right) > Formulas > Calculation Options > workbook calculation: (automatic|auto with exceptions|manual).

takes me bloody ages to find certain things in 2007 version of office programs, but hey, there are also a hellava lot of improvements too