Index and Match on a protected sheet

[sunrise06]

I have an Index|Match formula that references a password protected sheet. I am finding if I make a correction in the referenced sheet, it is not getting updated in my original sheet that contains my lookup formula.

Any ideas?

Thanks!

 

[JoeMo]

Perhaps you have calculation set to manual. Press the F9 key to see if your formula updates.

 

[sunrise06]

Thanks! Do you happen to know, do both spreadsheets have to be open to do the lookup?

 

[JoeMo]

If the sheets are in different workbooks, both workbooks must be open.