I have the following formula in a spreadsheet that is linked to a second spreadsheet. The index function is not updating automatically when the spreadsheets are opened or if F9 is pressed. The only way to update the formula is to select the index portion and "re-link' it. The rest of the formula is working fine. The formula is in cell F35. The table this is linked to is too large to paste here.

=IF(E35="QP","QP",IF(E35="Loser",VLOOKUP(Q35,'[608 - Online Winning Numbers.xls]MM'!$M$5:$X$57,12),OFFSET('[608 - Online Winning Numbers.xls]MM'!$M$4,MATCH(Q35,'H:\IT\Quality_Assurance\608 - Keno\QA\Balancing\[608 - Online Winning Numbers.xls]MM'!$M$5:$M$57,0),MATCH(E35,'H:\IT\Quality_Assurance\608 - Keno\QA\Balancing\[608 - Online Winning Numbers.xls]MM'!$N$4:$X$4,0))))

The entire line looks like:

E F G H I J K L M N O P Q R
Row 35 Loser 10 - 15 - 20 - 25 - 30 MB=01 $1.00 2 2.00 1021 9/13/2013

Question is: why isn't the Offset function updating without having to redo it each time I open the spreadsheet?
Kim