That's not usual behavior for excel.

Maybe you could start excel in safe mode:
close excel
windows start button|Run
excel /safe

and file|open your two workbooks to see if that helps.

"dinadvani via OfficeKB.com" wrote:

Hi,

This doesn't work for me please help. Everytime I have first open the file
that has the data else the formula changes and it not longer is linked. The
data does not gets auto uploaded.

Please help

Thanks,
DA

Dave Peterson wrote:
Open the xxx.xls file while you create the formulas.

After you get it to work with the file open, you can close that xxx.xls file and
excel will adjust the formula.

You'll see the correct syntax then.

Hi Bob,

[quoted text clipped - 27 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1

--

Dave Peterson