In Vista After clicking REFRESH botton, it is giving " Compile error in hidden module:Macros" and no data is coming in SYMBOL sheet. Data only comes in Data sheet in unformated form.
^BSESN,14543.73,"8/19/2008",0.00,14517.76,14604.11,14368.72,14543.73,0
PTC.NS,83.80,"8/19/2008",+0.15,83.00,84.45,82.00,83.65,489061
HARRMALAY.NS,100.80,"8/19/2008",+0.55,98.40,103.00,98.00,100.25,86559
CMC.NS,541.20,"8/19/2008",+6.20,535.00,545.00,532.30,535.00,2696
TIMKEN.NS,104.70,"8/19/2008",-0.65,102.20,106.80,102.20,105.35,1826
POCHIRAJU.NS,21.20,"8/19/2008",+0.25,20.45,21.65,20.30,20.95,47040
RNRL.NS,95.35,"8/19/2008",+0.55,94.05,97.30,92.30,94.80,26957320
RELCAPITA.NS,1273.25,"8/19/2008",-13.35,1277.70,1288.00,1245.00,1286.60,2856270
UNITY.NS,443.85,"8/19/2008",-5.95,442.00,451.00,437.30,449.80,12718
NOCIL.NS,26.05,"8/19/2008",-0.50,26.30,26.60,25.75,26.55,431637
LITL.NS,304.10,"8/19/2008",+7.10,297.50,308.00,290.30,297.00,1397123
NIRMA.NS,132.95,"8/19/2008",+0.55,134.00,134.35,132.00,132.40,4529
MARUTI.NS,616.50,"8/19/2008",-23.60,639.85,639.85,601.95,640.10,1380725
VLSFINANC.NS,15.70,"8/19/2008",-0.35,16.25,16.25,15.50,16.05,11204
KEI.NS,38.55,"8/19/2008",-0.80,39.10,39.60,38.30,39.35,91246
DISHTV.NS,38.10,"8/19/2008",+0.95,37.00,38.70,36.35,37.15,5162438
I am using Excel 2007.
I will check it in XP.
Regard,
MK Singh