Changes not taking affect

[walshy06]

Hi,

I have a spreadsheet doing some basic calculations.

For Example I have a list of figures for which I have a Total row.

Apple £5
Orange £10

Total £15

Normally I can add in another row let say oranges for £5 and the total would go to £20.

Now for some reason it will not change the total. If I close the spreadsheet and then re-open it will have a total of £20.

For some reason the changes are not taking affect until I close and reopen the file.

Anyone have any ideas? Basic I know, but I don't know what I've changed and it's affecting all my workbooks.

Thanks!!!

[VBA Noob]

Hi,

Try Tools >options > Calcuation tab > Select automatic

VBA Noob

[walshy06]

That works! - Don't have a clue how that got changed..

Thanks a million.

[VBA Noob]

No problem.

VBA Noob