Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default No change in result cell

I have a figure in one cell (cell c1) which is linked to another input cell
(cell c2). However when I change the cell c2, the result in c1 doesn't
change. I have set the Calculations under Tools = Options as Automatic,
could there be other reasons which triggered the un-performance? thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default No change in result cell

In cell C1 =C2
If you change the cell C2 , the Cell C1 will change also.

"jiang" wrote:

I have a figure in one cell (cell c1) which is linked to another input cell
(cell c2). However when I change the cell c2, the result in c1 doesn't
change. I have set the Calculations under Tools = Options as Automatic,
could there be other reasons which triggered the un-performance? thanks

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
Formula result as real empty/blank cell Excelerate-nl Excel Worksheet Functions 4 August 20th 06 06:52 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03: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"