Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference
There is probably a really simple answer to this but it's getting towards the
end of the day and my brain is tired ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$20 this reference brings up the value in the relevant cell but..... ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$107 this one doesn't even though they are identical apart from the cell reference. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference
Some suggestions: Compare the formatting of the two cells. Are they the
same? Hit F9 to force recalculation? Dave -- Brevity is the soul of wit. "Pasty" wrote: There is probably a really simple answer to this but it's getting towards the end of the day and my brain is tired ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$20 this reference brings up the value in the relevant cell but..... ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$107 this one doesn't even though they are identical apart from the cell reference. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference
I checked all that but still having no joy!
"Dave F" wrote: Some suggestions: Compare the formatting of the two cells. Are they the same? Hit F9 to force recalculation? Dave -- Brevity is the soul of wit. "Pasty" wrote: There is probably a really simple answer to this but it's getting towards the end of the day and my brain is tired ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$20 this reference brings up the value in the relevant cell but..... ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$107 this one doesn't even though they are identical apart from the cell reference. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference
what does it bring up?
"Pasty" wrote: There is probably a really simple answer to this but it's getting towards the end of the day and my brain is tired ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$20 this reference brings up the value in the relevant cell but..... ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$107 this one doesn't even though they are identical apart from the cell reference. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference
Hi,
It brings up 0 when it should equal 120. "bj" wrote: what does it bring up? "Pasty" wrote: There is probably a really simple answer to this but it's getting towards the end of the day and my brain is tired ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$20 this reference brings up the value in the relevant cell but..... ='R:\Planning for Risk Continuity Security\Task 1000 NFR MW\[Risk Register as at 18 10 06 (one MW is amending).xls]Risk By Function'!$AB$107 this one doesn't even though they are identical apart from the cell reference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |