(OT) Excel help
 

Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,
Ken
Copley

(OT) Excel help
 

On 29/11/2010 13:28, Ken Cook wrote:
Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.

Sounds like you have managed to turn off calculate automatic mode so
that a manual update is needed. Should be somewhere under Formulae
Calculation Options (XL2007) can't recall where in previous editions.

A subsitute option should be F9 = recalculate now.

The default in a new blank sheet should be calculate automatic.

Regards,
Martin Brown

(OT) Excel help
 

On Nov 29, 1:28*pm, Ken Cook wrote:
Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,
Ken
Copley

Hi Ken,

The default is to automatically update?? Here is what Excel help says


Click the Microsoft Office Button , click Excel Options, and then
click the Formulas category.
Do one of the following:
To recalculate all dependent formulas every time you make a change to
a value, formula, or name, in the Calculation options section, under
Workbook Calculation, click Automatic. This is the default calculation
setting.
Tip Alternatively, on the Formulas tab, in the Calculation group,
click Calculation Options, and then click Automatic.

cheers, Andy

(OT) Excel help
 

On Nov 29, 1:48*pm, "Andy M." wrote:
*Tip * Alternatively, on the Formulas tab, in the Calculation group,
click Calculation Options, and then click Automatic.

cheers, Andy

Hi, Andy,
Thanks for that and the speed of reply!
Working a treat now - you're a star!
Best wishes,
Ken
Copley (snowing again)

(OT) Excel help
 

On Monday 29 Nov 2010 13:28, Ken Cook scribbled:

Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,

Just a bit curious as to why you use Excel? I've used Open Office for years
and am now switching to LibreOffice (same thing but freed from Oracle's
clutches). It may not have all the bells and whistles of MS Office but it
cost me nothing instead of the four-hundred-odd quid of the equivalent
package!

--
Graham Davis, Bracknell
It was raining cats and dogs and I fell in a poodle. [Chic
Murray(1919-1985)]

(OT) Excel help
 

On Nov 29, 2:34*pm, Graham P Davis wrote:
On Monday 29 Nov 2010 13:28, Ken Cook scribbled:

Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,

Just a bit curious as to why you use Excel? I've used Open Office for years
and am now switching to LibreOffice (same thing but freed from Oracle's
clutches). It may not have all the bells and whistles of MS Office but it
cost me nothing instead of the four-hundred-odd quid of the equivalent
package!

--
Graham Davis, Bracknell
It was raining cats and dogs and I fell in a poodle. [Chic
Murray(1919-1985)]

Hi, Graham,

Met O, Environment Agency and a few others I send to all prefer the
obs in excel.
Thanks to everyone for the help btw.
Still snowing, about 4cm in past hour. Must be approaching 30cm,
allowing for compaction.

Best wishes,
Ken, Copley, Teesdale

(OT) Excel help
 

On Monday 29 Nov 2010 15:11, Ken Cook scribbled:

On Nov 29, 2:34 pm, Graham P Davis wrote:
On Monday 29 Nov 2010 13:28, Ken Cook scribbled:

Hi, All,
I know this is OT but it is a weather spreadsheet I'm working on, so
can anyone help, please?
I'm quite new to Excel having used works most of the time.
If I set up a formula, for ease I'll say the sum of a row for instance
=SUM(A1:A19) and just fill in the first 5 readings to A5 it does it OK
but any subsequent readings are not automatically added and I have to
click on the results square and enter each time.
Is there a way that the formula should update automatically? I've got
lots on my Met sheet that have to be refreshed each day.
It worked fine in works.
Thanks in anticipation,

Just a bit curious as to why you use Excel? I've used Open Office for
years and am now switching to LibreOffice (same thing but freed from
Oracle's clutches). It may not have all the bells and whistles of MS
Office but it cost me nothing instead of the four-hundred-odd quid of the
equivalent package!


Hi, Graham,

Met O, Environment Agency and a few others I send to all prefer the
obs in excel.
Thanks to everyone for the help btw.
Still snowing, about 4cm in past hour. Must be approaching 30cm,
allowing for compaction.


Ken, you can export spreadsheets from LibreOffice in Mickeysoft's non-
standard format if necessary. Many governments dumped MS in favour of
OpenOffice years ago. UK behind the times as usual. Perhaps they might
finally get around to it now to save some dosh. And switch to Linux as well.

LibreOffice:
http://www.documentfoundation.org/download/
Note that this is still in beta but seems to work OK for me.

--
Graham Davis, Bracknell
It was raining cats and dogs and I fell in a poodle. [Chic
Murray(1919-1985)]