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.