I am using forumales like "=today()" in excel cells. Have set on the option (AutoCalculate formulae)
So it is auto calculating every day if I open the workbook. I am fetching that cell value throuh QTP for test data......

Issue : I have to open the excel workbook manually every day , just to make my test data auto calculated every day.....QTP is accessing the test data file but , the formula is not auto calculating.....

Is there any option to auto calculate the formulae , even if the workbook is not opened ??????????

Karthikeyan Ganesan