Cells don't update!!

[aposatsk]

I have two sheets which contain linked cells. In sheet 2, one cell is: "='HL3 (500)'!B39" which means that it has to look at sheet named HL3(500) which is previous to it. However, the cell does not automatically update when i change the first sheet. In fact, only when i click into the cell to edit it, does the updated value appear.

Why!? I can't keep clicking each cell to update it.

[L. Howard Kittle]

Perhaps your sheet is set to Manual Calculation. Tools > Options >
Calculation > Automatic.

HTH
Regards,
Howard

"aposatsk" <[email protected]> wrote in
message news:[email protected]...
>
> I have two sheets which contain linked cells. In sheet 2, one cell is:
> "='HL3 (500)'!B39" which means that it has to look at sheet named
> HL3(500) which is previous to it. However, the cell does not
> automatically update when i change the first sheet. In fact, only when
> i click into the cell to edit it, does the updated value appear.
>
> Why!? I can't keep clicking each cell to update it.
>
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile:
> http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=573213
>

[aposatsk]

Thank you, but its NOT on manual calculation. There must be another solution.

Let me rephrase:
blank cells that should contain values do not, and the values only appear once i click into the cells as i would when i edit a cell. then, upon pressing enter, the value appears!

[Niek Otten]

http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"aposatsk" <[email protected]> wrote in message
news:[email protected]...
|
| I have two sheets which contain linked cells. In sheet 2, one cell is:
| "='HL3 (500)'!B39" which means that it has to look at sheet named
| HL3(500) which is previous to it. However, the cell does not
| automatically update when i change the first sheet. In fact, only when
| i click into the cell to edit it, does the updated value appear.
|
| Why!? I can't keep clicking each cell to update it.
|
|
| --
| aposatsk
| ------------------------------------------------------------------------
| aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
| View this thread: http://www.excelforum.com/showthread...hreadid=573213
|

[Dave Peterson]

Sometimes this works.

Select a single cell.
edit|replace
what: = (equal sign)
with: =
replace all

It's like reentering each formula--but easier.

aposatsk wrote:
>
> I have two sheets which contain linked cells. In sheet 2, one cell is:
> "='HL3 (500)'!B39" which means that it has to look at sheet named
> HL3(500) which is previous to it. However, the cell does not
> automatically update when i change the first sheet. In fact, only when
> i click into the cell to edit it, does the updated value appear.
>
> Why!? I can't keep clicking each cell to update it.
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=573213

--

Dave Peterson

[CarolineM]

Hi there,

I'm also having the same issue within a rather large Excel workbook, however I'm relying on the formulas dynamically calculating without user input. Without them being able to automatically calcuate, my workbook is essentially wrong. Is anyone aware of a method to force an automatic calculation? VBA? Macros? Something?

Thanks for your help!

[teylyn]

CarolineM, welcome to the forum

This thread is more than three years old. Please take a moment to read the forum rules and then start your own thread.

thanks