Updating linked cells within a workbook, from worksheet to workshe

(Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
Many of the sheets contain cells that refer to values in other sheets. I
recently found that some of the values were incorrect (I believe they were
just not updated). When I double clicked on the cell, gained access to the
formula and then hit enter, the cell updated. I'm wondering 2 things -

1) Under what circumstances will cells NOT automatically update? I thought
they always updated automatically as long as you're working within the same
workbook.

2) Is there a way that I can update all cells at once?

is calculation set to manual or automatic (tools / option / calculation tab)

pressing the F9 key should update all formulas

Cheers
JulieD

"notloiseweiss" <notloiseweiss@discussions.microsoft.com> wrote in message
news:F11F5387-8005-4C30-93D0-5E71864B5BB1@microsoft.com...
> (Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
> Many of the sheets contain cells that refer to values in other sheets. I
> recently found that some of the values were incorrect (I believe they were
> just not updated). When I double clicked on the cell, gained access to
> the
> formula and then hit enter, the cell updated. I'm wondering 2 things -
>
> 1) Under what circumstances will cells NOT automatically update? I
> thought
> they always updated automatically as long as you're working within the
> same
> workbook.
>
> 2) Is there a way that I can update all cells at once?

Thanks for the response.
I didn't know about this Tools -> Options -> Calculation setting, so it is
useful to know. Unfortunately, my setting is already on update.

The F9 is also good to know about, although it sounds like I shouldn't need
to use it since I already have automatic updates on...


"JulieD" wrote:

> is calculation set to manual or automatic (tools / option / calculation tab)
>
> pressing the F9 key should update all formulas
>
> Cheers
> JulieD
>
> "notloiseweiss" <notloiseweiss@discussions.microsoft.com> wrote in message
> news:F11F5387-8005-4C30-93D0-5E71864B5BB1@microsoft.com...
> > (Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
> > Many of the sheets contain cells that refer to values in other sheets. I
> > recently found that some of the values were incorrect (I believe they were
> > just not updated). When I double clicked on the cell, gained access to
> > the
> > formula and then hit enter, the cell updated. I'm wondering 2 things -
> >
> > 1) Under what circumstances will cells NOT automatically update? I
> > thought
> > they always updated automatically as long as you're working within the
> > same
> > workbook.
> >
> > 2) Is there a way that I can update all cells at once?
>
>
>

Hi,

Check the options: Tools -> Options -> Calculation. You can apply settings
that automatically calculates each time it registers a change to a value that
is used in calculations. Alternatively you can change it so that you have to
manually tell it to calculate each time.

F9 re-calculates the workbook.

When you have such great capacity Excel may struggle to calculate - check
your status bar and it will report back on how far through the calculation
process it is as a percentage.

Cheers,
Jon

"notloiseweiss" wrote:

> (Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
> Many of the sheets contain cells that refer to values in other sheets. I
> recently found that some of the values were incorrect (I believe they were
> just not updated). When I double clicked on the cell, gained access to the
> formula and then hit enter, the cell updated. I'm wondering 2 things -
>
> 1) Under what circumstances will cells NOT automatically update? I thought
> they always updated automatically as long as you're working within the same
> workbook.
>
> 2) Is there a way that I can update all cells at once?

Thanks for the response.
I didn't know about this Tools -> Options -> Calculation setting, so it is
useful to know. Unfortunately, my setting is already on update.

I was aware of the 'status bar', so I don't think
that was it either...

"Springbok" wrote:

> Hi,
>
> Check the options: Tools -> Options -> Calculation. You can apply settings
> that automatically calculates each time it registers a change to a value that
> is used in calculations. Alternatively you can change it so that you have to
> manually tell it to calculate each time.
>
> F9 re-calculates the workbook.
>
> When you have such great capacity Excel may struggle to calculate - check
> your status bar and it will report back on how far through the calculation
> process it is as a percentage.
>
> Cheers,
> Jon
>
> "notloiseweiss" wrote:
>
> > (Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
> > Many of the sheets contain cells that refer to values in other sheets. I
> > recently found that some of the values were incorrect (I believe they were
> > just not updated). When I double clicked on the cell, gained access to the
> > formula and then hit enter, the cell updated. I'm wondering 2 things -
> >
> > 1) Under what circumstances will cells NOT automatically update? I thought
> > they always updated automatically as long as you're working within the same
> > workbook.
> >
> > 2) Is there a way that I can update all cells at once?

I've never seen this happen in real life, but there have been a few posts that
describe your problem.

One suggestion is to try to wake up excel's calculation engine (may be the wrong
term!):

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

And under the Options button, you can choose Workbook so that you don't have to
do each worksheet individually.

There have been replies that say this works, but also questioning why this
happens and will it fix it forever.

I don't have a guess for either question.

notloiseweiss wrote:
>
> (Excel 2002) I have a 5G Excel workbook with around 40 worksheets in it.
> Many of the sheets contain cells that refer to values in other sheets. I
> recently found that some of the values were incorrect (I believe they were
> just not updated). When I double clicked on the cell, gained access to the
> formula and then hit enter, the cell updated. I'm wondering 2 things -
>
> 1) Under what circumstances will cells NOT automatically update? I thought
> they always updated automatically as long as you're working within the same
> workbook.
>
> 2) Is there a way that I can update all cells at once?

--

Dave Peterson