Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cells not displaying most current data
I have one place I enter certain data in the workbook then it is used throughout the workbook by linking. For some reason the target cells are not being updated from the source cells. It shows old data. I am tring both: ='W2-E1'!$C$1 and with perenthesis =('W2-E4'!$C$1). Once I click into the cell and hit enter the formulas work again. I noticed this after I copied the sheet. Maybe that has something to do with it. Why is this happening. -- hcamelion ------------------------------------------------------------------------ hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736 View this thread: http://www.excelforum.com/showthread...hreadid=567625 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cells not displaying most current data
Hi
Make sure tha Tools/Options/Calculation is set to Automatic. Andy. "hcamelion" wrote in message ... I have one place I enter certain data in the workbook then it is used throughout the workbook by linking. For some reason the target cells are not being updated from the source cells. It shows old data. I am tring both: ='W2-E1'!$C$1 and with perenthesis =('W2-E4'!$C$1). Once I click into the cell and hit enter the formulas work again. I noticed this after I copied the sheet. Maybe that has something to do with it. Why is this happening. -- hcamelion ------------------------------------------------------------------------ hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736 View this thread: http://www.excelforum.com/showthread...hreadid=567625 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Cells not displaying most current data
Yeah its set to automatic and I clicked on the Calc Now and Calc Sheet buttons. It's still not updating. -- hcamelion ------------------------------------------------------------------------ hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736 View this thread: http://www.excelforum.com/showthread...hreadid=567625 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update data in linked cells without opening source workbo | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Extracting data from the current date | Excel Worksheet Functions |