Spreadsheet not updating

[Raykeith30]

Hi all,

I keep having a problem with a particular set of spreadsheets sent to me every year by a client. I always find that when I try to alter or update costs on them, the spreadsheet won't update, even though the formula is entered correctly.
For example, I could enter '1' in box a1, '1' in box a2, and then the formula 'a1+a2' in box a3. It will work and give the answer '2', but then if I change either a1 or a2 to another number, a3 will remain at '2' and will not update.
I then find that if I close the spreadsheet and open a new one, or an existing one which previously worked fine, the problem remains.
Has a switch been set on these spreadsheets which tells them not to update, and, if so, how do I switch it back?

Cheers, Ray.

[Richard Buttrey]

Hi,

Have you checked that calculation is not set to manual?

Excel 2003 Tools>Options>Calculation
Excel 2007 Office Button>Excel Options>Formulas

The first workbook opened in a new Excel session sets the calculation mode of the Excel Application. If this first workbook has been set to manual all subsequent workbooks you open will calculate manually. i.e. this is an Application setting not a Workbook setting.

HTH

[Raykeith30]

Hi
Yes, this seems to have solved the problem,

Cheers, Ray.