| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple +formula not reading value from the reference cell
This one has me really puzzled.
Someone has sent me a multisheet workbook, with one of the sheets named "LORTS". On another sheet there is a formula which simply reads: =+LORTS!H54 Cell H54 on the LORTS sheet has the formula: =+H46+H52, which correctly evaluates to 73. However on the other sheet, the =+LORTS!H54 formula returns the value 76. Automatic calculation is switched on. The Tools Options Calc Now (F9) manual calculation has no effect. Yet when I F2 to edit the rogue cell and enter it back again it changes to the correct value of 73. Not sure whether it makes any difference, but the designer of the workbook has also given a range name - also "LORTS", to a range of cells on the LORTS sheet. Can anyone suggest what might be happening here - or more accurately not happening! I'm using Excel 2003 - SP3 Usual TIA __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write formula for simple copy and paste to another cell | Excel Worksheet Functions | |||
| Formula for Reading A Non-Existent Reference | Excel Worksheet Functions | |||
| Formula reading formula instead of cell content | Excel Worksheet Functions | |||
| increment cell reference whilst reading numeric contents | Excel Programming | |||
| Simple way to add a reference to a cell | Excel Programming | |||
Threaded Mode
