| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells don't update!!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells don't update!!
Perhaps your sheet is set to Manual Calculation. Tools Options
Calculation Automatic. HTH Regards, Howard "aposatsk" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells don't update!!
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! -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=573213 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells don't update!!
http://xldynamic.com/source/xld.xlFAQ0024.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "aposatsk" wrote in message ... | | 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 | |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cells don't update!!
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link two cells to automatically update | Excel Discussion (Misc queries) | |||
| How do I update data in linked cells without opening source workbo | Excel Worksheet Functions | |||
| Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
Linear Mode
