Hi Everybody,

I've created a Excel sheet with a external data link.. Now, I want to
open this excell sheet from VBA code and do some calculation on the
latest data, but, the problem is that the data doesn't gets updated
while I open the sheet from VBA code. [Note: I've selected the option
to update external data as soon as the sheet opens and its working if
I open the sheet normally i.e not from VBA code]

Thanks in advance,
Devendra