I did it Sir. Since I was opening new excel instance then open arbitrage file from within excel. Same repeated new instance for RTNOW.
ON monday I will open both file from one instance i.e going start menu and open excel: from here I will open both Arbitrage and RTNOW file. Lets hope it will work. Since formula changed from ='C:\ODIN\Diet\[Arbitrage.xls]Sheet1'!B6 to ='C:\ODIN\Diet\[Arbitrage.xls]Sheet1'!$B$6
Thank's
ON monday I will open both file from one instance i.e going start menu and open excel: from here I will open both Arbitrage and RTNOW file. Lets hope it will work. Since formula changed from ='C:\ODIN\Diet\[Arbitrage.xls]Sheet1'!B6 to ='C:\ODIN\Diet\[Arbitrage.xls]Sheet1'!$B$6
Thank's
You have to open Arbitrage file from within ODIN and not from Excel. Prices will change in Arbitrage if and only if it is opened from ODIN. RTNOW is to be opened after that.