Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I update data in linked cells without opening source workbo TIII Excel Worksheet Functions 1 July 26th 06 04:21 PM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 08:05 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM
Extracting data from the current date Cali00 Excel Worksheet Functions 2 April 14th 05 05:49 AM


All times are GMT +1. The time now is 08:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"