Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referen to cell on other sheet not working
Hi,
I received this strange problem: On sheet 02-E14-4 in an Excel fie, the cell M23 contains the value 0,500. On another sheet (Récap2008) cell I83 contains this formula: ='02-E14-4'!M$23. BUT: the value it shows is 0,250 instead of 0,500. Only when I re-enter the value in cell M23 it shows the correct value, or when I re-enter the formula in cell I83. Any idea why this happens? And how to find a solution??? Thanks a lot in advance, any help will be really appreciated! Pieter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referen to cell on other sheet not working
Sounds like you have Calculation mode set to Manual. Choose
Tools/Options/Calculation, and set the mode to Automatic. In article , "Pieter" wrote: Hi, I received this strange problem: On sheet 02-E14-4 in an Excel fie, the cell M23 contains the value 0,500. On another sheet (Récap2008) cell I83 contains this formula: ='02-E14-4'!M$23. BUT: the value it shows is 0,250 instead of 0,500. Only when I re-enter the value in cell M23 it shows the correct value, or when I re-enter the formula in cell I83. Any idea why this happens? And how to find a solution??? Thanks a lot in advance, any help will be really appreciated! Pieter |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referen to cell on other sheet not working
That was what I was thinking too. But it was actually on "Automatic except
tables". But I've putted it alreaddy on "Automatic", but nothing happend. I tryed to recaculate via the button and F9, but still the 0,250-value instead of 0,500... "JE McGimpsey" wrote in message ... Sounds like you have Calculation mode set to Manual. Choose Tools/Options/Calculation, and set the mode to Automatic. In article , "Pieter" wrote: Hi, I received this strange problem: On sheet 02-E14-4 in an Excel fie, the cell M23 contains the value 0,500. On another sheet (Récap2008) cell I83 contains this formula: ='02-E14-4'!M$23. BUT: the value it shows is 0,250 instead of 0,500. Only when I re-enter the value in cell M23 it shows the correct value, or when I re-enter the formula in cell I83. Any idea why this happens? And how to find a solution??? Thanks a lot in advance, any help will be really appreciated! Pieter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN. | Excel Worksheet Functions | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Using SUMIF and FIND/RIGHT to add values of a partial cell referen | Excel Discussion (Misc queries) | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
How do I automatically (using a formula like =SHEET1!A$1) referen. | Excel Worksheet Functions |