Excel 2003 calculations not working 1

[cjbrown815]

Hello,
I unprotected a range of cells so I can type in them and now they don't automatically calculate when I enter values. Any ideas? I can see the formulas when I click on them.

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

Hi,

Could be one of several things...

1. Tools > Options - Calculation Tab -- AUTIMATIC or hit F9 to calculate.

If that does not work...

2. Select the cells not calculating. Format > Cells - Number Tab -- Select GENERAL

If that does not work...

3. Tools > Options > View Tab -- UNCHECK Formulas in Wondows options.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Thanks, that did it. I'd like to know who changed that.

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931