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.

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.

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.

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.

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.