My problem is fixed. The thread is huge and it took over a day, but I'm working and couldn't be happier about it.

>No I ment send me your foxpro prob, maybe I can help
>
>>You're actually got along further on this then I did.
>>I've made two sheets and I can't get the Address function to work inside the Indirect function with both sheets open. I don't know what I'm doing wrong.
>>
>>I did however use just the indirect function OK.
>>In the file book2 and the sheet tab TestSheet I put B3 in cell A3.
>>
>>In the file Book1 has the formula:
>>

>>=INDIRECT('H:\My Documents\[Book2.xls]TestSheet'!$A$3)
>>

>>On the same worksheet I put 12 in B3 and 10 is C3.
>>
>>The formua in Book1 shows correctly that it is 12.
>>I saved both sheets and closed Book1.
>>I modifed Book2, cell A3 to be C3.
>>Saved that spreadsheet and closed it.
>>I opened just book1 and it asked me if I wanted to update the spreadhseet.
>>I answered yes and the answer to the formula correctly changed to 10 without having book2 open.
>>So we now know that the password and the Indirect formula don't appear too be the culprit.
>>
>>If you like you can email the spreadhseets and I can look at them.
>>
>>
>>>Ok thanks
>>>
>>>and if your not getting the answer to your foxpro prob send me a copy and I will take a look
>>>
>>>
>>>>Right off hand I don't know a work around.
>>>>I was looking into it some and trying some stuff, but I am started to get all sorts of help with a problem I'm having in FoxPro and have left it.
>>>>
>>>>I do all sorts of stuff in Excel, but in all honesty, I've never used the indirect function. I was trying it out and seeing what I could learn. I will look at it again later.
>>>>
>>>>
>>>>>Do you know of any work arounds??
>>>>>do you need more info??
>>>>>
>>>>>or is there no chance??
>>>>>
>>>>>
>>>>>Thanks
>>>>>
>>>>>>I think you're probably right about that. But, I'd remove the modify password temporarily and test it again just to see if that's the problem.