Formulas will not update!!

[ahamed]

Hi !!

I have problem with formula not being updated. All my excel file has this problem and when ever I update my excel workings the totals or any other formulas given doesn't update itself. Always I have to go to the formula and double click and enter, it to work.

I have checked whether my excel is set to manual calculations and ensured its set for automatic. Even I pressed F9 yet my formulas doesnt get update it self. I have big trouble with this as I have huge file with huge no of formulas.

Pls help me on this

thanx

 

[RoryA]

It still sounds to me like your calculation is getting set to manual. Are you checking the setting while that workbook is open?

 

[ahamed]

hi !!

any 1 can help me ?? Pls

 

[ahamed]

Hi
Yes.. I do always go and check my calculation (even I try with F9)

 

[ahamed]

I checked this way !!!!!!!!!

Excel options > Formulas > Workbook Calculation > Automatic

 

[RoryA]

Are you sure you are giving the computer enough time to recalculate? (Does it say Calculate in the status bar?)

 

[ahamed]

Hi !

simply it doesnt calculate even when I input any figures in between C7 to J 7 when when the K7 is given SUM(C7:J7)

What do you mean by statues bar ?

 

[ahamed]

& how to do

Tools-Options-Security tab - is the 'Remove personal information from file properties on save' option checked?

I have excel 2007,, I do not find tools here ...

thnx

 

[RoryA]

I assume you mean =SUM(C7:J7)

The status bar is the grey bar at the bottom of the application window - does it say 'Ready' or 'Calculating' in the bottom left corner?

 

[RoryA]

In 2007, it's:
Office button - Excel Options - trust Center - Trust Center Settings - Privacy Options - Remove personal information from file properties on save.

 

[ahamed]

Hi


1) yes its =SUM(C7:J7)

2) Remove personal information from file properties on save - was checked (ticked) & I un-ticked & tried- it doesn't work

3) While I enter something within =SUM(C7:J7) range I get enter message first & then ready (on my left corner) However, just after that I can see "calculate" not (calculating)