Formula not updating
 

I am having a problem with a match function not updating. My workbook is set
to automatic calculation. This is the formula:
=INDEX('101 Competition'!$A$10:$FV100,MATCH($A$6,'101
Competition'!$A10:$A100,),MATCH(Q11,'101 Competition'!$A$10:$FV$10,))
The formula does not update. I hit F9 and still no update. But when you
highlight the cell, click the Fx button, and hit enter the cell updates
correctly. Why won't Excel automatically pull a value, or at least pull it
when F9 is pressed?



--
Paul

<My workbook is set to automatic calculation.
I believe you.
But Excel as a whole may not be set to Automatic calculation. Calculation is
an Excel-wide setting. If you open a workbook with Automatic calculation and
then open one with Manual calculation, both will be set to Manual.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Paul" wrote in message
...
I am having a problem with a match function not updating. My workbook is
set
to automatic calculation. This is the formula:
=INDEX('101 Competition'!$A$10:$FV100,MATCH($A$6,'101
Competition'!$A10:$A100,),MATCH(Q11,'101 Competition'!$A$10:$FV$10,))
The formula does not update. I hit F9 and still no update. But when you
highlight the cell, click the Fx button, and hit enter the cell updates
correctly. Why won't Excel automatically pull a value, or at least pull it
when F9 is pressed?



--
Paul

Hi Niek-

thanks for trying to help. However, I have no other workbooks open. Also,
hitting F9 does not update the formula. But when I update one of the values
the match functions draw on, then the index function also updates. Very
bizarre. Any other ideas?

Thanks,

Paul


"Niek Otten" wrote:

<My workbook is set to automatic calculation.
I believe you.
But Excel as a whole may not be set to Automatic calculation. Calculation is
an Excel-wide setting. If you open a workbook with Automatic calculation and
then open one with Manual calculation, both will be set to Manual.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Paul" wrote in message
...
I am having a problem with a match function not updating. My workbook is
set
to automatic calculation. This is the formula:
=INDEX('101 Competition'!$A$10:$FV100,MATCH($A$6,'101
Competition'!$A10:$A100,),MATCH(Q11,'101 Competition'!$A$10:$FV$10,))
The formula does not update. I hit F9 and still no update. But when you
highlight the cell, click the Fx button, and hit enter the cell updates
correctly. Why won't Excel automatically pull a value, or at least pull it
when F9 is pressed?



--
Paul